- 2023.2
- Designer
- Data Sources
- Microsoft SharePoint
Microsoft SharePoint
Connection Type | Alteryx Tool. The latest version is available from the Alteryx Marketplace. |
Driver Details | For more information, see Microsoft portal. |
Type of Support | Read & Write |
Validated On | SharePoint Files tools: Online SharePoint List tools: 2007, 2010, 2013, 2016, 2019, Online |
Version | Description |
v2.5.0 |
|
v2.4.2 |
Known Issue
|
v2.4.1 |
Known Issues
|
v2.4.0 |
Known Issues
|
v2.3.0 |
Known Issues
|
v2.2.0 |
|
v2.1.0 |
|
v2.0.1 |
|
v1.1.1 |
|
v1.1.0 |
|
v1.0.x |
|
Alteryx Tools Used to Connect
Important
As of Alteryx Designer and Server 2022.3, we deprecated the SharePoint List tools. Install the SharePoint tools which provide updated features.
We renamed SharePoint Files to SharePoint in version 2.2.0.
In SharePoint version 2.2.0, we temporarily removed support for SharePoint On-Premise (version 2013 and 2016). In SharePoint version 2.3.0, we re-enabled the support for SharePoint On-Premise.
As of SharePoint Files Output version 2.1.0, we included the list reading functionality in SharePoint Files Output.
As of SharePoint Files Input version 2.0.1, we included the list reading functionality in SharePoint Files Input.
Standard Workflow Processing
SharePoint Input Tool
SharePoint Output Tool
SharePoint List Input Tool
SharePoint List Output Tool
Data Connection Manager
The SharePoint tools version 2.2.0 and later support Data Connection Manager for an easier and a safer storage of your credentials. Create a connection to SharePoint and easily reuse the stored credentials in workflows that include the SharePoint tools. Alteryx Server requires stored credentials to successfully run the published workflows.
Enable AMP Engine
Make sure you have the AMP engine enabled for the workflows which contain the SharePoint tools version 2.2.0 and later.
Custom Microsoft Azure API Application Setup
To set up a custom API application for this tool, see our guide.
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.
Important
Desktop Automation (Scheduler) is not supported by SharePoint (SharePoint Files).