cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Greg27
Helper V
Helper V

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

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?

1 ACCEPTED SOLUTION

Accepted Solutions
BCLS776
Super User
Super User

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

_________________________________________________________________________________________
Help the community help more users by choosing to "Accept as Solution" if this post met your needs. If you liked the post and want to show some appreciation, please give it a Thumbs Up.

View solution in original post

4 REPLIES 4
BCLS776
Super User
Super User

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

_________________________________________________________________________________________
Help the community help more users by choosing to "Accept as Solution" if this post met your needs. If you liked the post and want to show some appreciation, please give it a Thumbs Up.

View solution in original post

@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
Super User
Super User

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

_________________________________________________________________________________________
Help the community help more users by choosing to "Accept as Solution" if this post met your needs. If you liked the post and want to show some appreciation, please give it a Thumbs Up.
Greg27
Helper V
Helper V

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

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

M365 768x460.jpg

Microsoft 365 Collaboration Conference | December 7–9, 2021

Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.

Top Solution Authors
Top Kudoed Authors
Users online (1,303)