I have not tested it but the Microsoft documentation says that it is possible to retrieve more than 1000 users: "You can query up to 1000 items using the Top parameter. If you need to retrieve more than 1000 values, please turn on the Settings->Pagination feature and provide a Threshold limit."
Yes, that connector and several other methods really don't scale to get all the members or al the fields. The Department filed appears to be missing from a lot of them even though the users connector brings back that field. Only way I was able to manage this scenario in an ap I recently worked on with around 1400 accounts was to export all the accounts and put them in a table in this case a databerse for Teams, but could have been an SP list or other datasource. Then use the list as a lookup in the app to match the user email address. There is a new virtual table in Dataverse for all AAD users, but it wasn't much use in my case. Then ran a few flows. 1. To add new members to the table when someone is added. In this case it was an MSTeam so that was easy. 2. One to lookup each person whose account hasn't been modified once a week to check to see if accounts are disabled / still in the directory and delete them out or update them in the table. of the table (Thats an expensive flow long running flow and not ideal) 3. A nightly job to check fr people using the system in another table and update their records so current users remain updated. I do hope Microsoft make this easier in future. Always one of those things to look out for is API limits. Just because something works doesn't mean to say it will in real life production. Anyway, thanks for all your great videos and courses I really enjoy them. Have a great break over the holiday season. See you in 2023.
Danke. Und ein gutes neues Jahr
Nice video 👍👍. See you next year
I have not tested it but the Microsoft documentation says that it is possible to retrieve more than 1000 users:
"You can query up to 1000 items using the Top parameter. If you need to retrieve more than 1000 values, please turn on the Settings->Pagination feature and provide a Threshold limit."
I have done that using Flow but I didn't know I can pass that 1000 item limit directly from PowerApps. I will defenitly test it.
Yes, that connector and several other methods really don't scale to get all the members or al the fields. The Department filed appears to be missing from a lot of them even though the users connector brings back that field.
Only way I was able to manage this scenario in an ap I recently worked on with around 1400 accounts was to export all the accounts and put them in a table in this case a databerse for Teams, but could have been an SP list or other datasource. Then use the list as a lookup in the app to match the user email address.
There is a new virtual table in Dataverse for all AAD users, but it wasn't much use in my case.
Then ran a few flows.
1. To add new members to the table when someone is added. In this case it was an MSTeam so that was easy.
2. One to lookup each person whose account hasn't been modified once a week to check to see if accounts are disabled / still in the directory and delete them out or update them in the table. of the table (Thats an expensive flow long running flow and not ideal)
3. A nightly job to check fr people using the system in another table and update their records so current users remain updated.
I do hope Microsoft make this easier in future. Always one of those things to look out for is API limits. Just because something works doesn't mean to say it will in real life production.
Anyway, thanks for all your great videos and courses I really enjoy them. Have a great break over the holiday season. See you in 2023.
Thank you, Alireza. Happy holiday.
Hi, what if I want 5000 Azure ad group members? Can you please also make a video on this if possible?
Thanks
I am new to Power apps and I want to retrieve all group members which is more than 5000. Any assistance would be greatly appreciated
@@arpitbhatia3221 you can do this with the help of automate flow. Set the azure ad group trigger to greater then 5000