Solved: Sharepoint URL converted when accessing from PowerApps custom form

[Anonymous]

Hello,

I created a sharepoint list with Sharepoint URL inside of it.

The content of this Sharepoint list is then displayed in PowerApps custom form.

Once users are in PowerApps and they click on this Sharepoint URL,

the URL is modified from "https://my-domain.sharepoint.com/sites/..." (where my-domain represents the name of my company) to "https://content.powerapps.com/sites/..." automatically,

resulting to an Error 404.

I have this issue only with Sharepoint Site URL.

I put a URL of another site and it's working fine.(e.g. www.google.co.jp)

Why Sharepoint Site URL is converted?

How to avoid that?

Best Regards,

Kuranoo

[v-jefferni]

Hi @Anonymous ,

Yes if URL in SharePoint it would be convert to like "sites/...".

So you could use Switch function to manually complete the URLs from SharePoint:

Substitute(Parent.URL,"/sites/","/https://domain.sharepoint.com/sites/")

Hope this helps.

Best regards,

Community Support Team _ Jeffer Ni
If this post helps, then please consider Accept it as the solution to help the other members find it.

[Anonymous]

Hi @v-jefferni 

Thank you for your help.

I'm sorry, but I don't know how to use the Switch function.

How to use the function?(Where is the setting in Sharepoint or PowerApps?)

Best Regards,

Kuranoo

[StevePenner]

@Anonymous 

Switch() function reference: https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/functions/function-if

[v-jefferni]

Hi @Anonymous ，

My bad and apologize for the typo, it is the Substitute function and I have the formula in the last post:

Substitute(Parent.URL,"/sites/","/https://domain.sharepoint.com/sites/")

You will need to apply this formula on where you display the URL e.g. on the OnSelect property of a Label with a Launch Function:

Launch(Substitute(Parent.URL,"/sites/","/https://domain.sharepoint.com/sites/"))

Hope this helps.

Best regards,

Community Support Team _ Jeffer Ni
If this post helps, then please consider Accept it as the solution to help the other members find it.

[Anonymous]

Hi @v-jefferni 

Thank you for your help.

I apply the formula on the OnSelect property, but it's not working.

However, I apply this formula on the HTMLText property, it now works.

Substitute(Parent.Default, "href=""/sites/", "href=""https://my-domain/sites/")

This issue is solved.

Thank you so much for taking the time to help.

Best Regards,

Kuranoo