Skip to main content

[en] SharePoint List Input Tool Icon SharePoint List Input Tool

警告

[en] The SharePoint List tools are deprecated. Install the SharePoint tools which provide updated features.

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

[en] DateTime data and SharePoint

[en] SharePoint stores all DateTime values as UTC. To correctly convert your system's DateTime values to and from UTC, do the following:

  • [en] When writing to SharePoint, convert your system's timezone to UTC with the DateTimeToUTC() function.

  • [en] When reading from SharePoint, convert from UTC to your system's timezone with the DateTimeToLocal() function.

[en] Otherwise, use another DateTime Function to perform the calculation. For additional information, see Functions.

[en] Tool Configuration

  1. [en] Select a SharePoint Version.

  2. [en] Type the full SharePoint URL or click the drop-down to select a saved URL.

    • [en] http://sharepoint.mydomain.com/mydepartment/

      重要

      [en] 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.

  3. [en] Type your authentication credentials.

    • 2007, 2010, 2013, 2016

      • [en] Type your User Name and Password. The user name must include the domain name.

    • [en] Online/Office 365

      • [en] Type your Email Address and Password.

    • [en] App Only Authentication

      • [en] Type your Client ID and Secret Key.

  4. [en] Optionally select Save Connection to save the connection URL and credentials when you run the workflow. You can save up to ten connections.

  5. [en] Select a List. The contents are specific to the URL you specify. If your URL contains a directory, only lists for that directory are shown.

  6. [en] Select a View. The available views are determined by the list you select.

    注意

    [en] "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 Designer.

  7. [en] 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.

  8. [en] Optionally specify a Record Limit. To read in all records, leave this field blank.

: