Answered

Azure AD Get Group Members

(0) Share

Report

Posted on by indhaa

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

Categories:

Connectors

Using Apps Using Formulas

Ge_members.PNG

All responses (9)

Answers (1)

Verified answer

indhaa on at

Like (1)

Report
Re: Azure AD Get Group Members

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.
GunnarAB 2 on at

Like (0)

Report

Re: Azure AD Get Group Members

Hi @indhaa , can you describe your solution in more details.
Kind regards,
Gunnar
indhaa on at

Like (0)

Report

Re: Azure AD Get Group Members

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
GrischkePro 285 on at

Like (0)

Report

Re: Azure AD Get Group Members

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

Like (1)

Report

Re: Azure AD Get Group Members

found the solution now
indhaa on at

Like (0)

Report

Re: Azure AD Get Group Members

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 on at

Like (0)

Report

Re: Azure AD Get Group Members

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 on at

Like (0)

Report

Re: Azure AD Get Group Members

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
Community Power Pla... on at

Like (0)

Report

Re: Azure AD Get Group Members

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.