How to pull a file name from a hyperlink and store it in a SharePoint list column

(0) Share

Report

Posted on by MN003

441

Hello,

I need assistance with pulling a file name from a hyperlink that leads to a file stored in another library. Is there a simple way to accomplish this? I have a SharePoint list that allows individuals to enter a hyperlink to an existing document stored in another library. I would like to pull the file name of the file by using that hyperlink and store it in another column in my SharePoint list.

I appreciate any guidance on this. Thank you!

Categories:

Building flows

I have the same question (0)

All responses (4)

Answers (0)

Michael E. Gernaey 53,315 Super User 2025 Season 2 on at

Like (0)

Report

@MN003

parsing it isn’t difficult but can I see an example url please

If I have helped you, I would really appreciate if you please Mark my answer as Resolved/Answered, and give it a thumbs up, so it can help others

Cheers

Thank You
Michael Gernaey MCT | MCSE | MCP | Self-Contractor| Ex-Microsoft
https://gernaeysoftware.com
LinkedIn: https://www.linkedin.com/in/michaelgernaey

Was this reply helpful? Yes No
MN003 441 on at

Like (0)

Report

Sure, would the link below work? I grabbed it directly from the 'Copy Link' option for the file stored in the library. I'm hoping that when someone enters this link into the separate list, that somehow I can pull the file name from this url and store it in a separate column in the list. That way I can somehow use Power Automate to find that specific file in the library to update file properties based on information entered in the list.

https://orgname.sharepoint.com/:w:/r/sites/SiteName/LibraryName/Space%20Needle.docx?d=w6e8138f2a2334ed9a2c36ff802426f0f&csf=1&web=1&e=qGH11t

Was this reply helpful? Yes No
Chriddle 8,436 Super User 2025 Season 2 on at

Like (1)

Report
This should cover most of it:

decodeUriComponent( last( split( uriPath('https://orgname.sharepoint.com/:w:/r/sites/SiteName/LibraryName/Space%20Needle.docx?d=w6e8138f2a2334ed9a2c36ff802426f0f&csf=1&web=1&e=qGH11t'), '/' ) ) )

Returns 'Space Needle.docx'

Was this reply helpful? Yes No
MN003 441 on at

Like (0)

Report

And cover most of it did @Chriddle. Thank you!

Would you know how I can use that in a 'Get files' step to locate that specific file in the separate library? I want to be able to write the file name to a specific column within my SharePoint list and at the same time, write the ID for that specific file to another column in that same SharePoint list (which I know how to do).

Was this reply helpful? Yes No