Buttons to filter a gallery

(0) Share

Report

Posted on by atray13

147

Hi,

I have a gallery that i am filtering by using buttons placed above it.

The gallery contains a long list of staff, and the buttons are "Ward 1", "Ward 2", "Ward 3" and "All", which when pressed, update the gallery with a variable filter set to update to whichever button has been pressed

So on select of the ward 1 button is: Set(AllStaffGalleryFilter, "Ward 1"), and then in my gallery i have the items as: Filter(Shifts, 'Ward' = AllStaffGalleryFilter)

The ward 1/2/3 buttons work fine, but i can't figure what i need as the onselect formula for the "all" button, which i want to effectively clear the filter, and show every record regardless of that staff's ward.

Any ideas for how to make the 'all' button work?

Thanks

Categories:

Building Power Apps

All responses (4)

Answers (2)

Sort by

Verified answer

Community Power Pla... Microsoft Employee on at

Like
a
(1)

Report
Copy link

Link copied!

If(AllStaffGalleryFilter="All"
,Shifts
,Filter(Shifts, 'Ward' = AllStaffGalleryFilter)
)
Verified answer

eka24 20,925 on at

Like
a
(1)

Report
Copy link

Link copied!

Try:
If(AllStaffGalleryFilter="All", Shifts,
Filter(Shifts, 'Ward' = AllStaffGalleryFilter))

That is if the variable AllStaffGalleryFilter is "All" then dont filter the Table Shifts
------------

If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.
mdevaney 29,993 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

@Anonymous

Put this code in the OnSelect Property of the All button

Set(AllStaffGalleryFilter, "Ward 1")

The use this code in the Items property of the gallery

Filter(Shifts, ‘Ward’ = “All” Or 'Ward' = AllStaffGalleryFilter)

---
Please click "Accept as Solution" if my post answered your question so that others may find it more quickly. If you found this post helpful consider giving it a "Thumbs Up."
atray13 147 on at

Like
a
(0)

Report
Copy link

Link copied!

Great that has worked thank you