Showing results for 
Search instead for 
Did you mean: 
Post Prodigy
Post Prodigy

Permission - filter gallery on columns in other datasource and set individual filters to each user.

I am trying to setup a permission system.


I have one main gallery that i want to filter based on if the user exist in a datasource and have a value set to YES or No in several columns.


If user exist in datasource1 and if user have yes in column A or column B or column C or column D and so on...



Set filter to filter based on yes/no in column a,b,c,d....


Idea is that i want to control what a user see in a gallery based on if have give the user permission to see a specific thing in the gallery (filter).


So if user have an YES in column B. Then the user should be allowed to see some values in the gallery

If user have YES in column a, b and c... then user should be able to see all 3 things those columns represents.

If user have only NOs, then user should not see anything.


How can i setup this permission control?

Super User III
Super User III


I believe what you are looking for is called "Role-Based Access Control".  Here's an example of how a gallery changes based on who is logged into the app and their role.


Link to article:





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."

Helpful resources

News & Announcements

Community Blog

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

Power Apps Community Call

Power Apps Community Call- January

Check out the Power Apps Community Call for January 2021

PP Bootcamp Carousel

Global Power Platform Bootcamp

Dive into the Power Platform stack with hands-on sessions and labs, virtually delivered to you by experts and community leaders.


Power Platform Community Conference On Demand

Watch Nick Doelman's session from the 2020 Power Platform Community Conference on demand!

Top Solution Authors
Top Kudoed Authors
Users online (11,671)