Connecting and writing to SharePoint lists using Alteryx

Question

Hi Everyone,

I am trying to use push data into a SharePoint list from RDS using Alteryx. 
Alteryx Version: 2021.4
SharePoint Connector Version: 2.3

We are facing a few issues pushing the data to SharePoint while using these connectors: 
1. Overwrite mode: The data which we are pushing in the RDS has one column with characters > 255. In Overwrite mode the SharePoint list which is created changes the multi-line text field to a single line of text as data type and the rows which are greater than 255 characters get dropped.
2. Append mode:  We have been able to push a maximum of 500 rows but the append load fails at row counts > 500. 
3. Update mode: The column with characters > 255 is not updated properly and only 100 records are populated at a time.
4. Upsert mode: Upsert is creating duplicate records in case of any update instead of overwriting the data. The same record is duplicated twice in the SharePoint list.

Could someone please help identify the source of these issues and if we have a solution to them? Is there a way to write loops in Alteryx where we can push data in batches of 100 or so?

Thank you so much for all your help.

JoeUserName · Answer

Can you provide a masked version of your alteryx workflow?

I am having some difficulty in writing data into a Sharepoint List using AYX. I have tried both AYX Sharepoint Tool Connector version 2.4 and 2.3. The Sharepoint Tool appears to be writing to Sharepoint but when I refresh Sharepoint, no data is actually updated whether I use append, overwirte, update, or upsert.

I believe some of your issues should be fixed by Sharepoint Connector 2.4.1 version.