Azure AD Get Group Members

[indhaa]

Hi

I want to get Azure AD group members to a drop down list of power apps. I'm trying to get it from Power automate since I read users will need Azure admin right if I to use the below code on Power apps. I haven't tested it yet with non-admin user

AzureAD.GetGroupMembers("GroupId").value

 If admin right is required. then I need to get it from power automate .

here is what I have done so far but I'm unable to retrieve the final output to Power Apps.

Any idea how to set the condition. I need to send the 'members' as output. Any idea

[Anonymous]

Hi,

Something like this would work if you wanted to go down that route but I would say that the Flow would run under the context of the user that initiates the button in the Power App anyway.

In terms of the schema for the response, you will want to run it once and then take the output of the response and feed in back in as a sample to build out the schema.

[indhaa]

I'm trying to check from PowerApps now. I tried to use Response first but it is Premium. Anyway want to ask if the group need to be set in a particular way. It is not showing any names. Maybe because it is a mail-enabled security group? https://docs.microsoft.com/en-us/azure/active-directory/fundamentals/active-directory-manage-groups

[indhaa]

I'm getting the list now. Seem this option is not the best since I need to give consent for all users, 

Need to think of another way to do this

[indhaa]

Hi

I can get the member using Office365Groups connection. No need to user Azure connection. Just one issue. I want the user to select the user but by default one user is already selected from the drop down list. Is there a way I can set the default one to blank. 

[indhaa]

found the solution now

[GrischkePro]

@indhaa it would be great if you shared your solution. Saying you found one without actually saying what it is, is idiotic... <facepalm>

[indhaa]

It is given in the solution that you need to use Office365Group connection instead of AzureAD. You missed that part.

If you need any more help, LMK

[GunnarAB]

Hi @indhaa , can you describe your solution in more details.

Kind regards,

Gunnar

[indhaa · Accepted solution]

Hi,

Add the data source Office365Groups to your App.

In the item property of the Combo Box add as below. You can Filter it too. I only added the Sort for you

Sort(Office365Groups.ListGroupMembers("Enter the Group ID here").value,displayName)

Inside the inserted comma add the group ID.