Forum Discussion

Iron Contributor

Nov 06, 2020

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...

Microsoft Flow

SharePoint

ganeshsanap
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.

JeanneDarche

Copper Contributor

I tried with the SharePoint rest api, but the GET only returns 100 results. I have a few hundreds sites. Does using Microsoft Graph works around this problem?

ganeshsanap

MVP

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.

Sandy Ussia
MVP
Jul 16, 2023
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!
JeanneDarche
Copper Contributor
Jul 17, 2023
ganeshsanap This is the Uri. How do I add &$top=5000 ? Thanks in advance!
- ganeshsanap
  MVP
  Jul 18, 2023
  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
    Copper Contributor
    Jul 18, 2023
    It worked!
    
    Thanks so much for your help!
    
    Jeanne
M365Dev-AN
Copper Contributor
Sep 12, 2024
ganeshsanap would you be able to help in how to get sites more than 5000? We may have more than 20k sites