Showing results for 
Search instead for 
Did you mean: 
Advocate II
Advocate II

Filtering a gallery by user


I must filter a gallery by the region of a user (region is equal to brittany etc..).

I have a table like that 


I will import this excel file to my sharepoint tomorrow.


In my gallery i add the column libelle centre de resultat that is my region field in the excel file.


Capture d’écran 2020-10-16 003559.png

My gallery is lard because i have 8 000 entries.



At first, i was thinking to use the filter function but i seems is not delegable 😞


What can i do ? 


Thank you


Super User III
Super User III


The FILTER function can be delegated.  Your issue is due to Excel.  Nothing can be delegated when using Excel as a datasource.  Tomorrow when you import the data to SharePoint FILTER will work.




Link to documentation:


Please click "Accept as Solution" if my post answered your question so that others may find it more quickly. If you found this post helpful consider giving it a "Thumbs Up."



thank you for your answer.


in fact I need your help because I don't know how to build my formula.

I'll give you a little explanation.



I would like the connected user to be able to see only the employees in his region

I would like the connected user to be able to see only the employees in his region Nord pas de calais

So I created a table with users and I created a column corresponding to his region.

In the gallery and the visible property I was thinking about using the function if and filter but I'm lost because I do not know how to go about it.




I think my initial request is not very clear.
so I allow myself to rephrase it.


I would like to filter my gallery according to the region of a user.
For example - user 1 = region "NORD PAS DE CALAIS"

Thus, if user 1 connects, it must see only the records concerning his region


To do this, I added to my SP list (base), a column that I named test (for example).
For all NORD PAS DE CALAIS in the libelle centre de resultat column, I added the user concerned in the test column.


nord pas de calais.pngnord pas de calais2.png


In powerapps, i filter my galley with formula Filter(base;(test.Email=User().Email))


But nothing appears:-(

nord pas de calais3.png

Helpful resources

Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

News & Announcements

Community Blog

Stay up tp date on the latest blogs and activities in the community News & Announcements.


Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Community Highlights

Community Highlights

Check out the Power Platform Community Highlights

Top Solution Authors
Top Kudoed Authors
Users online (8,483)