web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / How to retrieve the ne...
Power Automate
Answered

How to retrieve the new Modernized Business Units linked with a user

(0) ShareShare
ReportReport
Posted on by 188
Hello everyone,
is there a way to retrive the list of BUs linked to a specific user in an environment where there's the new modernized business units managament?
I can easily retrive the main BU but i'm really struggling finding the other BUs.
I've also tried to use table systemuserbusinessunitentitymap but it looks like it's a legacy data and does not reflect the current active BU associations.
 
Is there a way to retrieve this list?
Thank you for any support!
 
Giovanni
Categories:
I have the same question (0)
  • stampcoin Profile Picture
    5,153 Super User 2026 Season 1 on at
    @Gprior Hi,
    I think you try to call the API against the environment.
     
  • Gprior Profile Picture
    188 on at
    Thank you for your reply!
     
    That was a good suggestion, I tried to check the /api/data/v9.2/ list but i can find even less possible solutions than checking one by one the tables available in default solution of my envinronment in make portal.
    Maybe is there a more useful API that is not showed there? 
     
    Thank you for any further information!
    Giovanni
  • stampcoin Profile Picture
    5,153 Super User 2026 Season 1 on at
    @Gprior Hi,
    it should be  there( I didn't query it...).
    1. once you define the BU, it will be listed in BU table  in dataverse.
    2. and the user table in dataverse will be reflected as well, you will find users belonging against BU.
     
    you can check the shortcut from each table. see blow .
     
     
  • Gprior Profile Picture
    188 on at
    Thank you for your quick reply!
    You have found the main issue. I'm not talking about the main BU of the user which is stored inside systemuser table which is pretty straight forward. I need to retrieve via power automate the other business units of the user that you can set in admin power platform using the modernized business units:
     
     
    In the picture above you can see that i have a main BU (using the teams which is 1:1 to BU) but i can also assign as many other BUs as i want using the "direct assigned roles". From there i select the other BU and then set the additional security roles to the specific user.
    I'm not able to find where these other connections are stored.
  • VictorIvanidze Profile Picture
    13,081 on at
  • stampcoin Profile Picture
    5,153 Super User 2026 Season 1 on at
    @Gprior Hi,
    consider using api/data/v9.2/systemuserrolescollection?$top=10, for example, start from there
    • systemuserroleid
    • roleid
    • systemuserid
    if that works for you, then you can build other details in the flow.
  • Gprior Profile Picture
    188 on at
    thank you @stampcoin for your suggestion
    can you help me on building the request on power automate?
    As I fear that i'll need a pre-authorization to call it using Azure
     
    @VictorIvanidze As far as i know, Dataverse-specific entities like Business Units (businessunit), Security Roles, and custom tables are not available via Microsoft Graph API
     
     
  • Verified answer
    Gprior Profile Picture
    188 on at
    Hi all,
    first of all thank you @stampcoin and @VictorIvanidze for your suggestions.
    I made it using a list rows action directly into power automate expanding the query to another table: I supposed that Security roles table was a master data of the list of possible Security roles, instead i found it's a real time picture of all the security roles assigned to user.
    I used 
     
     
    and it provides the roleid of the record in the security roles table. Then for each ids i extracted the IDs of the BU linked to those roleids:
     
    Now i have a complete list of IDs of the secondary modernized BUs linked to the user (the main one is set in the main user table).
     
  • stampcoin Profile Picture
    5,153 Super User 2026 Season 1 on at
    @Gprior Hi,
    This is one way how to use it,  it might not be enough when you have more products in the environment or multiple environments,
    but for daily task it could be enough.
     

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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Users!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Congratulations to the March Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Automate

#1
Haque Profile Picture

Haque 573

#2
Valantis Profile Picture

Valantis 407

#3
11manish Profile Picture

11manish 387

Last 30 days Overall leaderboard