Get users and security roles for all environment

(2) Share

Report

Posted on by leo85

602

Hi,

as part of our monitoring of the Power Platform and users permissions I'm trying to get a list of users with their associated security roles for all environments that have a Dataverse database.

According to this post, this is not possible, but the post is already quite old, so things might have changed.

In this post they explain that you need to add a "set" suffix to the table relationship name, but for me this does not work (see screenshot). I get an error "table not found".

Using the expand query with the "Users" table also does not work (there is no error, but no data is retrieved about the user roles).

Edit: When I use the current Dataverse connector (instead of the legacy one), it does work, but only for the current environment. This is unfortunately not sufficient, because we have 200+ environments and I can't replicate the flow this many times.

Does anybody know how to get the information without doing it by hand?

Regards

All responses (4)

Answers (0)

Suggested answer

LR-12081549-0 2 on at

Like (0)

Report

Get users and security roles for all environment

Here's what worked for me:

I first followed the guide in this post: Retrieve List of Users and Roles in Environment, and then I applied the solution provided by v-bofeng-msft.

List rows from selected environment:

items('Apply_to_each_-_environment')?['properties/linkedEnvironmentMetadata/instanceUrl']

Apply to each: outputs('List_rows_from_selected_environment')?['body/value']

Apply to each 2: items('Apply_to_each')?['systemuserroles_association']
Rómulo 14 on at

Like (0)

Report

Re: Get users and security roles for all environment

@leo85Hi, did you find the workaround?

Thanks,

RR
leo85 602 on at

Like (0)

Report

Re: Get users and security roles for all environment

Hi @v-bofeng-msft ,

thank you for the reply. Unfortunately, accessing the environment itself is not the problem, but getting the right data from the table. My flow is using the code you supplied.

Regards

Leo
v-bofeng-msft on at

Like (0)

Report
Re: Get users and security roles for all environment

Hi @leo85 ,

Please try:

items('Apply_to_each')?['properties/linkedEnvironmentMetadata/instanceUrl']

Best Regards,

Bof