Alteryx and SharePoint

Updated: Jun 23

Do you want to pull documents into your workflow from a SharePoint library or document folder? Did you know there is an easy way to do this?


In your SharePoint documents folder go to the Library tab. Click on Open with Explorer. Please note: your SharePoint administrator may have this option disabled.



This will trigger a pop-up a File Explorer folder window in Windows with all of the documents contained in this SharePoint folder. Simply drag the document you want straight to the Alteryx Canvas.


The Input tool will appear and it will contain the URL for your SharePoint document. It should look like the below. Keep this in mind should you need to write data back out to the SharePoint Library.


https://companyname.sharepoint.com/sites/site-name/


If the administrator has the file explorer option blocked, you will need to type in the URL manually within your Input Tool. There are several ways to do this depending on how the server is set up.


Do you want to pull in items from a SharePoint List? Did you know there is a SharePoint List Input Tool and a SharePoint List Output Tool?


Perform a search for SharePoint or pull this Tool from the Connectors tab of your Alteryx Tool Palette.




You will need to select the version of SharePoint you are using.

Enter the URL of the list in the SharePoint URL field.

Enter your user name with how it is set up for your site. It could look something like this;


USA\Username


Then enter your password in the Password field. Alteryx will connect to your site behind the scenes. You can tell your log in was successful if the List field automatically populates with the different lists found in your SharePoint site.

Please note the View will always display the default view for the SharePoint List. If you have created any custom views, they will appear in the drop-down.


Update: If you are writing out to an existing SharePoint list, ensure all of your columns are in the exact same order as the columns in the list, or you will receive an error.

48 views0 comments