cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
pvanolinda
Level: Powered On

Gallery Filter Question

I have an app that displays a list of requests staff send to our HR dept for things like dismissals, new hires, and one-time payments. The data source is a SharePoint list. One-time payments have to be approved by a manager, so I setup a Flow that handles this and writes either 'approved' or 'denied' to a column (called 'Manager_Approval') when the manager completes the approval email. I setup a Gallery to display the requests to the HR team and created a dropdown that allows them to filter based on the different request types. This works great, however, they don't want to see any entries that are marked as a 'One-time Payment' and don't have either 'approved' or 'denied' written to the 'Manager_Approval' column, as that means the manager hasn't dealt with the approval email yet. I can't figure out how to write the Filter code to show all requests, excluding those marked as 'One-time Payment' that have a blank 'Manager_Approval' field, and allow for the dropdown filtering. Is this even possible?

1 ACCEPTED SOLUTION

Accepted Solutions
Community Support Team
Community Support Team

Re: Gallery Filter Question

Hi @pvanolinda ,

Do you want to filter gallery based on three requirments?

Try this formula:  (set the gallery's Items)

Filter(tablename, Not(markfield="One-time Payment"),!IsBlank(Manager_Approval),request types=drop down1.Selected.Value)

Just using "," can represent multiple conditions in filter function.

Here's a doc about this function for your reference:

https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/functions/function-filter-lookup

 

 

Best regards,

Community Support Team _ Phoebe Liu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

3 REPLIES 3
Super User
Super User

Re: Gallery Filter Question

How many different requests types are being used?



--------------------------------------------------------------------------------
If this post helps answer your question, please click on “Accept as Solution” to help other members find it more quickly. If you thought this post was helpful, please give it a Thumbs Up.
pvanolinda
Level: Powered On

Re: Gallery Filter Question

Approximately 10.

Community Support Team
Community Support Team

Re: Gallery Filter Question

Hi @pvanolinda ,

Do you want to filter gallery based on three requirments?

Try this formula:  (set the gallery's Items)

Filter(tablename, Not(markfield="One-time Payment"),!IsBlank(Manager_Approval),request types=drop down1.Selected.Value)

Just using "," can represent multiple conditions in filter function.

Here's a doc about this function for your reference:

https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/functions/function-filter-lookup

 

 

Best regards,

Community Support Team _ Phoebe Liu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

Helpful resources

Announcements
thirdimage

Power Automate Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

sixthImage

Power Platform World Tour

Find out where you can attend!

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

fifthimage

Microsoft Learn

Learn how to build the business apps that you need.

Top Kudoed Authors (Last 30 Days)
Users online (4,735)