Filter Gallery List

(0) Share

Report

Posted on by daroot

116

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,

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (1)

Sort by

dinusc Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
Verified answer

daroot 116 on at

Like (0)

Report
Copy link

Link copied!
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?

Was this reply helpful? Yes No
daroot 116 on at

Like (0)

Report
Copy link

Link copied!
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

Was this reply helpful? Yes No
dinusc Microsoft Employee on at

Like (1)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No