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.
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.
- Hi ganeshsanap,
I have already used the sharePoint search , please correct me if this is the way to get using SharePoint search please open the below link
https://stackoverflow.com/questions/76720491/how-to-get-all-the-site-collections-webs-from-tenant-site-collection-in-spfx-web
Please help with your assistance me here or there Muralikrishna1845 If above is not working for you, try using SharePoint Search or Microsoft Graph APIs:
- REST API to get all site collections in SharePoint tenant
- Get all site collections listed in SharePoint Admin center using Rest / Search / Graph API
- What is the REST endpoint URL to get list of site collections?
Please consider giving a Like if my post helped you in any way.
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
- It worked!
Thanks so much for your help!
Jeanne JeanneDarche You can add ?$top=5000 after /items like:
_api/web/lists/getbytitle('DO_NOT_DELETE_SPLIST_TENANTADMIN_AGGREGATED_SITECOLLECTIONS')/items?$top=5000Please consider giving a Like if my post helped you in any way.
