Launch Excel Action - Excel File Destination Syntax Error

[pgree]

Hello,

I am trying to build a flow that will extract the last row of data from an excel workbook to upload to a desktop legacy system.  The source file is saved in my OneDrive folder.

When I copy and paste the destination file path address I get a syntax error. I have altered the document path words that appear below, for privacy reasons, but the format is as shown.  Does anyone know what the issue may be?  The error handling gives no indication.  Thanks PG

[John_A · Accepted solution]

The % is used to declare a variable. Therefore PAD expects a variable that it cannot find in this case. In order to use it as literal you will need to escape it using one more % before it. 

so your document path will look like ......./file%%20name.xlsx 

😊

[ThePobblebonk]

Hi,

This trick appears to be no longer working so would appreciate some guidance on what we need to do to access excel files in SharePoint.

The one I am having trouble with is like this:

https://<<Server>>/sites/it/op/App%%20docs%%201/Mat%%20Working/AppsCentralLinks.xlsx