I am using PowerApps to view SharePoint list items that have a rich text field that includes hyperlinks, so when I present those fields in PowerApps I have to switch the default text field for an HTML text field and insert "Parent.Default" as the HTML text data.
If the hyperlinks in those SharePoint fields point to external web links then all is fine but when those links point to other parts of the same SharePoint site, SharePoint automatically crops the https://sharepointdomain.com part and the link then reads, e.g. /sites/name/sitepages/content.aspx.
Since PowerApps was asked to read the SharePoint field exactly, those shortened links don't work. The links are interpreted as https://eu.create.powerapps.com/sites/.../...
I am looking for a SharePoint or PowerApps fix here.
This query proves very difficult to search for because its keywords are generally used in other contexts so if anyone can remember where a similar discussion took place I'd be happy to go there instead. Thanks for reading!
Solved! Go to Solution.
Thats the beauty (well...) of SharePoint. 🙂
What if you run a substitute on the PowerApps side on all links? All Sharepoint links will start with /sites/ which means you can do this:
It will, of course, mess upp correct links that happen to include "/sites/" but that can be prevented by:
if("http" in var_URL, var_URL, substitute(var_URL,"/sites/","https://yourtenantname.sharepoint.com/sites/"))
That line will return the url if it already includes "http" and otherwise it will fix the broken url.
Quite ugly, but i think it will fly.
I'm still having problems with this solution. In the HtmlText field I'm using:
The is a critical function for my app
Thanks in advane
this Substitute was what I was looking for as my RTF field does cut URL links as stated before.
I hope Microsoft will soon fix the hyperlink issue with SharePoint from PowerApps.
This solution is working for apps I open in Chrome (and the chromium-based Edge browser). Unfortunately, even though the URL is now fixed, images which are stored in Sharepoint, displayed in a Rich Text Field using the HTML text, are still not visible in my app when I try using the mobile app, windows app or view it in Internet Explorer.
Inspecting the image properties shows it has a correct link (using your proposed substitute fix), as it should. Any ideas???
Yes, there is a fix for that, but it is also quite ugly. The problem is that the image is not loaded through the connector which means that the app is not authenticated when it load the image. In the browser you are logged on, when using the desktop computer but not when using the mobile device.
You need to force the image to be loaded using the SharePoint connector. That can be accomplished by using this solution described here: https://powerusers.microsoft.com/t5/Building-Power-Apps/Uploading-images-to-SharePoint-list-without-...
Featuring samples like Return to the Workplace and Emergency Response Applications
We're excited to announce our first cross-community 'Can You Solve These?' challenge!
Reopen responsibly, monitor intelligently, and protect continuously with solutions for a safer work environment.
We are excited for the next Super User season.
Features releasing from October 2020 through March 2021