Microsoft SharePoint

Version:
2019.3
Last modified: September 26, 2019
Connection Type

Alteryx Tools

Driver Details

Register and obtain credentials from Microsoft SharePoint.

Type of Support

Read & Write

Validated On

2007, 2010, 2013, 2016, Online

Alteryx tools used to connect

Standard workflow processing

Link
SharePoint List Input Tool Icon

SharePoint List Input Tool

Link
SharePoint List Output Tool Icon

SharePoint List Output Tool

Additional Details

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

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

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

Was This Helpful?

Need something else? Visit the Alteryx Community or contact support.