Skip to main content

Notifications

Community site session details

Community site session details

Session Id :
Power Automate - Building Flows
Answered

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

(0) ShareShare
ReportReport
Posted on by 11,059 Super User 2025 Season 1

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 1 on at
    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 Super User 2025 Season 1 on at
    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 1 on at
    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

Michael Gernaey – Community Spotlight

We are honored to recognize Michael Gernaey as our June 2025 Community…

Congratulations to the May Top 10 Community Leaders!

These are the community rock stars!

Announcing the Engage with the Community forum!

This forum is your space to connect, share, and grow!

Leaderboard >