Unanswered

Gallery filtered by Users

(0) Share

Report

Posted on by PMCVieira

Dear community,

I couldn't find a solution after hours of failed tentatives and investigation.

I have an app where the user can submit a form creating an item on sharepoint list ('Requests') and a workflow is generated collecting the respective Approvers from another sharepoint list ('Approvers') according to the Country and Category chosen in the form _ flow working properly.

In the app I have a list (gallery) with all requests (sharepoint list) and many dynamic filters can be chosen by the user.

But one of the filters is fixed and applied to the gallery:

- the user() only can see the request if the user() is one of the intervenients of the process, either as creator or as approver.

Approvers list (Approver 1 and 2 are person columns with multiple values allowed).

Country	Category	Approver 1	Approver 2
A	1	Paul	Matt
		Andrew	Thomas
		John

Should I change this 'Approvers' list in order to simplify it?

How can I achieve this filter in my gallery?

Thank you!

Categories:

Building Power Apps

I have the same question (0)

All responses (5)

Answers (0)

Sort by

Fredrik_A 3,644 Super User 2026 Season 2 on at

Like
a
(0)

Report
Copy link

Link copied!

Are there multiple approver columns because the approval goes first to the approver 1 people and then the approver 2 people? Or what's the reason you have it split into multiple columns? 🙂

What exactly is the filter you want? A filter that shows the items the logged in user is in as either approver 1 or approver 2?

Was this reply helpful? Yes No
PMCVieira on at

Like
a
(0)

Report
Copy link

Link copied!

Was this reply helpful? Yes No
PMCVieira on at

Like
a
(0)

Report
Copy link

Link copied!

Exactly, it goes first to the approver 1 and then to the approver 2.
I am building an aproval process not using power automate flow, but through the visibility of buttons and editability of forms.
And like this 'Requests List' screen I will have the Dashboard screen.
For both screen I need the gallery filtering only the Requests where these intervenients are assigned to, they cannot see other requests in the gallery.

Was this reply helpful? Yes No
Fredrik_A 3,644 Super User 2026 Season 2 on at

Like
a
(0)

Report
Copy link

Link copied!
Currently don't have a posibility to test this but something like this should be doable, it will not work on very large datasets though:

Filter(datasource_name, approver1 = User().email || Approver2 = User().Email);

Was this reply helpful? Yes No
PMCVieira on at

Like
a
(0)

Report
Copy link

Link copied!

@StretchFredrik it is not enough.
I have to take into consideration the Country and Category, but the main problem is that the columns Approvers 1 & 2 are multiple person.

Was this reply helpful? Yes No