Skip to main content

[en] SharePoint List Output Tool Icon SharePoint List Output Tool

警告

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

[en] The SharePoint List Output tool writes the content of a data stream to a SharePoint list.

[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: 2007, 2010, 2013, 2016, or Online.

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

    • [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.

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

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

    • [en] Example: Domain\username

  4. [en] (Optional) Select Save connection history 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] In Output Options, select an option for writing the list:

    • [en] Append Existing: Appends all the data to an existing table.

    • [en] Delete List and Append: Deletes all the original records from the table and then appends the data into the existing table.

    • [en] Update; Warn on Update Failure: Updates only existing records with the IDs you specify. If a record cannot be updated, a warning is reported.

    • [en] Update; Error on Update Failure: Updates only existing records with the IDs you specify. If a record cannot be updated, an error is reported and processing will stop.

: