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

  1. Select a SharePoint Version.
  2. Type the full SharePoint URL or click the drop-down to select a saved URL.
  3. 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.

  4. Type your authentication credentials.

  5. Optionally select Save Connection to save the connection URL and credentials when you run the workflow. You can save up to ten connections.
  6. 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.
  7. Select a View from the drop-down. The available views are determined by the list you select.
  8. 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.

  9. 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.