Answered

Filter Gallery with Toggle

(0) Share

Report

Posted on by Community Power Pla...

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:

Using Apps Using Formulas

General Questions

Connecting to Data

All responses (2)

Answers (1)

Verified answer

v-qiaqi@microsoft.com on at

Like (0)

Report
Re: Filter Gallery with Toggle

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 ||
AaronKnox 510 Super User 2024 Season 1 on at

Like (0)

Report
Re: Filter Gallery with Toggle

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" )