How to read the excel file from sharepoint on gallery

Question

Hi all ,I'd like to read the excel file from sharepoint on gallery.

Designer : Alteryx Designer 2020.3 x64  (it will be better for me not updating the designer version.)

1.Workflow can read the sharepoint list by using sharepoint list input tool (but excel files are not able to be read by it, right? I'm not really sure)

2.Workflow can read the  file path below by standard input tool. it work well ,but when I saved the workflow on gallery, error: File not found

//companyname.sharepoint.com/site/subsite/folder/subfolder.../filename.xlsx

( in this way, is it possible to do some changes to make it run successfully on gallery)

3. if the two ways above won't work on gallery, is there any workflow template or sample for me to read the file from sharepoint? like get access token with download and json parse tool?

arvindhbhujang · Answer

Hi Mcleavy,

hope you are doing well.

The above links are not working, kindly share me with the latest ones in your free time.

Thanks,

Arvind

arvindgbhujang@gmail.com

mceleavey · Answer

Hi @cyg3003 ,

the reason it's not working from the server is the relative path you're using is relative to the machine on which you built the workflow. The server path will be different. You can change the path so it can find the folder form the server providing the server is able to actually connect to the SharePoint folder location.

Alternatively, you can use the SharePoint files tool:

https://help.alteryx.com/20221/designer/sharepoint-files-input-tool

This will connect you directly to your SharePoint instance, and allows you to download files, not only SP lists. You may also wish to download the output tool as well:

https://help.alteryx.com/20221/designer/sharepoint-files-output-tool

I hope this helps,

M.