Filter Gallery with multiple Toggles

(0) Share

Report

Posted on by Skybluekid

262

HI All,

I have a gallery with four toggles. I would like to filter the gallery with a combination of all four. I am currently using the following:

With({zFilter : Filter(tbl,Assigned="Person")},
Filter(zFilter,
If(TogPrep.Value = true,'Column'="In Preparation",true) ||
If(TogAwaiting.Value = true,'Column'="Awaiting Approval",true) ||
If(TogApproved.Value = true,'Column'="Approved",true) ||
If(TogCompleted.Value = true,'Column'="Completed",true)
)
)

It will filter but only one at time. Any help would be appreciated.

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (1)

Sort by

v-mengmli-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @Skybluekid ,

You can refer to my method in this post. Filter gallery with multiple buttons - Power Platform Community (microsoft.com)

Create a collection about toggles and filter the collection with value is true.

Best regards,

Rimmon

Was this reply helpful? Yes No
v-mengmli-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @Skybluekid ,

Please try this.

1/OnVisible of screen.

ClearCollect(COL,{A:"In Preparation",B:TogPrep.Value},{A:"Awaiting Approval",B:TogAwaiting.Value},{A:"Approved",B:TogApproved.Value},{A:"Completed",B:TogCompleted.Value})

2/Add below formula to OnChange of each toggle.

Patch(COL,LookUp(A="In Preparation"),{B:Self.Value})

Similar to other toggles.

3/Items of gallery.

With({zFilter : Filter(tbl,Assigned="Person")}, Filter(zFilter, 'Column' in Filter(COL,B=true,A) ))

Best regards,

Rimmon

Was this reply helpful? Yes No
Verified answer

BhaskarDhone 1,398 Super User 2026 Season 1 on at

Like
a
(1)

Report
Copy link

Link copied!
With({zFilter : Filter(tbl,Assigned="Person")}, Filter(zFilter, (TogPrep.Value &&'Column'="In Preparation") || (TogAwaiting.Value &&'Column'="Awaiting Approval") || (TogApproved.Value &&'Column'="Approved") || (TogCompleted.Value &&'Column'="Completed") ) )

Try this

Was this reply helpful? Yes No
Skybluekid 262 on at

Like
a
(0)

Report
Copy link

Link copied!

@BhaskarDhone Thank you it works.

Was this reply helpful? Yes No