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. Send only UTC DateTime values to SharePoint. Expect UTC DateTime values when reading from SharePoint.

To convert your data from your local machine's time to UTC, use DateTimeToLocal() and DateTimeToUTC(). Otherwise, use another Date/Time function to perform the calculation. See Functions.