Burgers & Bytes
July 22, 2023

How to get all SharePoint sites of a hub site in Power Automate

Jul 22, 2023  •  1   • 136 
Table of contents

The Challenge

There is a lot of information available on how to retrieve all sites related to a SharePoint hub using Powershell. Another option is to use Microsoft Graph and search for all sites. https://graph.microsoft.com/v1.0/sites?search= *


The challenge was to get all the sites of a hub in Power Automate without using premium actions like the HTTP request. This blog describes how to achieve this!

Needed HTTP requests

Initialized a variable to store the URL of the hubsite. Next step is to get the HubSiteID. You can get the ID using the:


HTTP Request get Hubsite ID

Use Parse JSON and initialize HubsiteID variable

Parse JSON

To get all sites related to the hub, you need to use this call:

_api/v2.1/sites?$filter=sharepointIds/hubSiteId eq '@{variables('HubSiteID')}'

HTTP Request get all Hubsites

So now you are able to iterate through all sites related to a SharePoint Hub Site using Power Automate.

comments powered by Disqus
Empowering productivity - one blog at a time!