Answered

How to get the last part of URL using power automate flow?

(0) Share

Report

Posted on by sls22

Hi,

I created a post looking for suggestions and solutions but it has been marked as spam, and I'm unsure. Can someone please help?

https://powerusers.microsoft.com/t5/Building-Flows/How-to-extract-the-last-part-of-the-site-Url-in-Power-Automate/m-p/1697541#M188194

Appreciate all your time and help. Thank you in advance.

Categories:

Building flows

I have the same question (0)

All responses (4)

Answers (1)

Sort by

tom_riha 10,187 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!
Hello @sls22 ,

the original post was deleted so I don't know if there were any more details, but in general you'd want to split the url by / and take the last part (after the last /)

last(split('urlAddress', '/'))

Was this reply helpful? Yes No
sls22 8 on at

Like (0)

Report
Copy link

Link copied!

Hi @tom_riha ,

Thank you for your response.
My apologies, I didn't know that the post was deleted. Here's my question.

I have a requirement to search for a SharePoint group whose title looks like this - '123456 Section' where '123456' is the site ID and the site URL looks something like this -
https://abc.sharepoint.com/sites/appname/123456.

I need the last part of the above URL i.e. 123456. I tried using
Last(Split("url", "/")).Result but it didn't work.

Also, once I have the ID, I need to concat/append it to 'Section' so that the group title reads '123456 Section' to filter the results from _api/web/sitegroups. . Please let me know how to accomplish this?

Any help is greatly appreciated. Thank you so much in advance.

Was this reply helpful? Yes No
Verified answer

tom_riha 10,187 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!
Hello @sls22 ,

Concat(Last(Split('https://abc.sharepoint.com/sites/appname/123456', '/')), ' Section')

Was this reply helpful? Yes No
sls22 8 on at

Like (1)

Report
Copy link

Link copied!

Hi @tom_riha
Thank you so much for your response. This worked.

Appreciate all your time and help.

Regards
SLS

Was this reply helpful? Yes No