Power Apps need permission group to populate dropdown menu.

(0) Share

Report

Posted on by Darren11

I have a Power Apps form with a dropdown menu that needs to be populated with members of a permission group. I was able to make some connection to that group, but I am not able to pull all members of that group. By default, I am only getting 100 members. The list has 152 members in it. Here is the line of code I am using.

Items ---SortByColumns(Office365Groups.ListGroupMembers("e45802ae-2df1-4ba1-bff1-f186b8519f63",{'$top':999}).value,"displayName", SortOrder.Ascending)---

The blue text is the Azure group ID number. The bold black text is the attempt to pull all items in the list.
The code shows no errors in Power Apps, but still I don't get the whole list.

I have been working this for a week or so. I am on a tight deadline any help would be greatly appreciated.

Thanks!!

Categories:

Power Apps Pro Dev & ISV

I have the same question (0)

All responses (1)

Answers (0)

v-qiaqi@microsoft.com Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!
Hi @Darren11,

Try to collect users into a collection:

ClearCollect(colUsers,Office365Groups.ListGroupMembers("e45802ae-2df1-4ba1-bff1-f186b8519f63",{'$top':999}).value)

Then sort by displayName.

Was this reply helpful? Yes No