Multiple Choice Dropdowns · Learn Power Apps

Multiple Choice Dropdowns

Hi all

I am having some difficulty using nested dropdowns in PowerApps. I have a sharepoint list which lists all GL Codes for Purchase Orders. In this list are Department, Category and Description - plus the actual GL Code. In Power Apps I have 3 dropdowns, one for the Department, one for the Category and then a final one that displays the GL Code. I want to use the last one to show the GL Code but also the Description, but it doesnt seem to work. It either shows blank or shows the same as the Category field. Here is my code for the dropdown Items property.

Department -

Distinct('Purchase GL Codes (Master)',Departments)

Category -

Distinct(Filter('Purchase GL Codes (Master)', Departments = DrpDepartment.Selected.Value),CatList)

GL Code -

Filter('Purchase GL Codes (Master)', GLCode,

Departments=DrpDepartment.SelectedText.Value,

CatList=DrpCategory.SelectedText.Value

)

I would like to use a combo box for the GL Code field (so it shows the Description as well) but I am struggling to find a way to make it work. Also, I am getting delegation warnings, but I am not sure what I can do to try and rectify this

As always, any help or advice would be greatly appreciated

EDIT - I have finally managed to get the third drop down to work with the following code:

Sort(

Distinct(

Filter(

'Purchase GL Codes (Master)',

Departments = DrpDepartment.Selected.Value &&

CatList=DrpCategory.SelectedText.Value

'GL Code'

Value

)

I still have the delegation warnings though and I would also like to display the GL Code Description field in this dropdown box but only patch the actual GL Code. I am having some trouble formatting the query so that I can use the AddColumn command though

8 comments