Cascade Dropdown

(0) Share

Report

Posted on by LxNeomi

106

Hello!

I would like to incorporate a cascading dropdown into a helpdesk project that i am working on. I have a form that has "Department" and "Issue" dropdown choice column in sp list. I would like to add another dropdown that has filtered issues depending on their "Department".

EX. Department Issue ColumnName
 IT Request PCs, Monitor, Printer

Thank you!

Categories:

Building Power Apps

I have the same question (0)

All responses (18)

Answers (1)

WarrenBelz 153,026 Most Valuable Professional on at

Like (0)

Report
Hi @LxNeomi ,

Probably something like this

Filter( ListName, Department.Value = YourDepartmentDD.Selected.Value ).Issue

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

Visit my blog Practical Power Apps

Was this reply helpful? Yes No
WarrenBelz 153,026 Most Valuable Professional on at

Like (0)

Report

Hi @LxNeomi ,

Just checking if you got the result you were looking for on this thread. Happy to help further if not.

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

Visit my blog Practical Power Apps

Was this reply helpful? Yes No
LxNeomi 106 on at

Like (0)

Report
Hi @WarrenBelz,

Sorry for the no response this past few days, I've been fiddling with the cascade dropdown before combining it with my form. I made another sp list named "CascadeDropIssue" with Title (single line text), IssueCategory (choice), and Issue (choice) columns.

This is the result

Title column dropdown = DDDept
Sort(Distinct(CascadeDropIssue,Title),Result)
DDIssueCategory, shows didn't find any data error
Filter(CascadeDropIssue,IssueCategory.Value = DDDept.Selected.Result)
DDIssue
Sort(Distinct(CascadeDropIssue,Issue.Value = DDIssueCategory.Selected.IssueCategory.Value), Result)

I tried following this videos for more example: Power Apps: Cascade Drop Down List (Using Distinct) - YouTube and PowerApps Cascading Dropdown - See comments for 2021 version - YouTube.

Was this reply helpful? Yes No
WarrenBelz 153,026 Most Valuable Professional on at

Like (0)

Report
Hi @LxNeomi ,

You have caused yourself a lot of unwanted work by using Choice columns, but then not using the choices from them - these would be far better served as text columns. However, the below should work

First one - OK

Sort( Distinct( CascadeDropIssue, Title ), Result )

Second item

Filter( AddColumns( CascadeDropIssue, "Category", IssueCategory.Value ), Title = DDDept.Selected.Result ).Category

Third item

Sort( Distinct( Filter( AddColumns( CascadeDropIssue, "Issues", Issue.Value ), IssueCategory.Value = DDIssueCategory.Selected.Category ), Issues ), Result )

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

Visit my blog Practical Power Apps

Was this reply helpful? Yes No
LxNeomi 106 on at

Like (0)

Report

Hi @WarrenBelz,

Thank you for the reply. 1st and 2nd item are working perfectly. My third item is repeating the 2nd item. The 3rd item should output a different result.

Was this reply helpful? Yes No
WarrenBelz 153,026 Most Valuable Professional on at

Like (0)

Report
Hi @LxNeomi ,

Sorry, you have lost me here - I cannot see any duplicates in what you have posted. This is not a difficult exercise if I can establish exactly what you expect compared with what you are receiving now. From what you have posted, all three drop-downs are filtered off the same list with each filtering record values on the output of the previous item - so Department has IssueCategory which has Issue - I have to assume here that an Issue can only belong to one issue category. So your requirement is a Distinct list of all Issue values belonging to the IssueCategory selected in the second drop-down where you have posted the Items as

Filter( CascadeDropIssue, IssueCategory.Value = DDDept.Selected.Result )

You have not said which field is displayed - I assume IssueCategory is what you need, but as this is a Choice field, you cannot display it without using the AddColumns structure I posted. Can you please confirm all of this before I go further here.

Was this reply helpful? Yes No
LxNeomi 106 on at

Like (0)

Report

Hi @WarrenBelz,

Sorry for the confusion. I have no problem displaying the Department and IssueCategory dropdown as both works perfectly. IssueCategory is being filtered depending on what item i select on the department dropdown. What i need is the Issue column.

Im lost as to why the Issue dropdown would have the same result as the IssueCategory dropdown. The Issue dropdown should basically display the items under the IssueCategory column. I copy and pasted the formula you provided. My issue dropdown should display "internet is down" or "No connection" depending on what is the item on my Department dropdown.
I think what's happening is that the issue dropdown is copying the result of the IssueCategory dropdown, instead of displaying the filter item under Issue.

Was this reply helpful? Yes No
WarrenBelz 153,026 Most Valuable Professional on at

Like (0)

Report

Hi @LxNeomi ,

What are the Items of that dropdown and the Update of the Data Card. Also the Default (if a dropdown) or DefaultSelectedItems if a Combo Box.

Was this reply helpful? Yes No
LxNeomi 106 on at

Like (0)

Report
Hi @WarrenBelz,

Dropdown Items
Title / Department: Sort(Distinct(CascadeDropIssue,Title),Result) IssueCategory: Filter(AddColumns(CascadeDropIssue, "Category", IssueCategory.Value), Title = DataCardValue5.Selected.Result).Category Issue: Sort(Distinct(Filter(AddColumns(CascadeDropIssue, "Issues", IssueCategory.Value), IssueCategory.Value = DataCardValue2.Selected.Category), Issues), Result)
Card Updates
Title / Department: DataCardValue5.Selected.Result IssueCategory: DataCardValue5.Selected Issue: DataCardValue2.Selected
Default I DefaultSelectedItems are all Parent.Default

Was this reply helpful? Yes No
WarrenBelz 153,026 Most Valuable Professional on at

Like (0)

Report

Hi @LxNeomi ,

Thanks but are they drop-downs or combo boxes as this will affect the answer. Also you have DataCardVaue5 and DataCardValue2 twice in there - what are the names of the three drop-downs ?

Was this reply helpful? Yes No