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

(0) Share

Report

Posted on by Gprior

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:

General topics

I have the same question (0)

All responses (9)

Answers (1)

Sort by

stampcoin 5,153 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

@Gprior Hi,

I think you try to call the API against the environment.

Was this reply helpful? Yes No
Gprior 188 on at

Like (0)

Report
Copy link

Link copied!

HI @stampcoin!

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

Was this reply helpful? Yes No
stampcoin 5,153 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

@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 .

Was this reply helpful? Yes No
Gprior 188 on at

Like (0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
VictorIvanidze 13,081 on at

Like (0)

Report
Copy link

Link copied!

Try to use a MS GRAPH request: https://learn.microsoft.com/en-us/graph/api/resources/administrativeunit?view=graph-rest-1.0

Was this reply helpful? Yes No
stampcoin 5,153 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!
@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.

Was this reply helpful? Yes No
Gprior 188 on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
Verified answer

Gprior 188 on at

Like (0)

Report
Copy link

Link copied!

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).

Was this reply helpful? Yes No
stampcoin 5,153 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

@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.

Was this reply helpful? Yes No