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.
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.
@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.
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.
Michael E. Gernaey
497
Super User 2025 Season 2
David_MA
436
Super User 2025 Season 2
Riyaz_riz11
244
Super User 2025 Season 2