Notifications
Announcements
Hi all,
I'm building a flow where after an excel file on SharePoint is modified send to specific channel a message with the URL of file,
unfortunately this link doesn't work
someone could help me?
thanks in advance
@Alice_italy
You can use the SEND HTTP REQUEST TO SHARE POINT to retrieve the linking Url of the file.
_api/web/GetFolderByServerRelativeUrl('Name of share point document library')/Files('File Name')?$select=LinkingUrl
Pass the above URI request in the SEND HTTP REQUEST TO SHARE POINT action and you will be able to get the file url.
If this information helps you with resolution, please consider giving a thumbs up and mark the solution as resolved.
hi @Alice_italy you can try this options.
[Bing](https://bing.com)
<a href="www.google.com">GOOGLE</a>
Hi @Alice_italy ,
Please try the following configuration:
Click the icon to edit the message body in code view and insert a hyperlink.
Best Regards,
I have no idea, I still have no luck to get the link in MS TEAMS. Here is my code view:
<p><span style="font-family: tahoma">Hello All,<br><br>New file added - </span><span style="font-family: tahoma">@{triggerBody()?['{FilenameWithExtension}']}</span><span style="font-family: tahoma"> by </span><span style="font-family: tahoma">@{triggerBody()?['Author']?['DisplayName']}</span><span style="font-family: tahoma"><br><br></span><span style="font-family: tahoma">@{triggerBody()?['{Path}']}</span><span style="font-family: tahoma"></span><span style="font-family: tahoma">@{triggerBody()?['{FilenameWithExtension}']}</span><span style="font-family: tahoma"><br><br>Click </span><a href=""><span style="font-family: tahoma">Here</span></a><span style="font-family: tahoma"> for Link to file :<br><br></span><span style="font-family: tahoma">@{triggerBody()?['{Link}']}</span><span style="font-family: tahoma"><br><br><br>Thanks!</span></p>
This works well when you test it manually after creating it. But once you save and exit out of the flow for it to run automatically it will break the hyperlink code and change it (see picture). It will still have the hyperlink format but is unclickable and keeps the raw url instead of changing it to the name given.
This worked PERFECTLY! Thanks so much!
It should only change when you are editing. Leave the message in code format and save your flow, it shouldn't revert back. If you ever have to modify anything later, you may need to readjust that again.
Hi @clars234 ,
I was faced with the same issue and used a workaroud to solve this. Just use "Compose" to create the teams message in HTML format. The output of the compose action can then be used as the message text.
The link when received into the chat message via a flow opens in Excel Online. Is there any way around this? Teams settings are already set to open in desktop App. When I copy the link to the file from SharePoint and just paste it into a chat window, the link when clicked opens in the desktop app. I just want to replicate that in the flow.
Can someone please show me how the message shows up on teams apps, once the formatting is done using compose and HTML action?
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.
In our never-ending quest to improve we are simplifying the forum hierarchy…
We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…
These are the community rock stars!
Stay up to date on forum activity by subscribing.
Michael E. Gernaey 503 Super User 2025 Season 2
Tomac 321 Moderator
abm abm 237 Most Valuable Professional