post link (URL) to Microsoft Teams chat

[Alice_italy]

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

[Krishna92]

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

[ChristianAbata]

hi @Alice_italy  you can try this options.

[Bing](https://bing.com)

<a href="www.google.com">GOOGLE</a>

[v-bacao-msft · Accepted solution]

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,

[Sastro_Chang]

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 &nbsp;- </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"> &nbsp;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>

[clars234]

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.

[TheBrittinator]

This worked PERFECTLY! Thanks so much!

[TheBrittinator]

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. 

[MarcLudwig]

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.

[paddysheeran]

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.

[viplavmulkacpm]

Can someone please show me how the message shows up on teams apps, once the formatting is done using compose and HTML action?