Forum Discussion
Solved
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...
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.
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.
This is a cool method; I wasn't aware of that hidden list of site collections that you can get to without a premium Power Automate license. I've tested this (including the $top parameter to remove the 100 limit), and it works great - thanks, Ganesh!