How to pull 3,000 rows from an Azure AD Group into a Collection for use in a ComboBox

[Greg27]

I need to pull an Azure AD group of users into my app. The Azure AD group currently has just less that 2,800 users, but could eventually hold 3,000 or more users. I can populate my Combo Box with 999 users, but not sure how to load the Combo Box with 3,000 users. My current statement that I set OnStart of the app is:

ClearCollect(ColAzureStu, Office365Groups.ListGroupMembers("xxxxxxxx-xxxx-xxxx-xxxx-xxxxxxxxxx").value); ClearCollect(ColAzureSta, Office365Groups.ListGroupMembers("xxxxxxxx-xxxx-xxxx-xxxx-xxxxxxxxxx").value)

If collection ColAzureStu has over 2,700 users, how do I get all users into a ComboBox?

[BCLS776 · Accepted solution]

This is a tough one because the connector can bring back at most 2000 records and there is no easy way to apply a filter to that connector. A couple of options I'll suggest:

1. See if you have a combination of two or more groups that, when combined, produce the total list of user accounts. If so, ClearCollect() each one into a separate collection, and afterwards ClearCollect() all the individual collections together. You are not limited to 2000 rows on an internal collection.
2. According to the documentation, the Graph API can keep pulling user records from a group in batches of 100 until it reaches the end. To do that within an app means building a custom connector.

Hope that helps,

Bryan

[Greg27]

@BCLS776 

Does the Azure AD connector only bring back 2,000 records? Are there any connectors that allow for more? It would be shocking if Microsoft limited every connector to only pulling 2,000 records.

[BCLS776]

Yes, from what I understand, 2000 rows is the limit for a connector. As I mentioned earlier, you could use the Graph API to pull in more. Another option the just occurred to me is to use a Power Automate flow to query the connector and build a table or return results to your app. I don't do that often, so may be best to ask that question on the Power Automate side of the community forum. 

Bryan

[Greg27]

I ended up breaking up my AD Security Group so that the largest was just over 1,200 users.

[prangineni]

Hi,

I using an Office365group connector and a collection and loading ComboBox using the collection.

ClearCollect(colADMembers, Office365Groups.ListGroupMembers("xxxxxxxx-xxxx-xxxx-xxxx-xxxxxxxxxx").value)

The AD group I am using has 170 members and ComboBox is only displaying 100 members.

As mentioned in this post, I can't even bring 999 members from ADgroup.

Could you please let me know how to populate 999 or atleast 500 members?

Thank you in advance!

[prangineni]

Found the solution how to populate 999 members in the dropdown.

ClearCollect(colADMembers, Office365Groups.ListGroupMembers("xxxxxxxx-xxxx-xxxx-xxxx-xxxxxxxxxx",{'$top': 999}).value)

[SLokesh314]

Hi, @BCLS776 @Greg27 @prangineni 

How to retrieve more than 999 records from the Azure AD group to power the apps gallery?