Force Office Files to Open in Desktop App (via link, from web parts.. in all cases)

wkeber so I am attempting to solve this myself... The only "solution" I have found is using office URI schemes. However, I am very much using quotes around "solution" because, at least in my case, it is not working reliably.

See this link for more info → https://docs.microsoft.com/en-us/office/client-developer/office-uri-schemes 

but basically, it is a bit of code in front of your link that forces certain word functions. For example adding "ms-word:ofe|u|" to the front of a link will force the file that is linked (assuming it's a Word doc) to open in word, and specifically in editing mode. There are options for opening in other office apps or in other modes (such as viewing mode, etc). However, the catch I've found is twofold: 

1. Unless you are pasting this edited link directly into your browser bar, it seems that Microsoft apps often default to each specific user's profile preferences. SO if in Word under Options>Advanced>Link Handling, or in Teams under Settings>Files you would need to allow those apps to open in the desktop app. If they do not have these settings turned on, you cannot force open in desktop apps. 
2. It sometimes makes the string of text unrecognizable as a link to the program you are using. I am not sure, but this seems to be because most hyperlink software searches for the string "http..." or "https..." at the beginning to be able to identify that string as a link. 

Also, they will only work with "http(s)" links, never "www", etc. 

So maybe this will help you, I hope so!

Update: I have been able to get this to work reliably now, had to sort out a few bugs elsewhere in my Power Automate flow.