Answered

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

(0) Share

Report

Posted on by grantjenkins

11,063 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.

Categories:

Building flows

I have the same question (0)

All responses (3)

Answers (1)

Sort by

Verified answer

Manish Solanki 15,169 Moderator on at

Like (1)

Report
Copy link

Link copied!
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.

Was this reply helpful? Yes No
grantjenkins 11,063 Moderator on at

Like (1)

Report
Copy link

Link copied!

@ManishSolanki Thanks, this works perfectly - very much appreciated.

This was a critical step needed so I can get the content of the actual file and run AI builder over it to extract out some keywords 🙂

It's great you (and everyone else) is still super active in this community. Unfortunately, I've been consumed by work stuff and haven't had much time to contribute - but hopefully get some more time over the next few months.

Was this reply helpful? Yes No
Manish Solanki 15,169 Moderator on at

Like (0)

Report
Copy link

Link copied!

Hi @grantjenkins

I am glad it solves your issue. Yes, I was following your solution when you were active and learnt lot of tricks to solve the problems. Learnt one more trick from this post using shortcut link for keywords extraction in AI builder, awesome! See why I am your big fan 😀

Happy to see you back! I am sure you will beat me in the leaderboard 😀🙌

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

Was this reply helpful? Yes No