Filter Gallery List

[daroot]

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.

But for the All button, the filtering seem not working:

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,

[dinusc]

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, "")

[daroot · Accepted solution]

Hi @dinusc,

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

The OnSelect:

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?

[daroot]

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 

[dinusc]

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