Announcements
I am creating an app using a local SQl server table that contains data from 13 departments. I need to set data level permission for each user. In other words, when accessing the app User A should see only department A data, when User B should see only department B data, etc. Where can I set this kind of data level of permission?
Hi crobledo91,
Please consider to use User function on your side.
More details about User function, please check it at here:https://powerapps.microsoft.com/en-us/tutorials/function-user/
Best regards, Mabel Mao
Hi!
In this post, https://powerusers.microsoft.com/t5/PowerApps-Forum/Is-it-possible-to-switch-the-view-as-InfoPath-in..., I check if a user belongs to a specific security group and take action based on that. Maybe that can be used in your case?
If you cannot or don't want to use that kind of solution, I'd make a table with security settings and then compare that using User().FullName, just as @v-yamao-msft suggests. I would not hard code security settings for each user, that will end up being very high maintenance.
Good luck!
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
Congratulations to our community stars!
Expanding mentorship, skilling, and AI innovation
These are the community rock stars!
Stay up to date on forum activity by subscribing.
11manish 342 Super User 2026 Season 2
M Bilal Khan 283
Mohsin Ali 221
