Get next 1000 AD users in PowerApps

(0) Share

Report

Posted on by DBTS7

Hi,

I want to get 5000 AD users in PowerApps and by writing below code, we're getting 999 AD users:

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

Can i get next 1000 AD users (then next 1000 and so on...) in PowerApps? So that I'll make collections of those and put all of then in 1 collection.

and I don't want to user power Automate as it is taking around 1 min. to call 5000 AD users.

is this possible to implement?

Thanks

Categories:

Building Power Apps

All responses (3)

Answers (1)

Sort by

MVP-Phipps 3,521 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

I believe you can only achieve this via Power Automate because you need to turn on pagination:
"Get the users who are members of a group. 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."

Please Accept as Solution if it solves your question. Or just give it a Thumbs Up if it is helpful because this can help others.

If I have helped, feel free to donate the Power Platform Duo coffee money: https://www.buymeacoffee.com/thePPDuo

Otherwise follow me on:
LinkedIn: https://www.linkedin.com/in/charlie-phipps-%F0%9F%91%A8%E2%80%8D%F0%9F%92%BB-91338715b/
YouTube: https://www.youtube.com/channel/UChmFBGU1YKIU91sNMQ7buGg
Twitter: https://twitter.com/phipps0218
DBTS7 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @phipps0218 ,
Thanks for your reply I want to ask one last question, like we are getting the top 999 AD members by using this code AzureAD.GetGroupMembers("",{'$top':999}).value
can't we get next 1000 AD users? I tried with LastN function, but it didn't work.

Thanks
Verified answer

MVP-Phipps 3,521 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

No, I don't think it is achievable without Power Automating passing these users to the app.

Please Accept as Solution if it solves your question. Or just give it a Thumbs Up if it is helpful because this can help others.

If I have helped, feel free to donate the Power Platform Duo coffee money: https://www.buymeacoffee.com/thePPDuo

Otherwise follow me on:
LinkedIn: https://www.linkedin.com/in/charlie-phipps-%F0%9F%91%A8%E2%80%8D%F0%9F%92%BB-91338715b/
YouTube: https://www.youtube.com/channel/UChmFBGU1YKIU91sNMQ7buGg
Twitter: https://twitter.com/phipps0218