I have a workflow that I downloaded from a SharePoint site. The file saves in my downloads and opens automatically. When I hit run, it takes a file from the C:\ drive and saves a copy of it to the SharePoint site.
First it adds a column to the end which has the filename to save as, file name is like:
The output takes the file name from the field and changes the entire path
When I run it I get the following error:
Error: Output Data (120): Unable to Open archive for zipping: C:\Users\username\Downloads\https:\\sites.inside-share2.company.com\sites\105630\Documents\Reports\2019\September-2019\September-2019.xlsx Error Opening file: C:\Users\username\Downloads\https:\\sites.inside-share2.company.com\sites\105630\Documents\Reports\2019\September-2019\September-2019.xlsx
: The filename, directory name, or volume label syntax is incorrect. (123)
It is adding the workflow file location to the [ExportName] field, "C:\Users\username\Downloads\". I cannot figure out why.... Can anyone help?
Solved! Go to Solution.
See danilang's post below
hi @oneillp111
Put a Browse tool after your second formula and check what the value of the fields [filename] and [file] are and compare them to what you think ExportName should be.
Even once you get this fixed, Alteryx can't write directly to SharePoint libraries without using WebDAV, so your URL
https:\\sites.inside-share2.company.com\sites\105630\Documents\Reports\2019\September-2019\September-2019.xlsx
won't work
You can find details of how to work with WebDAV here
Dan