Forum Discussion
SharePoint Document Library File URL
I was able to get it working now, just be typing in a blank space, replaced the relativeURL with %20 and then modified the '/sites' to add in the http:// etc. each file works now, your suggestion was nearly correct but the u:/r:/ did not make it work. Thanks so much !
Hi ! Thanks for the response !
I was able to get this working actually using the "linkingurl" field that I extracted from the metadata in Power Query, but it only seems to work for Microsoft365 documents, not .pdf, .txt files etc
I put them in a table with webURLs, I am extremely close to getting where I need to be. I basically want a document summary dashboard page for my project reports.
Here's what I got so far:
The purple box in the first photo, ideally I want clickable links to all those documents. But it won't work for non MS office docs.
The green box shows where I got the linking url information for my table, as you can see it only shows up for the MS offfice files.
Any help on figuring this out would be appreciated !
Ok - if you have a valid link, are you trying to add this using Conditional Format WebURL?
Want to use a URL for your text column in Power BI Desktop? Check THIS out! - YouTubeI don't have a valid url for the non-MS Office docs it seems, unless I transform all the relative site URLs to work?