Forum Discussion
HTML Viewer dropping off SharePoint part of URL and Erroring
Most Valuable ProfessionalIf the URL you're using is a column on the table, you can just add a custom column that concatenates the https://whatever.sharepoint.com with the other column to make a complete link? In Power Query you can just use an "&" to concat - so "https://tenantname.sharepoint.com" & [other url column here]
That wouldn't work for how I'm using the links as I have it saved with other notes among the hyperlink. This wasn't an issue before I moved the data source to the same sharepoint as the links I'm trying to include, so I'm unsure if there is a way to get the link to stop truncating besides moving the data soruce to another sharepoint
- christinepayton
Oh, if it's in a notes field with other stuff, you should be able to do a "replace" step on the column - just replace "/sites/" with "https://yourtenant.sharepoint.com/sites/". This is assuming you don't have other hyperlinks with /sites/ in the path.
I did that, and it still errors. The issue seems to be when I go to open the link. The link will show fine in the html viewer and then it truncates when I select it. I've tried looking through settings, but I'm not sure why sharing part of the same URL as the data source is causing an issue