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

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / Filter gallery with mu...
Power Apps
Answered

Filter gallery with multiple buttons

(0) ShareShare
ReportReport
Posted on by 158

Hello,

 

Please can anyone help me with this one? I have 4 buttons with formula OnSelect: UpdateContext({FilterByWorkIn:!FilterByWorkIn}) and same but different names for other buttons. When I try to apply these to my gallery it will filter only with Work Instructions and Manual Handling. Buttons with Risk Assessment and CoSHH are not working. 

 

marcy_pi_1-1710162159681.png

Regards

 

Categories:
I have the same question (0)
  • v-mengmli-msft Profile Picture
    Microsoft Employee on at

    Hi @marcy_pi ,

     

    Do you want to get this?

    Filter all records with a value of CoSHH Assessment or Risk Assessment for the choice column when relevant variables are true?

     

    Please try this:

    1/OnVisible of screen.

    ClearCollect(COL,{A:"work Instructions",B:FIlterByworkIn},{A:"Manual Handling Assessment",B:FIlterByManHan},{A:"CoSHH Assessment",B:FIlterByCosh},{A:"Risk Assessment",B:FIlterByRiskAss})

    2/Add below formula to OnSelect of each button.

    Patch(COL,LookUp(A="work Instructions"),{B:FIlterByworkIn})

    Similar to other buttons.

     

    3/Modify your Filter formula.

    vmengmlimsft_0-1710166232154.png

     

     

     

     

    Best regards,

    Rimmon

     

  • BhaskarDhone Profile Picture
    1,392 Super User 2026 Season 1 on at
    Filter(
     'ISO-Documentation',
     (
     Concat('Job description'.Value , Value) = DataCardValue6_1.Selected.Value
     ),
     (FIlterByworkIn && 'Document Type'.Value = "Work Instruction") ||
     (FIlterByManHan && 'Document Type'.Value = "Manual Handling Assessment") ||
     (FIlterByCosh && 'Document Type'.Value = "CoSHH") ||
     (FIlterByRiskAss && 'Document Type'.Value = "Risk Assessment") ||
    )

     

    This should solve your problem.

  • MP-13011217-0 Profile Picture
    158 on at

    Hi, thank You for this suggestion but it's showing me errors again so not working on my example. Thank You anyways!

  • BhaskarDhone Profile Picture
    1,392 Super User 2026 Season 1 on at

    What is the error message ?

  • Verified answer
    MP-13011217-0 Profile Picture
    158 on at

    I've sorted it now from another post by applying "varFilterBy" to each button and Switch option with "varFilterBy" in Filtered gallery. Thank You for the support 🙂 !

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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Users!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 542 Most Valuable Professional

#2
Haque Profile Picture

Haque 206

#3
Kalathiya Profile Picture

Kalathiya 201 Super User 2026 Season 1

Last 30 days Overall leaderboard