- 2025.2
- Designer
- Data Sources
- Microsoft SharePoint
Microsoft SharePoint
New Connector Version in Designer
The SharePoint connector is now part of the Alteryx One experience. Review the information on this page carefully to ensure you're using the appropriate tools correctly.
If you want to update the SharePoint connector in your Designer Desktop workflows, you can use the workflow migration utility.
The Microsoft SharePoint connector lets you connect to Microsoft SharePoint storage in Designer Desktop.
Microsoft SharePoint is available as a data source in the Input Data and Output Data tools, and it supports reading from and writing to both Files and Lists. The standalone SharePoint Input and SharePoint Output tools are deprecated.
Connector Type | Availability | Tools and Data Processing Options |
|---|---|---|
The latest version is available from the Alteryx Marketplace. | ||
Microsoft SharePoint Connector Version 2.7.7 and Earlier (Deprecated - Limited Support) | The latest version is available from the Alteryx Marketplace. |
Microsoft SharePoint Connector Details
Microsoft SharePoint is available in Designer Desktop 2025.1.XX and later as a data source for the Input Data and Output Data tool. To learn more about the file type options, go to Read Data from SharePoint or Write Data to SharePoint.
March 17, 2026
Microsoft SharePoint Connector Version 3.1.0
What's New
The Microsoft SharePoint connector is now available to the public.
Fixed Issues
Fixed Microsoft SharePoint Connector Version 3.1.0 | |
|---|---|
ID | Description |
TCO-3269 | The SharePoint connectors return an error when testing a connection with a proxy enabled. |
TCO-3168 | The SharePoint Output tool returns a “Failed to fetch data” error when writing a new file to an empty folder. |
TCO-3154 | The SharePoint List Output tool fails to complete writing large lists. |
TCO-3144 | The SharePoint File and List Input and Output tools work with Browse by link for the default scope and all authentication types. |
TCO-3124 | The SharePoint List Output tool adds duplicate records to the list. |
TCO-3094 | Writing doesn’t work with Sites.Selected permission in the SharePoint tools. |
TCO-3068 | Writing files with a Service Principal fails for Sites.Selected permission due to path resolution errors with “Access Denied” in the SharePoint tools. |
TCO-2974 | Manual file path editing doesn’t work correctly in all cases in the SharePoint tools. |
TCO-2949 | Search fails to find an existing list and returns a “Failed to fetch data” error in the SharePoint tools. |
TCO-2795 | Writing a table with an “ID” column to a SharePoint List results in a silent failure without an error message. |
TCO-2788 | Append operations succeed even when no matching columns exist between source and destination tables. |
TCO-2783 | Append operations succeed when the source has extra columns, but the target is not updated and no error appears. |
TCO-2777 | Users can’t select a list by typing the full path in the breadcrumb. |
TCO-2775 | Search fails to find an existing list and returns a “Failed to fetch data” error in the SharePoint tools. |
TCO-2774 | The OAuth client list doesn’t populate for the SharePoint List connector. |
TCO-2771 | The SharePoint List connector returns an HTTP 200 response for an invalid Authority URL, resulting in incorrect error handling. |
TCO-2600 | The SharePoint List Output tool maps FixedDecimal values incorrectly, causing numerical inaccuracies. |
Cancelled Issues
Cancelled Microsoft SharePoint Connector Version 3.1.0 | |
|---|---|
ID | Description |
TCO-3360 | The SharePoint List Output tool doesn’t allow users to select a primary column when the output action is set to Delete. |
TCO-3115 | The SharePoint Input tool returns an error when reading files with 128-character names. |
TCO-2979 | The SharePoint Input tool shows inconsistent behavior when reading metadata. |
TCO-2972 | The SharePoint List tools intermittently fail to resolve connections after updating OAuth credentials and only succeed after a delay. |
TCO-2895 | The SharePoint Output tool returns an UnboundLocalError when selecting an empty or newly created folder. |
TCO-2893 | The SharePoint List Output tool doesn’t preserve the original row order when writing data to a list. |
TCO-2796 | Null values are not written to SharePoint Lists. |
TCO-2790 | Create and Append actions don’t work in Standard mode. |
TCO-2781 | The SharePoint List Output tool doesn’t notify users when partial list creation occurs. |
TCO-2772 | Creating a SharePoint List connection with a Service Principal certificate returns inconsistent payloads. |
TCO-2722 | The SharePoint List Output tool can’t perform output actions using Service Principal certificate authentication. |
TCO-2602 | The SharePoint List Output tool writes floating point numbers with rounding errors. |
TCO-2601 | The SharePoint List Output tool skips records with out-of-range DateTime values without any notification. |
TCO-2326 | The SharePoint List Output tool creates lists with missing records when using mixed data and doesn’t log errors or failed record IDs. |
TCO-2286 | DCM handling doesn’t work correctly with the SharePoint Output tools and EACD connectors. |
TCO-2234 | The SharePoint Input tool ignores the first row when it is not used as a column name. |
TCO-2095 | The SharePoint Output tool disables From and To fields when Specify a Range is selected. |
October 24, 2025
Microsoft SharePoint Connector Version 3.0.0
What's New
To align the user experience between Alteryx One and Designer Desktop, we're releasing a new Microsoft SharePoint connector for Designer Desktop. This connector enables a DCM connection to Microsoft SharePoint in the Output Data tool.
Known Issues
Known Microsoft SharePoint Connector Version 3.0.0 | |
|---|---|
ID | Description |
TCO-2795 | Writing a column named “ID” from Alteryx One to a SharePoint List results in a silent failure without any error message. |
Requirements
Requirement | Details |
|---|---|
Designer Desktop | Designer Desktop 2025.2 Patch 3 or later. Designer Desktop 2025.1 Patch 5 or later. |
Connector Version | Microsoft SharePoint version 3.1.0 or later. Available from Designer Add-Ons. |
Azure Permissions | |
You must enable DCM in Designer Desktop. Go to Options >Advanced Settings > DCM to enable it. | |
Network Access | Outbound access to SharePoint Online and Microsoft OAuth endpoints. |
Install the Connector
You can easily install the latest version of the SharePoint connector from Designer Desktop via the Add-Ons. You don't need to visit Alteryx Marketplace if you install connectors this way.
Note
Designer Desktop Add-Ons
The Add-Ons window lets you browse, install, and update connectors without leaving Designer. It is the recommended installation process for the latest versions of connectors.
To install the connector…
In Designer Desktop, go to Add-Ons > Manage Marketplace Add-Ons.
Designer Desktop opens a window with a list of available connectors.
Type SharePoint to search.
Find Microsoft SharePoint Connector v3.1.0 or a later version.
Select the connector, then select Install. Designer Desktop will automatically download and install the package. Designer Desktop might require a restart to complete the installation.
After the installation and setup are finished, the SharePoint connector is available in the Connectors category of the Tool Palette. The Output Data tool also lists Microsoft SharePoint Files and Microsoft SharePoint Lists as available data sources.
Workflow Migration
Use the workflow migration utility to update existing workflows.Installing a new version of a connector doesn't automatically migrate your existing workflows. You only need to migrate workflows that use the deprecated SharePoint Input or SharePoint Output tools.
The workflow migration utility previews the changes, replaces deprecated tool instances with the new versions of connectors, without breaking your workflow or losing your configuration.
Authentication Methods
Microsoft SharePoint supports basic authentication with user's credentials (Azure AD-private (Built-In App)), custom application (Azure AD-private (Custom App)) and advanced custom API app authentication (Service principal (Application)).
Azure AD-private (Built-In App)
The basic authentication with email and password is tied to the user's personal Google credentials. You can allow this connection for the SDK.
We don't recommend this type of authentication for scheduling workflows.
Azure AD-private (Custom App)
For instructions on how to set up the API app, see our Microsoft Azure API app setup. You can allow this connection for the SDK.
Service principal (Application)
Advanced authentication leverages the capabilities of custom API applications with a service principal. For instructions on how to set up the API app, see our Microsoft Azure API app setup. You can allow this connection for the SDK.
The API apps with a service principal aren't tied to a specific user, so you can use them more conveniently for scheduling workflows. However, they require one-time authentication when you create a connection in DCM.
Service principal (Certificate)
To enable SharePoint app-only authentication, you need to create a certificate, upload it to the Azure portal, and obtain a private key. The app-only authentication works for SharePoint Lists in all versions of the SharePoint connector and for SharePoint Files in version 2.7.2 and later.
For instructions on how to set up the API app, see Create Certificate for SharePoint App-Only Authentication. This app-only authentication is supported only via DCM.DCM - Designer
Set Up a Connection with DCM
To connect to Microsoft SharePoint with DCM...DCM - Designer
Drag the Input Data or Output Data tool from the tool palette to the canvas, and select it.
Select Set Up a Connection.
If you've created a Microsoft SharePoint connection before, you can select Data Sources > Microsoft SharePoint Files or Lists > Quick connect , and skip to step 12.
In the Data connections window, select Data Sources.
Find Microsoft SharePoint Files or Lists, and select Quick Connect.
The Connections window opens.
Select + New to create a connection.
Enter a connection name of your choice.
In the Data Source section, Designer automatically selects the Microsoft SharePoint data source technology.
Enter a data source name of your choice.
In the Credentials section, select your authentication method, and enter the credentials. Refer to the authentication method in the previous section for details.
Select Save. You can also test the connection before saving.
Select Connect. Microsoft SharePoint may request authentication.
Select the file to read from or write to in the file browser window.
Select the read or write configuration in the Options window.
Select Confirm to create a connection to the file. You can continue building your workflow.
Important
As of March 2026, we deprecated the standalone SharePoint tools. Install the latest SharePoint connector to leverage the newest features.
March 12, 2026
SharePoint Version 2.7.7
Fixed Issues
Fixed SharePoint Version 2.7.7 | |
|---|---|
ID | Description |
TPM-5063 | The SharePoint Output tool can’t create a YXDB file after upgrading Python to version 3.13.11. |
TPM-5062 | The SharePoint tools fail to read XLSX files after upgrading Python to version 3.13.11. |
TPM-5080 | Metadata isn’t populated when Attach Metadata is enabled for a CSV file. |
TPM-4989 | The SharePoint Input tool doesn’t return the file name for CSV files when LinkFilename is enabled. |
TPM-4552 | Custom apps using GCC High environments don’t work with the SharePoint tools. |
TPM-4066 | The SharePoint tools fail to connect through certain proxy servers because the CONNECT request doesn’t include a Host header. |
Known Issues
Known SharePoint Version 2.7.7 | |
|---|---|
ID | Description |
TPM-5118 | The SharePoint tools version 2.7.6 don’t display refined sites.search results in the dropdown. |
TPM-5072 | The SharePoint Input tool for Lists fails with the error “Failed to update the Person records” when the Document Library contains a large number of items. |
TPM-5066 | The SharePoint List tools return an error when a search filter is applied in the configuration. |
TPM-5042 | The SharePoint tools fail after updating to version 2.7.3. |
TPM-4959 | Uploading data to SharePoint Lists fails when the site language is set to French. |
Cancelled Issues
Cancelled SharePoint Version 2.7.7 | |
|---|---|
ID | Description |
TPM-4894 | The SharePoint Input and Output tools version 2.7.3 parse proxy settings differently when WPAD is enabled. |
TPM-4355 | Kerberos authentication isn’t supported in the SharePoint Input and SharePoint Output tools. |
TPM-5076 | The SharePoint Output tool doesn’t support dynamic file naming when writing YXDB files. |
TPM-5070 | PyPAC returns an incorrect private IP address in the CIBC environment. |
TPM-5033 | A 404 error appears in the login UI when setting up app-only Service Principal authentication for SharePoint Lists or Files using a certificate. |
TPM-5026 | The SharePoint List tools return a ValueError when modifying credentials pulled from DCM and authenticating without DCM. |
TPM-5022 | The SharePoint tool version 2.7.4 can’t update SharePoint sites when used with Interface tools or Macros. |
TPM-4908 | The SharePoint Output tool in Designer fails to update “People or Groups” fields when using identifiers such as email addresses, employee names, or claims strings. |
TPM-4806 | The SharePoint Output tool returns an error when appending data to an existing CSV file. |
TPM-4551 | Service Principal authentication with GCC High environments doesn’t work with the SharePoint tools. |
TPM-4512 | Appending to a list with a Person or Group column type fails with an error in the SharePoint tools. |
TPM-4510 | The SharePoint Input tool handles Double column data types incorrectly. |
TPM-4444 | The SharePoint Input tool returns Date and Time values with an extra fractional component. |
TPM-4443 | The SharePoint Input tool doesn’t return metadata for YXDB and CSV files when Attach Metadata is enabled. |
TPM-4441 | The SharePoint Input tool returns TIME and DATETIME values with an extra “.000000000” in YXDB files. |
TPM-4303 | Appending multiple columns to a YXDB file using built-in authentication completes without an error, but the resulting file contains empty data. |
TPM-4274 | Updating a SharePoint List that contains a null value in a Date field returns this error: Error code 400: Bad request syntax or unsupported method. |
TPM-4071 | The SharePoint Output tool writes float values with insufficient precision. |
TPM-4015 | The SharePoint Input tool returns an error when selecting Document in SharePoint Lists. |
TPM-3975 | The SharePoint Output tool doesn’t overwrite a list when only header rows are provided as input data. |
TPM-3795 | The SharePoint Output tool doesn’t upload fields that start with an underscore when writing to a SharePoint List. |
TPM-3785 | In SharePoint On-Premise, overwriting a sheet removes other sheets in the file and keeps only the overwritten sheet. |
TPM-3783 | The SharePoint Input tool returns DateTime metadata as a string when reading SharePoint Lists. |
TPM-3773 | The SharePoint Input tool returns an “Int too big to convert” error for Int64 data types. |
TPM-3711 | The Start in Cell option in the SharePoint Output tool doesn’t work correctly for overwrite sheet and append operations. |
TPM-3171 | The SharePoint List append operation fails when using the email value of a Person or Group field with multiple selection disabled. |
Version | Description |
v2.7.6 |
Known Issues
|
v2.7.5 |
|
v2.7.4 |
|
v2.7.3 |
|
v2.7.2 |
|
v2.7.0 |
|
v2.6.3 |
|
v2.6.2 |
Known Issues
|
v2.6.1 |
|
v2.6.0 |
Known Issue
|
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 |
|
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 enable the AMP engine for the workflows that contain SharePoint tools version 2.2.0 and later.
Custom Microsoft Azure API Application Setup
To set up a custom API application for this tool, go to our guide.
Enable Legacy Encryption Methods
If you're connecting to SharePoint On-Premises or using a proxy with NTLM authentication, you need to enable Encryption Methods in OpenSSL3.
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).




