Sharepoint 'Open File' Path

[martinbordasch]

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?

[salmankojar · Accepted solution]

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

[martinbordasch]

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.