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.