web

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

News and Announcements icon

Power Platform CommunityForums Power Apps Filter Gallery with To...

Power Apps

Answered

Filter Gallery with Toggle

(0) Share

Report

Report

Posted on by Community Power Pla... Microsoft Employee

Hi All,

I have a toggle outside a gallery. I need it to filter my gallery with my toggle when switched to false(no) and also by a column called Code "Q". I had the following but it's not working. ClearCollect called ccTestTable. Toggle called testIndicator

How do I get this to filter when the toggle is set to false? Any help will be so helpful. Thank you

Filter(
ccTestTable,
If(testIndicator.Value=false ||
Code = "Q"
))

Categories:

Building Power Apps

I have the same question (0)

All responses Img

All responses (2)

Answers Img

Answers (1)

Sort by

AaronKnox 514 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!
You don't need the If() function as both the toggle and Code = Q can be evaluated on their own:
Filter(ccTestTable, !testIndicator.Value || Code="Q" )

Was this reply helpful? Yes No
Verified answer

v-qiaqi@microsoft.com Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @Anonymous,

Do you want to filter the Gallery only when the Toogle value is switched to false?

If so, please modify your formula as below:

Filter( ccTestTable, If(testIndicator.Value=true,true,YesOrNo_Column=false) || Code = "Q" ))

Note that if you want to filter gallery based on tooggle and the Code column, you should use && instead of ||

Was this reply helpful? Yes No

Join the conversation