Answered

Get URL of the Site Collection for the Flow?

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

I am going to have Flows running on many sites and keeping a separate history of all approvals across all the modern sites. The flows will run on typical document libraries doing standard-like approvals. I have it all working, I just need the URL of the site collection. I've tried expressions to split the URL of a file, but struggling with where to stop. I just think Flow has to know where it is.

If I peek code at the trigger, I can see it there under parameters called dataset:

The workflow() expression only dumps info of the environment which doesn't include the site URL. Anyone know how I can reference this information? Just seems like it should be easier than this.

Categories:

Building flows

I have the same question (0)

All responses (8)

Answers (1)

Sort by

Verified answer

v-bacao-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!
Hi @Anonymous ,

The site Url cannot be obtained directly through For a selected file.

Please refer to the method below to get Site Url.

Use Get file properties action to get Link to file, then use Folder Path to split Link to File into "Site url+File Name".

Expression:

first(split(body('Get_file_properties')?['{Link}'],concat('/',body('Get_file_properties')?['{Path}'])))

Image reference:

Flow run history:

Please take a try.

Best Regards,

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

This worked, thanks!

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi,

You can achieve the same result by using some of the properties of the SharePoint item like "Link to Item" and "Full Path".
The formula would be:
substring("Link to Item",0, length("Link to Item")-lenght("Full Path")-1)

Regards,
Kailash

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

@Anonymous i am in need of the site url too and i saw your formula but it isnt working for me. Can you help me fix this?

substring(outputs('Get_file_properties')?['body/{Link}'],0,length(outputs('Get_file_properties')?['body/{Link}']))-length(outputs('Get_file_properties')?['body/{FullPath}'])-1)

It is giving me invalid expression error.

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi @Anonymous ,

My mistake, I was lazy in posting my last reply and you have some bracketing errors in your expression. *hint: Use Notepad++ to write up the expressions*.
You cannot use a minus directly in an expression. You need to use sub instead. Your expression after correction should look like this:
substring(outputs('Get_file_properties')?['body/{Link}'],0,sub(length(outputs('Get_file_properties')?['body/{Link}']),length(outputs('Get_file_properties')?['body/{FullPath}'])))

Regards,
Kailash

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

@Anonymous thank you

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (2)

Report
Copy link

Link copied!

@Anonymous I got this to work on the datset value that you mentioned:

trigger()['inputs']['parameters']['dataset']

Was this reply helpful? Yes No
dropack 9 on at

Like (0)

Report
Copy link

Link copied!

Another way to achieve this solution is to use uri functions to construct the site collection Url. Add the action Compose (Data Operation) to your flow. Then under the Expression tab, add uriScheme (protocol) and uriHost (hostName) inside a concat function.

concat(uriScheme(triggerOutputs()?['body/{Link}']),'://',uriHost(triggerOutputs()?['body/{Link}']),'/')

Was this reply helpful? Yes No