SharePoint List Output: An error occurred while writing record. Record was partly written.

[alexnajm]

Hello everyone,

I am trying to upload an excel file with 2086 rows and 118 columns using a SharePoint List Output tool with "Delete List and Append". It is definitely connecting to the SharePoint because all of the data is being deleted. However, it is not uploading a single cell, and this error occurs: "Error: SharePoint List Output (3): An error occurred while writing record. Record was partially written. Check List in SharePoint." Any thoughts on what could be causing this?

We made sure the data types all matched up using a Select tool. We also tried doing the same uploading with only 1 column and 100 rows and the same error occurred. It only didn't occur when we had 1 column and 2 rows of data.

Please let me know if you need any more information, and have a great day!

Best Regards,

Alex

[Serena_A]

Just here to say it is June 2022, 3+ years, after the original post and still no fix as I am experiencing this issue. 

[harvjul]

I have the same issue.  However my list writes out without a problem to one Sharepoint list.  When we tried to migrate to a new site, I am running into the limit issue and getting the error.  Both sites seem to be configured exactly the same as far as we can see.  Are there any updates on this issue?

[shweta00]

For me it happened when one of the column text was too long to fit in single line of text data type in sharepoint list.Once i fixed it, the issue got resolved