Unanswered

How to create a selection filter with the 'All' option to filter all items?

(0) Share

Report

Posted on by danielanjos100

"Hello, everyone! I would like to create a selection filter that includes the 'All' option to filter all items at once. I am using the following codes:

dropdownItems: Distinct('Presentation Repository'; Forum.Value)
galleryItems: Filter('Presentation Repository'; Forum.Value = DropdownCanvas2.Selected.Value)

Categories:

Error handling

I have the same question (0)

All responses (2)

Answers (1)

Suggested answer

jpespena 335 on at

Like (0)

Report
How to create a selection filter with the 'All' option to filter all items?

Hi

Try this:

dropdownItems:

Ungroup( Table( {Dropdown: ["All"]}, { Dropdown: Distinct('Presentation Repository'; Forum.Value) } ), Dropdown )

galleryItems:

Filter( 'Presentation Repository', Or( DropdownCanvas2.Selected.Value = "All", Forum.Value = DropdownCanvas2.Selected.Value ) )

Was this reply helpful? Yes No
Verified answer

WarrenBelz 152,847 Most Valuable Professional on at

Like (0)

Report
How to create a selection filter with the 'All' option to filter all items?

Hi danielanjos100

A simpler approach in the drop-down Items
Table( {Value: "All"}; Distinct( 'Presentation Repository'; Forum.Value ) )

then (same as jpespena)
Filter( 'Presentation Repository'; DropdownCanvas2.Selected.Value = "All" || Forum.Value = DropdownCanvas2.Selected.Value )

Please click Does this answer your question 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 a Like.
MVP (Business Applications) Visit my blog Practical Power Apps Buy me a coffee

Was this reply helpful? Yes No