web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / Filter gallery not wor...
Power Apps
Unanswered

Filter gallery not working fine for amount range

(0) ShareShare
ReportReport
Posted on by 531

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:
I have the same question (0)
  • Iantaylor2050 Profile Picture
    531 on at

    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

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 717 Most Valuable Professional

#2
Michael E. Gernaey Profile Picture

Michael E. Gernaey 329 Super User 2025 Season 2

#3
Power Platform 1919 Profile Picture

Power Platform 1919 268

Last 30 days Overall leaderboard