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:

Building Power Apps

I have the same question (0)

All responses (9)

Answers (1)

Sort by

Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
indhaa on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
indhaa on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
indhaa on at

Like (0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
indhaa on at

Like (1)

Report
Copy link

Link copied!

found the solution now

Was this reply helpful? Yes No
GrischkePro 287 on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
indhaa on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
GunnarAB 2 on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
Verified answer

indhaa on at

Like (1)

Report
Copy link

Link copied!
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.

Was this reply helpful? Yes No