Forum Discussion
Can i get a list of all site collections in a tenant using power automate?
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.
In SharePoint admin center site, there is one list with name "DO_NOT_DELETE_SPLIST_TENANTADMIN_AGGREGATED_SITECOLLECTIONS" which contains the list of all site collections in tenant.
So, you can call SharePoint REST APIs using "Send an HTTP request to SharePoint" action in Power Automate to fetch the items from above list which will have details about site collections.
Reference: Get All Site Collections Of Office 365 Tenant In MS Flow
Please click Mark as Best Response 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.
