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)

Kalel_Lucas 165 on at

Like (1)

Report
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

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 750 Super User 2025 Season 2 on at

Like (1)

Report
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

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

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