Skip to main content

Notifications

Power Apps - Error Handling
Unanswered

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

Posted on 21 Nov 2024 19:22:53 by 8

"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)
  • Suggested answer
    jpespena Profile Picture
    jpespena 148 on 22 Nov 2024 at 02:59:59
    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
                )
    )
     

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

October 2024 Newsletter…

October 2024 Community Newsletter…

Community Update Oct 28…

Power Platform Community Update…

Tuesday Tip #4 How to Conntact Support…

Welcome to a brand new series, Tuesday Tips…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 143,061

#2
RandyHayes Profile Picture

RandyHayes 76,308

#3
Pstork1 Profile Picture

Pstork1 63,795

Leaderboard

Featured topics