Get Members of Nested AD groups in PowerApps

(2) Share

Report

Posted on by New1

Hello-

I have a requirement where I am trying to get all the users from an AD group. I am using the Office365Group Connection as such

ClearCollect( 
    officeAUSers, 
    Office365Groups.ListGroupMembers ("groupID").value );

This provides me with the output, but the output shows other AD groups nested within it as such

AD group : OfficeA-All

and the output is User A, User B, OfficeA-TeamLead, OfficeA- Managers, where OfficeA-TeamLead, OfficeA- Managers, are AD groups by itself nested with OfficeA-All.

How can i get all the users using PowerApps, is it even possible, if not can you please guide me on how I can achieve this ?

Thank you

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (0)

Suggested answer

Nandit 1,568 Moderator on at

Like (1)

Report
Hi New1,

This code will only return what's in the main group - the users and other nested groups. This is a limitation.

As a workaround, you can create separate collections for these groups and then merge them with the main collection.
ClearCollect( officeAUSers, Office365Groups.ListGroupMembers ("groupID").value ); ClearCollect( OfficeA-TeamLead, Office365Groups.ListGroupMembers ("groupID_OfficeA-TeamLead").value ); ClearCollect( OfficeA- Managers, Office365Groups.ListGroupMembers ("groupID_OfficeA- Managers").value ); ClearCollect(AllUsers, officeAUSers, OfficeA-TeamLead, OfficeA- Managers)

Hope this helps.

Kind regards,

Nandit

If this answers your query, please mark this response as the answer.
If its helpful, please leave a like. Thanks!

Was this reply helpful? Yes No
Nandit 1,568 Moderator on at

Like (1)

Report
Hi New1,

Can you also try using the Microsoft Entra ID connector and the following formula:

MicrosoftEntraID.GetGroupMembers(GroupID)

I think this might get you the users from nested groups as well. Let me know how it goes.

Hope it helps.

Kind regards,

Nandit

If this answers your query, please mark this response as the answer.
If its helpful, please leave a like. Thanks!

Was this reply helpful? Yes No