cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
daroot
Resolver I
Resolver I

Filter Gallery List

Hi All,

 

I tried to created the Filter for the Gallery items. This filter will look the value for Pending, Declined, and Approved.

All this filtering is working except the All button.

 

PApps.pngBut for the All button, the filtering seem not working:

all.png

Here the code I used on the Gallery:

 

Sort(Filter('Approval' ,Status = _requestTypeFilter), Created, Descending)

Any advice how to solve this, when a users tap All button will display the all List inside the Gallery.

 

Thanks,

 

 

 

 

1 ACCEPTED SOLUTION

Accepted Solutions

Hi @dinusc,

Thanks for the reply, but it's not working and got following error

 

err.png

 

The OnSelect:

items.png

 

Maybe something wrong from my side, I used the the poroperty:

 

Items: Table({Filter: "All"}, {Filter: "Pending"}, {Filter: "Approved"}, {Filter: "Declined"})

for the GalleryFilters.

 

Any advice?

 

 

View solution in original post

4 REPLIES 4
dinusc
Microsoft
Microsoft

Hello @daroot,

 

The following should work:

If(IsBlank(_requestTypeFilter), Sort(Created, Descending), Sort(Filter('Approval' ,Status = _requestTypeFilter), Created, Descending))

And then paste the following formula in the "OnSelect" property for the "All" button: 

Set(_requestTypeFilter, "")

Hi @dinusc,

Thanks for the reply, but it's not working and got following error

 

err.png

 

The OnSelect:

items.png

 

Maybe something wrong from my side, I used the the poroperty:

 

Items: Table({Filter: "All"}, {Filter: "Pending"}, {Filter: "Approved"}, {Filter: "Declined"})

for the GalleryFilters.

 

Any advice?

 

 

Finally, I got it working based on @dinusc advice.

 

What I did is, on the Gallery Request:

Items: If(IsBlank(_requestTypeFilter), Sort(Approval, Created, Descending), Sort(Filter('Approval' ,Status = _requestTypeFilter), Created, Descending))

and than on the Gallery Filters:

OnSelect: If(ThisItem.Filter <> _requestTypeFilter, Set(_showDetails, false));
Set(_requestTypeFilter, ThisItem.Filter)

Is the good way to do something like this? But it's worked Smiley Very Happy

This looks correct to me. I'm glad you got it working.

Helpful resources

Announcements
Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

PA Virtual Workshop Carousel 768x460.png

Register for a Free Workshop

This training provides practical hands-on experience in creating Power Apps solutions in a full-day of instructor-led App creation workshop.

PA.JPG

New Release Planning Portal (Preview)

Check out our new release planning portal, an interactive way to plan and prepare for upcoming features in Power Platform.

Top Solution Authors
Top Kudoed Authors
Users online (3,422)