Forum Discussion

Iron Contributor

Nov 06, 2020

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

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

Jul 13, 2023

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.

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
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.
  - Muralikrishna1845
    Copper Contributor
    Jul 28, 2023
    Hi ganeshsanap
    I am also doing the same task here, but i am doing from SPFX webpart
    I can able to get any other lists or site contents , but not the because it through 403 status error
    https://url-admin.sharepoint.com/_api/web/lists/GetByTitle('DO_NOT_DELETE_SPLIST_TENANTADMIN_AGGREGATED_SITECOLLECTIONS')
    
    Note: if I access the above URL in Browser then I can get response and required data.
    Please help me how can i access the Site/Web sites list from tenant.
    Actually I have Tenant admin permission.
    but still it shows 403 error
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!