Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.

Error when writing output to Sharepoint using Sharepoint Files ouptut tool

alakouki
5 - Atom

Hi All,

I have recently installed the Sharepoint Files Output tool, was able to connect to our company's sharepoint and i would like to create a workflow that writes its output to the Sharepoint. I Created a Sample workflow just to try it out but i keep receiving the following error : 

Error: SharePoint Files Output (3): Selected extension does not match with file extension. 

1.png

configuration.PNG

My input file is an xlsx file and am trying to write it out as xlsx as well.

 

I tried to play around with the tool's config , changed the ouput to csv , changed the input and nothing seems to get rid of this error.

Please Checkout the attached images and let me know if am missing something

thank you

 

4 REPLIES 4
gabrielvilella
14 - Magnetar

You probably need to insert the file extension on the field where you type the file name. And this should match what you have under the file format drop down. 

alakouki
5 - Atom

Thank you for your reply. I checked this several times and it matched. And Actually i solved this problem by adding a file to our sharepoint and setting the configuration to overwrite this file everytime i run the workflow as i dont need to create new files.

Madhavikishtipati
7 - Meteor

If you are uploading a CSV file you need to select the file type as CSV under "process file as", if xlsx then xlsx. this way it understands the actual file extension and the extension you give in configure file.

MarisaT
5 - Atom

What solved it for me was creating a blank .xlsx in the location.  Refresh your selected file section where you edit the path and name etc. Choose your new blank document. Select to overwrite in the configure file tab. 

Labels