Help with Sharepoint input tool error

[louyang]

Hi knowledgeable gurus,

Can I please have your help with the Sharepoint input tool error?

The workflow designed by my colleague (who has left the company) pulls files from Sharepoint, after running it there's error of Invalid extension.

The source files one is in xlsx format, one is zip form, both feed into macros.

I have upgraded Alterxy version to the latest 2025 version, as well as the Sharepoint connector.

Not sure why the extensions causing a difference, previously the workflow runs successfully with 2023 version on his computer.

Please kindly advise, thank you!

[abacon]

@louyang Yeah the SharePoint Input tool is relatively limited with the file extensions it can pull in. If you'd like to automate this section, your best bet is to use a batch script or a python script to unzip the files and then pulling them into the SharePoint Input tool.

Bacon

[louyang]

Hi abacon,

Thanks for the information.

My first question is for the excel files, I have already saved to the latest version, but SharePoint Input tool doesn't recognise it.

The second one is in relation to the zip folder, could you please tell me a bit more of how to fix that? I have very limited knowledge of batch script/python script.

Thank you so much!

[abacon]

@louyang  What do you mean it won't recognize the latest version of the excel files?

And I am not a python wizard but I know it can be used to extract zip files into a location, there is a lot of great documentation online about how to do this in python. Once you have done this, you can move it into the Alteryx Python tool to seamlessly move it into an Alteryx workflow.

Bacon