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
