Microsoft SharePoint

Type of Support: Read & Write
Validated On: 2007, 2010, 2013, 2016, Online
Connection Type: Alteryx Tools
Driver Details: Register and obtain credentials from Microsoft SharePoint.

Alteryx tools used to connect

SharePoint List Input Tool and SharePoint List Output Tool (Standard workflow processing)

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.