Answered

Filtering with "All" but with a Dataverse Choice column.

(0) Share

Report

Posted on by Andy83

Hello all,

I am looking how to add an "All" option to my dropdown. This currently does filter between the various status's but the "All" doesn't bring anything back on the gallery. Most articles I've found are Sharepoint based. I've tried using a ClearCollect,Collect on the onstart. I'm guessing I need "All" = AllItems or something like that. Thanks for reading and any help you can give.

Ungroup(
Table({Items:["All"]},
{Items:Choices('Status (DMS-Delegations)')}
),
"Items")

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (1)

Sort by

Verified answer

SpongYe 5,909 Super User 2026 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @Andy83

In the filter you can use a If() statement:
If( Dropdown.Selected.Value = "All", YourDataSource, Filter(YourDataSource, 'Status (DMS-Delegations)' = Dropdown.Selected.Value) )
If you have any questions or feedback, please let me know. Have a great day! 😊

-----------------------
PowerYsa Power Platform Enthusiast [LinkedIn] | [Youtube]

I love to share my knowledge and learn from others. If you find my posts helpful, please give them a thumbs up 👍 or mark them as a solution ✔️. You can also check out my [@PowerYSA] for some cool solutions and insights. Feel free to connect with me on any of the platforms above. Cheers! 🍻

Was this reply helpful? Yes No
Andy83 30 on at

Like
a
(1)

Report
Copy link

Link copied!

Thanks for your help 👍

Was this reply helpful? Yes No