Compatible with Designer 2021.4.2 Patch 6, 2022.1 Patch 4 and later.
Compatible with AMP engine only.
DCM is required for running this connector in Alteryx Server.
Disabled the right-click context menu in Designer for the SharePoint tools to prevent unintended actions.
Added a high precision data checkbox to let users opt into nanosecond precision for the DateTime and Time fields which use millisecond precision by default. The checkbox is off by default.
Introduced Dynamic Output which is a new Output Data section that lets you upload any local file to SharePoint via an incoming field.
Fixed issue where SharePoint Output wrote zero records or returned FieldTypeKind/null errors when overwriting lists with zero rows or when anchored to SharePoint Input. (TPM-4875)
Fixed issue where the SharePoint tools returned the double/int fields as v_wstring field in XLSX and Google Sheets files. (TPM-4873)
Fixed issue where DCM returned “User must be logged in” or NoneType errors. (TPM-4822)
Fixed issue where Designer exposed secret keys in the Debug/HTML Developer Tools.(TPM-4759)
Fixed issue where the results window displayed no information when reading an empty SharePoint List. The results window now displays the column names and metadata. (TPM-4730)
Fixed issue where SharePoint Input failed to return any results when reading data from a filtered list with more than 5000 rows. (TPM-4704)
Fixed issue where SharePoint Input failed with an error when reading 0 rows on filtered lists with more than 5000 rows. (TPM-4698)
Fixed issue where special characters in proxy passwords caused errors. (TPM-4695)
Fixed issue where the SharePoint tools version 2.7.3 failed to authenticate in Designer 2024.x. (TPM-4665)
Fixed issue where the SharePoint tools failed to correctly populate lookup fields for large SharePoint lists. (TPM-4628, TPM-4859)
Fixed issue where SharePoint Input created duplicate records when reading lists with more than 5000 rows. (TPM-4561)
Fixed issue where SharePoint Output failed to correctly append data to YXDB files. (TPM-4547)
Fixed issues where SharePoint Input returned errors when reading XLSX Named Ranges with “First row contains field names” enabled. (TPM-4546)
Fixed issues where SharePoint Input crashed with NDFrame.copy() error when reading Excel files in stream mode with “First row contains field names” enabled. (TPM-4531)
Fixed issue where SharePoint Output failed with “ID already exists” error. Upserting now works regardless of whether the new rows are at the top or the bottom of the input. (TPM-4527)
Fixed issue where SharePoint Output failed when appending to lists with Person or Group columns containing invalid emails. (TPM-4371)
Fixed issue where the SharePoint tools left incorrect file extensions in tool XML when switching from Files to Lists.
Fixed issue where the SharePoint tools couldn’t handle far-future dates (e.g., year 2999-01-01).
Fixed an issue where the SharePoint tools shortened or rounded large numbers from CSV files beyond Alteryx’s documented precision.
Fixed issue where SharePoint Output couldn’t write to Person/Group columns in SharePoint with “PrimitiveValue”/type-kind errors.
Fixed issue where GCC High + Service Principal couldn’t resolve file paths to list Documents. (TPM-4307)
Fixed issue where the SharePoint tools returned unclear WorkflowRuntimeError codes after file-lock or online-edit conflicts.
Fixed issue where the SharePoint tools fail to read and write large integers from XLSX and CSV files with “int too big to convert” errors. (TPM-4140)
Fixed issue where SharePoint Input couldn’t read inputs and returned “Length of values (0) does not match length of index (16)” errors.
Fixed proxy issues by adding proper Host headers to HTTP CONNECT requests.
Fixed issue where the SharePoint tools displayed incorrect tool tip text for Files and Lists. (TPM-3629)