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

[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-P...

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

[tom_riha]

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', '/'))

[sls22]

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. 

[tom_riha · Accepted solution]

Hello @sls22 ,

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

[sls22]

Hi @tom_riha 

Thank you so much for your response. This worked.

Appreciate all your time and help.

Regards

SLS