You’re offline. This is a read only version of the page.
315
I have a Power App for inventory in my company. The app is created for several different locations in the company.
This is separated in the Dataverse table by the column "Location".
Is there any way to create dynamic row level security for this?
Example: I create two security roles: "Location 1" and "Location 2".
In the Datverse table I only want those who have the security role "Location 1" to be able to add/edit data for rows containing "Location 1" in the location column. The same goes for the other security roles. I only want them to be able to add items, loan items and edit items at their own location.
Hi @mrstian89 ,
As @Mira_Ghaly mentioned. the Locations you mentioned would be setup as Business Units in the system. You can then assign users to the specific business units. When records are created in the business unit they are "in effect" tied to that location. You would not have a location column on your records but the "Owner" of the record would be assigned to the business unit... Business Units can Security Roles can work together so you can have some users see across all business units (create, read, update, delete) while other users can be setup (restricted) to a single business unit. A lot of options exist here...
https://docs.microsoft.com/en-us/power-platform/admin/security-roles-privileges
Hope this helps. Please accept if answers your question or Like if helps in any way.
Thanks,
Drew
The only way to achieve this without code is to implement your locations as Business Units and hence then your security role to be configured per business unit.
#1
stampcoin
17
#2
mmbr1606
15
Super User 2025 Season 1
#3
ankit_singhal
11
Super User 2025 Season 1
Share
Report
All responses (
Answers (
