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 raman_vee - using Power Query, I think you need to replace the " " with html codes (e.g. "%20" for space) and possibly add the ":u:/r" into the Path. The URL will look like this:
https://abc.sharepoint.com/:u:/r/sites/tmnapevASSYae/projects/07/Library%20Name/File%20Name.txt
Note you can use this Power Query function to escape the string. Uri.EscapeDataString - PowerQuery M | Microsoft Learn
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 !