AzureAD 999 record Limit

[brianmaric1]

Hi I need to grab a list of more than 1000 users from AzureAD.GetGroupMembers().  Below is the best that I can do.

Can anyone find a way grabbing more than 1000?

Thanks 

ClearCollect(_colUsers,AzureAD.GetGroupMembers("XXXXXXX", {'$top':999}).value)

Also, I tried increasing the limit to 2000, but it still doesn't give 2000.

[v-jefferni]

Hi @brianmaric1 ,

Please refer to the 5th reply of below discussion:

https://www.powerappsug.com/communities/community-home/digestviewer/viewthread?GroupId=2243&MessageK...

In which says:

If you have more than 999 users then the method is a bit different, you have to set up an App Registration for the Graph API in Azure AD then use a Flow or Logic app to hit the Graph using HTTP:

Hit the 3 dots and go Settings and set the pagination. You can get up 100000 pages of results. By default this means you can have up to 10 million results, but if you're within a million miles of that then this probably isn't the solution for your problem!

Lastly, parse the JSON that comes back and save the results into a delegable data source such as SP online or SQL.

Best regards,

Community Support Team _ Jeffer Ni
If this post helps, then please consider Accept it as the solution to help the other members find it.

[brianmaric1]

Let me make sure I understand.   Setting up an App Registration for the Graph API in Azure AD is (in effect) a query.  And, once this is set up, you can run a flow that clears and re-populates a table in power apps?

[brianmaric1]

Also, it seems that adding by parts of 500 could work - grabbing chunks of 500 at at time.