Answered

PowerAutomate Loop through an AAD Security Group to find all Users

(0) Share

Report

Posted on by IDonknowwhay

Is there a way in Power Automate / Power Flow where I can get all the users which belongs to a AAD security group (All_of_IT) and nested groups within the group?

e.g.

All_of_IT

User_1
User_2
User_3
IT_Operations

User_3
IT_Developers

User_2
User_7
User_8

IT_Engineers

User_5
User_6

IT_Team_Leads

User_1
User_3
User_6

The Flow will receive the Object_Id from a PowerApp App to identify "All_of_ IT" or any other Security Group

The result set should be:

User_1
User_2
User_3
User_5
User_6
User_7
User_8

(There is a commandlet in PowerShell called Get-ADGroupMember which will do what I need, but my objective is to find a solution that is a 100% cloud-based.)

You help will be much appreciated.

Categories:

Using flows

I have the same question (0)

All responses (3)

Answers (1)

Verified answer

Expiscornovus 33,507 Most Valuable Professional on at

Like (2)

Report
Copy link

Link copied!

Hi @IDonknowwhay,

You could use the List group transitive members method of the Graph API in a Send an HTTP request action of the Groups connector. That method should also list all the members of the nested objects.

With a filter array you can make sure it only outputs users.

Below is an example of that approach.

Was this reply helpful? Yes No
IDonknowwhay 27 on at

Like (1)

Report
Copy link

Link copied!

Hi @Expiscornovus

Thank you for the detailed solution 😁

Was this reply helpful? Yes No
Expiscornovus 33,507 Most Valuable Professional on at

Like (1)

Report
Copy link

Link copied!
Hi @IDonknowwhay,

I had another look, that Filter Array is not even needed. You can even get the users with the setup below.

https://graph.microsoft.com/v1.0/groups/@{variables('Object_Id')}/transitiveMembers/microsoft.graph.user?$count=true

Was this reply helpful? Yes No