Forum Discussion
Patrick Rote
Nov 06, 2020Iron Contributor
Can i get a list of all site collections in a tenant using power automate?
Hi All, Will it be possible to get a list of all site collections in a tenant using power automate? Currently I'm using powershell and have to query the sharepoint admin site. But i'm thinking po...
- Jul 14, 2023
JeanneDarche Are you using Send HTTP Request to SharePoint action? what is the the Uri/endpoint you are using?
Usually, you can add &$top=5000 at the end of REST API endpoint to get more than 100 items.
Please click Mark as Best Response & Like if my post helped you to solve your issue. This will help others to find the correct solution easily. It also closes the item. If the post was useful in other ways, please consider giving it Like.
ganeshsanap
MVP
JeanneDarche You can add ?$top=5000 after /items like:
_api/web/lists/getbytitle('DO_NOT_DELETE_SPLIST_TENANTADMIN_AGGREGATED_SITECOLLECTIONS')/items?$top=5000
Please consider giving a Like if my post helped you in any way.
JeanneDarche
Jul 18, 2023Copper Contributor
It worked!
Thanks so much for your help!
Jeanne
Thanks so much for your help!
Jeanne