How to get the actual URL from a Link (.url) added in a SharePoint Document Library

Like (0) Share

Report

Posted on 1 Jun 2024 01:56:58 by grantjenkins

11,059 Moderator

In SharePoint you can add a Link to a Document Library. We have setup a When a file is created (properties only) trigger in order to get the URL of the Link when it's added to the library.

However, in Power Automate the actual URL doesn't come through. All we see is the following URL structure. This is not the actual URL of the file which we need.

{Link}": "https://DOMAIN.sharepoint.com/sites/THE_SITE/THE_LIBRARY/FOLDER/NAME_OF_FILE.url"

Any help on this would be great. Really hoping there is a way to do this, otherwise we will need to readdress our overall solution.

All responses (3)

Answers (1)

Verified answer

ManishSolanki 15,085 Super User 2025 Season 2 on 01 Jun 2024 at 04:35:38

Like (1)

Report
Re: How to get the actual URL from a Link (.url) added in a SharePoint Document Library

Hi @grantjenkins

First of all, I would like to say thank you 🙏 for learning from your solution especially complex expression, transformation data etc.

Here is the solution to find actual link from "Link" created in doc library:

Use "Get file" content to get content of link:

Next, add compose action and use expression to decode the base64 value from the content:

decodeBase64(body('Get_file_content')?['$content'])

You will get the actual link in the output of compose action. You need to parse the text to get the link, which I know you are expert in 😀

Output:

If this helps & solves your problem, please remember to give a 👍 and accept my solution as it will help others in the future.