web

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

News and Announcements icon

Power Platform CommunityForums Power Apps Dropdown menus for Pow...

Power Apps

Unanswered

Dropdown menus for Powerapps Gallery

(0) Share

Report

Report

Posted on by Community Power Pla... Microsoft Employee

Hi, I want to build a PowerApps-Gallery filtering everything with dropdowns, I'm using this Tutorial, but it won't work for my problem: PowerApps filter gallery by dropdown - YouTube. Typically very great instruction and I have normally no problems, but today I'm struggling:

Screen - OnVisible: ClearCollect(collectODs; {Result:"All"});;
Collect(collectODs;Distinct(tD;'Primary Division (then)'))

Dropdown - Items: collectODs

Gallery - Items: If(Dropdown3.Selected.Value = "All";collectODs; Filter(tD;'Primary Division (then)' = Dropdown3.Selected.Value))

Thank you for the help!

Categories:

Building Power Apps

I have the same question (0)

All responses Img

All responses (2)

Answers Img

Answers (0)

Drrickryp Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!
@Anonymous

Instead of a collection use this as the Items property of a dropdown control. IMHO, much better and won't require re-collecting if another division is added.

Ungroup( Table( {options: Table({Value: "All"})}; {options: Sort(Distinct(tD;'Primary Division (then)'), Value)} ); "options" )

For the Items of the gallery:

Filter(tD; Dropdown3.Selected.Value = "All" || 'Primary Division (then)'= Dropdown3.Selected.Value )

Also cleaner, gets rid of the If().

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

I'm not 100% sure how it works, but it's genius! Now I want to add a second dropdown to filter another row, with a Dropdown. I changed the code so it fits for the second column, but I'm not sure what to do with the items property of the gallery, can you help me out again?

Thank you!

Was this reply helpful? Yes No

Join the conversation