Skip to main content

Notifications

Community site session details

Community site session details

Session Id :
Power Apps - Building Power Apps
Unanswered

Filter gallery not working fine for amount range

(0) ShareShare
ReportReport
Posted on by 494

I have a powerapps gallery with SharePoint as the datasource. Currently amount filter is working fine in gallery without any issues as per below screenshot and below code.

 

Iantaylor2050_0-1696349710741.png

 

Items property of Main gallery

Filter(
Items,(
IsBlank(varcheckedGal) ||
Switch(
varcheckedGal,
"Under $50",
Amount >= 0 && Amount < 50,
"$50 - $100",
Amount >= 50 && Amount < 100,
"$100 - $200",
Amount >= 100 && Amount < 200,
"Above $200",
Amount >= 200
)

 

Filter by Amount Gallery - Items Property

Distinct(Filter(Filter,Amount),Amount)

 

Filter by Amount Gallery - OnCheck Property

UpdateContext({varchecked:Gallery3_1.Selected.Value})

 

Filter by Amount Gallery - OnUnCheck Property

UpdateContext({varchecked:Blank()})

 

Till this, the above code works without any issues. Now i have added a Select All checkbox in the above image and made changes to the below code, but Select All functionality is not working fine. May i know what changes has to be done to the code?

 

Select All Amount Checkbox - OnCheck

ForAll(Gallery5_1.AllItems, UpdateContext({varcheckedGal:Gallery5_1.Selected.Value}))

 

Select All Amount Checkbox - OnUnCheck

ForAll(Gallery5_1.AllItems, UpdateContext({varcheckedGal:Blank()))

Categories:
  • Iantaylor2050 Profile Picture
    494 on at
    Re: Filter gallery not working fine for amount range

    Hi All,

     

    Can please assist me on the above query?

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

🌸 Community Spring Festival 2025 Challenge 🌸

WIN Power Platform Community Conference 2025 tickets!

Markus Franz – Community Spotlight

We are honored to recognize Markus Franz as our April 2025 Community…

Kudos to the March Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 146,594 Most Valuable Professional

#2
RandyHayes Profile Picture

RandyHayes 76,287 Super User 2024 Season 1

#3
Pstork1 Profile Picture

Pstork1 65,928 Most Valuable Professional

Leaderboard