cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
pgree
Regular Visitor

Launch Excel Action - Excel File Destination Syntax Error

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

pgree_0-1612757494884.png

 

1 ACCEPTED SOLUTION

Accepted Solutions
John_A
Microsoft
Microsoft

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 

😊

View solution in original post

2 REPLIES 2
John_A
Microsoft
Microsoft

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
Frequent Visitor

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

Helpful resources

Announcements
Microsoft 365 Conference – December 6-8, 2022

Microsoft 365 Conference – December 6-8, 2022

Join us in Las Vegas to experience community, incredible learning opportunities, and connections that will help grow skills, know-how, and more.

Top Solution Authors
Top Kudoed Authors
Users online (4,713)