I want to load all Office365Users (more than 3000 Users) into a collection. The Problem is that the searchUser-function only returns the first 999 users. I had an idea to use the searchUser-function several times to load the first 999 users into the collection and then loading the next 999 users, skipping the first 999 users and so on. But I haven't figured out how to skip users? And if that isn't possible do you have an idea how to load all users into a collection?
Hi @julia321
If you do this via the graph api using the Office365 groups connector, it gives you a skip token called @odata.NextLink.
You can use a Do Until and get 999 users at a time until @odata.NextLink is empty.
You can experiment first by:
- Signing in to Graph Explorer
- Executing the following endpoint/query
Share
Report
All responses (
Answers (
2,837
https://graph.microsoft.com/v1.0/users?$top=999In the results you will see the skip endpoint and it will look something like this:
If you copy that and paste it back into the query box and run it - you will get the next 999 users
You can do all of this automatically in a flow
