web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Apps Cascading dropdown fro...

Power Apps

Unanswered

Cascading dropdown from PowerApp from choice column

(0) Share

Report

Report

Posted on by Brianahrd

I am currently making a Power App and need some help.

I want to make cascading dropdown on my sharepoint list.

I used the create app from Sharepoint List option that gives generates the three screen app and connects the data automatically.

I have all my column as choice columns.

First choice column is simple with 9 data values but second and third have 40+ values each.

I need to be able to choose the first column and filter out values for the second column.

Then, I need the third column values to be based on the result of the second column.

Please help me figure out a way to make this work for my team! I have been trying for days now and nothing.

Categories:

Building Power Apps

I have the same question (0)

All responses Img

All responses (2)

Answers Img

Answers (0)

Sort by

WarrenBelz 155,284 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!
Hi @Brianahrd ,

I have assumed field names here and allowed for multiple occurrences in the second DD

Sort( Distinct( Filter( SPList, 'Team Name' = YourFirstDD.Selected.Value ), 'Acct Name 2' ).Result, Result )

Third DD

Sort( Filter( SPList, 'Team Name' = YourFirstDD.Selected.Value && 'Account Name 2' = YourSecondDD.Selected.Result ).'Acct Name (Generic)', .'Acct Name (Generic)' )

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 155,284 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

Hi @Brianahrd ,

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

Join the conversation