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

PA User Group

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group

Power Apps Community Call

Monthly Power Apps Community Call

Did you miss the call?? Check out the Power Apps Community Call here!


Experience what’s next for Power Apps

See the latest Power Apps innovations, updates, and demos from the Microsoft Business Applications Launch Event.

Power Platform ISV STudio

Power Platform ISV Studio

ISV Studio is the go-to Power Platform destination for ISV’s to monitor & manage applications post-AppSource publish.

Top Solution Authors
Top Kudoed Authors
Users online (32,579)