topic Re: Sharepoint 'Open File' Path in Qlik Automate

Sharepoint 'Open File' Path

martinbordasch — Wed, 10 Jul 2024 16:51:45 GMT

I've spend several days trying to get right the path format that the 'Open File' connector takes when Sharepoint is chosen. The 'Site ID' seems pretty straightforward, with the LookUp option. However, I tried filling in the path several different ways and none worked; URL coded, relative, starting with a '/', starting with the first folder, double URL coded... nothing seems to work. I actually created a flow in Power Automate just to get these different path types.

Has anyone successfully connected to a sharepoint site to open a file? If so, how did you write the path?

Re: Sharepoint 'Open File' Path

salmankojar — Fri, 12 Jul 2024 07:24:08 GMT

Hi, please go through attached screenshots of file path in SharePoint site and how i entered the file path in Automation block.

Re: Sharepoint 'Open File' Path

martinbordasch — Mon, 22 Jul 2024 17:08:31 GMT

Thanks, friend! Although my path is a bit longer than yours, the solution i found was in that general direction. See how my "Site id" contains the word "Suprimentos" in the end? I don't know how or why, but the correct Path starts with it. I just removed the "Shared Documents/" part and it worked.