Answered

Gallery Filter

(0) Share

Report

Posted on by mao247

Hi All,

I am new to power apps and I am currently building a leave request app for use by our team. With the help of searching and youtube I can say I made a lot of progress. Now I am stuck with creating a filter for the Leave Summary page. I can seem to connect the buttons to the gallery itself. I have tried many suggestions but none seem to work or I dont know how to tweak the formulas suggested to work with my data.

So currently I have this page:

The gallery items is currently set for the user to view their own entries only and this is the current item formula:
Sort(Filter('Leave requests', 'SME Email' = User().Email), 'Leave Date',SortOrder.Descending)

As you can see, I want to use the buttons to filter based on Approval Status (Item name: Approval).

Need help on how I can have a functioning Filter.

Thanks in advance and I truly appreciate any help.

Categories:

Building Power Apps

I have the same question (0)

All responses (5)

Answers (2)

Sort by

Verified answer

v-bofeng-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @mao247 ,

You could set the "Pending" button's OnSelect property to:

Set(FilterStatus,"Pending")

And then filter the table by this formula:

Sort(Filter('Leave requests', 'SME Email' = User().Email && Status=FilterStatus), 'Leave Date',SortOrder.Descending)

Best Regards,

Bof

Was this reply helpful? Yes No
mao247 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi Bof.,

Thanks for your response. I have tried it but unfortunately got this error

it says incompatible types for comparison

Was this reply helpful? Yes No
mao247 on at

Like
a
(0)

Report
Copy link

Link copied!

Thanks @v-bofeng-msft ,

I figured it out after some tweaking except for the "All" Button. Since I have no approval status option as "ALL", how can I set it so that it either clears the filter or selects all approval statuses?

Was this reply helpful? Yes No
Verified answer

v-bofeng-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @mao247 ,

You could set the FilterStatus's value to all by the reset button

Set(FilterStatus,"All")

and then use this formula to do the filter

Sort(Filter('Leave requests', 'SME Email' = User().Email && (FilterStatus="All" || Status=FilterStatus)), 'Leave Date',SortOrder.Descending)

Best Regards,

Bof

Was this reply helpful? Yes No
mao247 on at

Like
a
(0)

Report
Copy link

Link copied!

Got it all sorted now @v-bofeng-msft Thank you so much!

Was this reply helpful? Yes No