Filter Gallery using Switch in the filter

(1) Share

Report

Posted on by SaraMeiselman

Hi,

I have an app that is kind of like a dashboard with a gallery of items from a SharePoint list that have multiple filters on them from the start. Then, I offer some customizable filters and it's all fine. But, I have one column where I want to filter something whether it is overdue or compliant, or not at all. There is not an available column with that category; just the following code has been used for other parts of the app just fine:

"Overdue"= VerificationDate < Today()-180
"Verfied" = VerificationDate > Today()-180)

When the user clicks on the "Overdue", "Verified", or Reset filter, the code is respectively:

Set(varstatus, "Overdue") OR Set(varstatus, "Verified") OR Set(varstatus, Blank())

So the filter for the Gallery Items that is currently working is below, but as soon as I add any If, or Switch, to filter out the above, it stops working. Without the needed filter:

Filter(
    GFEv2,
    (InactiveToggle = false),
    (Inactive.Value = "no"),
    (Inventory.Value = varTOVIEW),
    (POC.DisplayName = DropdownCanvas1.Selected.Value Or IsBlank(DropdownCanvas1.Selected.Value)),
    (EquipmentType.Value = DropdownCanvas1_1.Selected.Value Or IsBlank(DropdownCanvas1_1.Selected.Value)))

and with the filter that makes it all stop working:

Filter(
    GFEv2,
    (InactiveToggle = false),
    (Inactive.Value = "no"),
    (Inventory.Value = varTOVIEW),
    (POC.DisplayName = DropdownCanvas1.Selected.Value Or IsBlank(DropdownCanvas1.Selected.Value)),
    (EquipmentType.Value = DropdownCanvas1_1.Selected.Value Or IsBlank(DropdownCanvas1_1.Selected.Value)), Switch(varstatus, "Verified", VerificationDate > Today()-180, "Overdue", VerificationDate< Today()-180))

How would you go about this?

Thanks!

Categories:

Building Power Apps

I have the same question (0)

All responses (5)

Answers (0)

Sort by

Kalel_Lucas 165 on at

Like (1)

Report
Copy link

Link copied!
Hello SaraMeiselman,

While far from fast or elegant, you could attempt using your Switch outside the Filter formula, like this:
Switch(varstatus, "Verified", Filter( GFEv2, (InactiveToggle = false), (Inactive.Value = "no"), (Inventory.Value = varTOVIEW), (POC.DisplayName = DropdownCanvas1.Selected.Value Or IsBlank(DropdownCanvas1.Selected.Value)), VerificationDate > Today()-180 ), "Overdue", Filter( GFEv2, (InactiveToggle = false), (Inactive.Value = "no"), (Inventory.Value = varTOVIEW), (POC.DisplayName = DropdownCanvas1.Selected.Value Or IsBlank(DropdownCanvas1.Selected.Value)), VerificationDate < Today()-180 ), Filter( GFEv2, (InactiveToggle = false), (Inactive.Value = "no"), (Inventory.Value = varTOVIEW), (POC.DisplayName = DropdownCanvas1.Selected.Value Or IsBlank(DropdownCanvas1.Selected.Value)) )

Hope it helps,

Kalel

Was this reply helpful? Yes No
SaraMeiselman 17 on at

Like (2)

Report
Copy link

Link copied!

Thank you for the suggestion! It didn't seem to work but I can't figure out why because it should have! When I tried clicking on the buttons that set the variable, the gallery went blank.

Was this reply helpful? Yes No
Suggested answer

Sam_Fawzi 902 Super User 2026 Season 1 on at

Like (1)

Report
Copy link

Link copied!
Hi Sara,

Can you try this

Filter( GFEv2, (InactiveToggle = false), (Inactive.Value = "no"), (Inventory.Value = varTOVIEW), (POC.DisplayName = DropdownCanvas1.Selected.Value Or IsBlank(DropdownCanvas1.Selected.Value)), (EquipmentType.Value = DropdownCanvas1_1.Selected.Value Or IsBlank(DropdownCanvas1_1.Selected.Value)), Switch( varstatus, "Verified", VerificationDate > Today() - 180, "Overdue", VerificationDate < Today() - 180, true // Default case for Reset filter ) )

Or

Filter( GFEv2, (InactiveToggle = false), (Inactive.Value = "no"), (Inventory.Value = varTOVIEW), (POC.DisplayName = DropdownCanvas1.Selected.Value Or IsBlank(DropdownCanvas1.Selected.Value)), (EquipmentType.Value = DropdownCanvas1_1.Selected.Value Or IsBlank(DropdownCanvas1_1.Selected.Value)), If(varstatus = "Verified", VerificationDate > Today() - 180, varstatus = "Overdue", VerificationDate < Today() - 180, true) // Default case for Reset filter )

Ensure varstatus is Set Correctly

Set(varstatus, "Overdue") // For Overdue Set(varstatus, "Verified") // For Verified Set(varstatus, Blank()) // For Reset filter

Was this reply helpful? Yes No
Kalel_Lucas 165 on at

Like (1)

Report
Copy link

Link copied!

Hello Sara,

I think one part that may be missing from the puzzle is where is the user clicking to change the value of the variable varstatus.

Is it a button? A toggle? A dropdown perhaps?

If you could attach an image of the method you're utilizing, it can help us understand the context a little bit more.

Kind regards,

Kalel

Was this reply helpful? Yes No
SaraMeiselman 17 on at

Like (1)

Report
Copy link

Link copied!

Thanks for the suggestions. Neither worked - when I put them into the items property, the gallery remained blank.

To answer the question about how the variable is set - it's buttons that say "Overdue", "Verified", and "Clear Filter". when you click on one, it resets the variable.

Was this reply helpful? Yes No