You are here:

SharePoint List Input Tool

The SharePoint List Input tool reads lists from SharePoint to be used as data input in a workflow.

Configure the tool

Select a SharePoint Version.
Type the full SharePoint URL or click the drop-down to select a saved URL.

When scheduling your workflow to run from Alteryx Server, the URL must be accessible outside of your Windows account. For example, WebDAV paths are not supported. See Schedule Workflows.

Type your authentication credentials.
2007, 2010, 2013, 2016
Type your User Name and Password. The user name must include the domain name.
Online/Office 365
Type your Email Address and Password.
App Only Authentication
Type your Client ID and Secret Key.
Optionally select Save Connection to save the connection URL and credentials when you run the workflow. You can save up to ten connections.
Select a List from the drop-down. The contents are specific to the URL you specify. If your URL contains a directory, only lists for that directory are shown.
Select a View from the drop-down. The available views are determined by the list you select.
List view threshold error
"The attempted operation is prohibited because it exceeds the list view threshold enforced by the administrator" is a SharePoint error. Remove any sorts or filters from your SharePoint list view. Then process the unfiltered, unsorted data in Alteryx.
The Refresh button clears cached data to update the available lists and views.
Lists and views are refreshed when you refresh the workflow by pressing F5.
Optionally specify a Record Limit. To read in all records, leave this field blank.

SharePoint automatically stores date/time data in UTC format. Date/time data is automatically converted to your local timezone when Alteryx reads a SharePoint list.