cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
DawgPoundMBA1
Advocate I
Advocate I

Building a Hyperlink in Flow that will open with Teams, not Excel/Word online

I have built workflows that move documents from a list to a document library related to a team site and enters the relevant metadata for each item in the doucment library.  Then I have a separate flow that associate the item in the document library back to the original list as a hyperlink. My concern now is that I want those hyperlinks to open in the Teams document library (so I can use the discussion feature within Teams on each item).

 

Now I get the correct URL linked back to the list (using Flow's link to item dynamic value) and the file opens in the appropriate word, execel, etc., online app.  It does not open it within word.  When I look at the URLs for the same file from Teams versus Excel online I see that the Teams have a prefix specific to teams.  What prefix should I add to my hyperlink URL during the Flow build to tell the file to always open in teams.  It appears that there are different 'viewers' within the prefix that would vary based on file type.  See below.

 

URL from Teams https://teams.microsoft.com/_#/xlsx/viewer/teams/https%3A~2F~2Fbbins365.sharepoint.com~2Fsites~2FGRP...https%3A~2F~2Fbbins365.sharepoint.com~2Fsites~2FGRP-AERT3&fileId=B90718D7-FDDB-4578-8154-11480A1DE14E&ctx=files&viewerAction=view

 

URL pulled from link to item

https://bbins365.sharepoint.com/:x:/r/sites/GRP-AERT3/_layouts/15/Doc.aspx?sourcedoc=%7BB90718D7-FDD...%7D&file=3%20Mainframe%20APD6%20Carriers%20from%20RiskMatch.xlsx&action=default&mobileredirect=true

1 ACCEPTED SOLUTION

Accepted Solutions
v-yuazh-msft
Community Support
Community Support

Hi @DawgPoundMBA1,

 

Could you find the differences between the two links?

I have made a test on my side and I afraid that it's difficult to build a Hyperlink in Flow that will open with Teams.

 

Best regards,

Alice

View solution in original post

2 REPLIES 2
v-yuazh-msft
Community Support
Community Support

Hi @DawgPoundMBA1,

 

Could you find the differences between the two links?

I have made a test on my side and I afraid that it's difficult to build a Hyperlink in Flow that will open with Teams.

 

Best regards,

Alice

nickduxfield
Responsive Resident
Responsive Resident

I managed to get some methods for achieving this using ms teams media viewer.

However the issue im now having is VIDEO urls don't behave the same in the MOBILE version of the app.

All works perfectly using the DESKTOP and WEB version.

 

The question then is what URL is generated in the CDN.

If i can figure out how to do this without diving into further study it would be great.

Helpful resources

Announcements
Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

MPA Virtual Workshop Carousel 768x460.png

Register for a Free Workshop

Learn to digitize and optimize business processes and connect all your applications to share data in real time.

Power Automate Designer Feedback_carousel.jpg

Help make Flow Design easier

Are you new to designing flows? What is your biggest struggle with Power Automate Designer? Help us make it more user friendly!

Users online (2,483)