How to get to a SharePoint link from PowerApps?

[cooper33]

I have a SharePoint list with rich text editors to add links. The links are mainly to items within the same SharePoint site. However I think on save only the part of the link after /sites/ gets saved. So when I try to click the links with PowerApps on the View form, it can't find the link (link looks like this: https://us.create.powerapps.com/sites/MySPSite)

I found this Idea about the same topic but wondering if there are any workarounds to handle this? Seems like it would be a fairly common situation

[RandyHayes]

@cooper33might take a look at this posting, it is similar to what you are looking for (different data source, but same concept).  See if that helps.  If not, post again.

[cooper33]

Thanks for the suggestion. Issue is that the links are stored in a rich text field so I won't know how they're going to be formatted or how many links there will be. So I don't think I can just parse out 1-many links especially without knowning where in the field they'll be

The field could look like this (fake links):

User ABC's new request

It could also look like this:

User ABC's updated request. They are looking for something like this

[RandyHayes]

@cooper33 

In that case have you considered using an HtmlText control to display your rich text field?  That will give you the complete text and the hyperlinks also, regardless of how many they are.

[cooper33]

Yes, sorry don't think that was clear but that's what I'm using. The links are there and clickable, it's just that none of the links are valid URLs. They're all stored as a relative link like this: /sites/MySPSite/Library/Doc1.pdf

Those work within SharePoint but not when accessed through the app

With your example you first mentioned I was thinking I could manipulate the link in the HTML control to manually add https://site.sharepoint.com before each link but without knowning what the rich text field will look like not thinking that's possible

[RandyHayes]

@cooper33Ah...I'm picking up what you're putting down now!

So yes, that would be the challenge with relative URL's.

What I would suggest is to perhaps, on your HtmlText property, change it to something like this:

   Substitute(yourColumnName, "/sites/MySPSite", "https://site.sharepoint.com/sites/MySPSite")

[Anonymous]

How do you stop from duplicating the url text?

Although it's a relative url, the display value includes "https://site.sharepoint.com/".
The substitute function makes it "https://site.sharepoint.comhttps://site.sharepoint.com/sites/mysposite".

It doesn't seem possible to substitute the initial "https:".

[Anonymous]

I have the same exact problem.  Wondering if you ever found a solution here?

[dnourie]

Spoiler

Same issue! Looked everywhere! Has anyone solved this?

[phuba]

Hi @cooper33  - @RandyHayes actually gave the right solution - a few additional words may help:
The rich text content actually has server-relative links that starts with "/sites/..." and, this is usually embedded in some HTML coding such as ...href="/sites/..."... ; the server is assumed to be "<tenant>.sharepoint.com" for SharePoint Online stored content (and therefore the full link resolves in the browser as "https://<tenant>.sharepoint.com/sites/..."). When the App is executed e.g. on Power Apps on a Smartphone, unfortunately, the server is not necessarilly "<tenant>.sharepoint.com" and the calculated full link resolves in nothing valid.
Within the App, I use a slighly different version of @RandyHayes proposal which is
Substitute(yourColumnName, """/sites/", "https://<tenant>.sharepoint.com/sites/")
it is a little bit more general - but it does not solve all issues - 
there are also valid links showing as "/:i:/r/sites/..." and sometimes I have even seen ":" HTMLencoded and so "/&#58;i&#58;/r/sites/...". You can obviously cascade the Subsitute() so that you euristicly and progressively cope with most situations... but it is far from a perfect solution - unfortunately.
My current code is 

/* Server-relative SP365 links embeded in Rich Text columns cannot be used when App runs
   in Power Apps on a smartphone. We convert them to Absolute links with <tenant>
   "server". we do this for standard links "/sites/" and special "/:i:/r/sites/"
   (in some case ":" becomes "&#58;" */
Substitute(Substitute(Substitute(<MyColumn>,
    """/sites/","""https://<tenant>.sharepoint.com/sites/"),
    """/:i:/r/sites/","""https://<tenant>.sharepoint.com/:i:/r/sites/"),
    """/&#58;i&#58;/r/sites/","""https://<tenant>.sharepoint.com/:i:/r/sites/")