Skip to main content
Community site session details

Community site session details

Session Id : NeeUXhQZIbuF5uE5jiIgcR
Power Automate - Building Flows
Answered

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

Like (0) ShareShare
ReportReport
Posted on 1 Jun 2024 01:56:58 by 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.

 
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.

 

grantjenkins_0-1717206513378.png

  • ManishSolanki Profile Picture
    15,085 Super User 2025 Season 2 on 01 Jun 2024 at 05:02:29
    Re: How to get the actual URL from a Link (.url) added in a SharePoint Document Library

    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.

     

  • grantjenkins Profile Picture
    11,059 Moderator on 01 Jun 2024 at 04:54:39
    Re: How to get the actual URL from a Link (.url) added in a SharePoint Document Library

    @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.

  • Verified answer
    ManishSolanki Profile Picture
    15,085 Super User 2025 Season 2 on 01 Jun 2024 at 04:35:38
    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:

    ManishSolanki_0-1717216244590.png

     

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

    ManishSolanki_1-1717216288780.png

    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:

    ManishSolanki_2-1717216453746.png

     

     

     

     

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

     

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Announcing our 2025 Season 2 Super Users!

A new season of Super Users has arrived, and we are so grateful forโ€ฆ

Paul Stork โ€“ Community Spotlight

We are honored to recognize Paul Stork as our July 2025 Communityโ€ฆ

Congratulations to the June Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 497 Super User 2025 Season 2

#2
David_MA Profile Picture

David_MA 436 Super User 2025 Season 2

#3
Riyaz_riz11 Profile Picture

Riyaz_riz11 244 Super User 2025 Season 2

Loading complete