Using Filter on a toggle switch

(0) Share

Report

Posted on by AdamH

580

Hi All,

I am using this formula to filter results in to a gallery based on a value in the Grade column.

{
 Title: "Apprentice ECSW",
 Items: Filter(
 'NC MST Tracker',
 Grade.Value = "A-ECSW"
 )
 },
 {
 Title: "Waiting EPA",
 Items: Filter(
 'NC MST Tracker',
 'Waiting EPA', "Yes"
 )
 },

I would like to alter one of the filters to look at a toggle result rather than the Grade.Value field.

My toggle result is in a field called Waiting EPA. Toggle Yes/No

I have tried a few different approaches but have not been successful.

Anyone with any tips?

Categories:

Building Power Apps

All responses (2)

Answers (1)

Sort by

BClouded 174 on at

Like
a
(0)

Report
Copy link

Link copied!

You can set a variable OnCheck and OnUncheck for the toggle, and use that variable in your filter.
Verified answer

WarrenBelz 156,528 Most Valuable Professional on at

Like
a
(1)

Report
Copy link

Link copied!
Hi @AdamH ,

If 'Waiting EPA' is a Boolean (Yes/No) field, you just need this

{ Title: "Waiting EPA", Items: Filter( 'NC MST Tracker', 'Waiting EPA' ) }

basically a true/false field just needs to be referred to - if it is true, then the filter show all true instances - if you wanted false, just put

!'Waiting EPA'

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.