Skip to main content

Notifications

Community site session details

Community site session details

Session Id :
Power Apps - Microsoft Dataverse
Suggested answer

How are Security Roles related to Business Units? (Record ownership across Business Units)

Like (1) ShareShare
ReportReport
Posted on 26 Mar 2025 13:27:39 by 4
When you enable the "Record ownership across Business Units" feature in Power Platform Admin Center, you must assign Security Roles tied with specific Business Units. With this setup, the security role only applies permissions limited to the Business Unit scope. See example below, the Efficiency Manager and AIB Roles are assigned the "Data and AI Solutions" scope:
 
Now my question is: where in the tables is this relation between Security Role and Business Unit saved in Dataverse? If I want to create 20 teams and assign specific Security Role / Business Unit scope to them, how can I automate this process?
Categories:
  • Suggested answer
    BCBuizer Profile Picture
    22,070 Super User 2025 Season 1 on 26 Mar 2025 at 22:01:51
    How are Security Roles related to Business Units? (Record ownership across Business Units)
     
    Creating a Business Unit can be done using Power Automate, for instance:
     
    Of course the Parent Business and Name can be made dynamic.
     
    After the Business Unit is created, automatically a corresponding team is created. In this article you can read how to find the corresponding team and assign security roles in Power Automate: https://powerpro.nl/assign-roles-to-teams-with-power-automate-in-a-business-unit-driven-structure/
  • CU26031315-0 Profile Picture
    4 on 26 Mar 2025 at 17:31:49
    How are Security Roles related to Business Units? (Record ownership across Business Units)
    I don't mean relating Team (Business Unit) x Security role.
     
    What @BCBuizer suggested is an action relating Team x Security role, but this is not what I need.
     
    When you assign security roles to teams/users in the Admin Center, what happens is actually Team x [Security Role x Business Unit]. You can see it in the OP screenshot.
     
    I'm looking for a way to automate this assignment.
  • BCBuizer Profile Picture
    22,070 Super User 2025 Season 1 on 26 Mar 2025 at 15:31:35
    How are Security Roles related to Business Units? (Record ownership across Business Units)
    Hi!
     
    Business Units are saved in the Team table:
     
    As you'll find in the relationships for this table, there is a many-to-may relationship with the Security Role table:
     
    Using the unbound Relate Dataverse action (Microsoft Dataverse - Connectors | Microsoft Learn), you can relate teams (Business Units) with Security Roles.

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.

Helpful resources

Quick Links

Understanding Microsoft Agents - Introductory Session

Confused about how agents work across the Microsoft ecosystem? Register today!

Warren Belz – Community Spotlight

We are honored to recognize Warren Belz as our May 2025 Community…

Congratulations to the April Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard > Power Apps - Microsoft Dataverse

#1
stampcoin Profile Picture

stampcoin 15

#2
ankit_singhal Profile Picture

ankit_singhal 11 Super User 2025 Season 1

#3
mmbr1606 Profile Picture

mmbr1606 9 Super User 2025 Season 1

Overall leaderboard

Featured topics