Get users and security roles for all environment

(2) Share

Report

Posted on by leo85

617

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

Categories:

Building flows

I have the same question (0)

All responses (4)

Answers (0)

Sort by

v-bofeng-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!
Hi @leo85 ,

Please try:

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

Best Regards,

Bof

Was this reply helpful? Yes No
leo85 617 on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
Rómulo 14 on at

Like (0)

Report
Copy link

Link copied!

@leo85Hi, did you find the workaround?

Thanks,

RR

Was this reply helpful? Yes No
Suggested answer

LR-12081549-0 2 on at

Like (0)

Report
Copy link

Link copied!

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']

Was this reply helpful? Yes No