Dynamically get Hub Site ID for the join hubsite connector

[bthomas]

I am creating a flow that creates a project site and then dynamically joins it to a hub site and ideally I want the hubsite ID to be entered in the Flow dynamically. Is there a way to do this either with the standard connectors or Plumsail connectors?

Thanks in advance,

[Expiscornovus]

Hi @bthomas,

Just to double check. What do you mean by dynamically entering the hub site id? 

Do you first want to retrieve a list of existing hub sites and use one of those values in your flow. Or do you mean that the flow requires user input field (where the hub site can be entered) when it is triggered?

For the first scenario you could use one of the methods of the HubSites REST API:

https://docs.microsoft.com/en-us/sharepoint/dev/features/hub-site/hub-site-rest-api

[bthomas]

Hi @Expiscornovus ,

We are using the join hub site connector and need to get the hub site ID dynamically as the hub site being joined can change.

Thanks,

[Expiscornovus]

Hi @bthomas,

Like suggested in my previous reply. You could list the existing hub sites and dynamically pick one of those.

Below is an example of that approach. In that example I am retrieving all the hub sites (via the Send an HTTP request to SharePoint action).

In the Join hub site I am retrieving the ID of the second hub site that is listed in the response of that request via the following expression.

outputs('Send_an_HTTP_request_to_SharePoint')?['body']['d']['results'][1]['ID']

[bthomas]

I implemented this but it gets the first hubsite ID from the output but we will have multiple hubsites so the hubsite we need won't always be the first hubsite in the output

[Expiscornovus]

Hi @bthomas,

I got a question for you 😀. How do you determine which project site needs to be associated with which hub site?

If there is some logic behind that we can probably automate it 😁