web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Apps Filtering Gallery

Power Apps

Answered

Filtering Gallery

(0) Share

Report

Report

Posted on by ImageZ

22

Hey,

Seen similar posts but not quite what I'm after.

Effectively, I have a gallery which I'd like to filter with 5 buttons but can't get the IF statement on the Gallery Items correct!

Button 1 - Column "Interviewer" is blank

Button 2 = Column "Note Taker" is blank

Button 3 = Column "Channel" is "Direct"

Button 4 = Column "Accepted" is true

Button 5 = Clear all filters.

Many thanks!

Categories:

Building Power Apps

All responses Img

All responses (2)

Answers Img

Answers (1)

Sort by

Verified answer

WarrenBelz 156,532 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @ImageZ ,

Set a Variable on each button

UpdateContext({varFilter: 1})

and so on for each button - also at Screen OnVisible and on Button 5

UpdateContext({varFilter: 5})

Then your Filter

Filter( DataSource, varFilter = 5 || (varFilter = 1 && Interviewer = Blank()) || (varFilter = 2 && 'Note Taker' = Blank()) || (varFilter = 3 && Channel = "Direct") || (varFilter = 4 && Accepted) )

Please click Accept as solution 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 Thumbs Up.

Visit my blog Practical Power Apps
ImageZ 22 on at

Like
a
(0)

Report
Copy link

Link copied!

You sir - are magic.

Join the conversation