Unanswered

Dropdown menus for Powerapps Gallery

(0) Share

Report

Posted on by Community Power Pla...

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 (2)

Answers (0)

Drrickryp Super User 2024 Season 1 on at

Like (0)

Report
@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... on at

Like (0)

Report

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