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
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
Can someone please show me how the message shows up on teams apps, once the formatting is done using compose and HTML action?
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.
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.
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.
This worked PERFECTLY! Thanks so much!
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.
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>
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,
hi @Alice_italy you can try this options.
[Bing](https://bing.com)
<a href="www.google.com">GOOGLE</a>
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.
WarrenBelz
146,668
Most Valuable Professional
RandyHayes
76,287
Super User 2024 Season 1
Pstork1
66,004
Most Valuable Professional