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!
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?
After spending about 2 days debugging i was able to resolve this error. In my case i am moving large multiline text data, even thought the column option was set to multiline it was randomly crashing with this same error, i was able to fix it by changing the following option in SP for the column
Yes, most of the time it is a data type error. My last error was due to columns getting shifted in tab delimited file. Moving to pipe delimited after this error. A text value was shifted to a numeric column, throwing the error.