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!
@qlikvw2019 hey I built an iterative macro that will run each row individually into sharepoint to help mitigate this error,
You'll have to manually type in the list name in the interface tool, and then I use a join that will make the macro iterate until it sees that what you are trying to write exists in the list (I did set max iterations to 5). hope it helps
Thought I would post this out there, sort of a rampling post of information on SharePoint outputs.
The Name issue, which was previously mentioned, is a big one if you are pushing data into a SP column that is "Person or Groups" and I've had to change data to get it to fit. It must be an exact match to work.
Also, make sure you have edit capabilities to the list in SP, and along with that is if running with a separate batch ID, you need to make that batchID a "member" of the page with edit capabilities.
The Alteryx error doesnt lead you in that direction (or any direction for that matter, haha), but the above mentioneed items are definitely ones that I have come across in dealing with the SP Output tool.
PS - I still get random "time-out" errors, but I minimize the impact by running the workflow often and limiting the # of rows I am pushing out at any given time.
A bit more information on how I do that:
I populate Calendars with data from WorkDay, so what I have ended up doing is creating a number of smaller calendars and using the "Calendars In View" to layer them together.
Hopefully even a piece of this is helpful to at least 1 person out there. 🙂
Kmaclean, thank you so much for your solution! After many hair pulling hours this worked for me. I tried switching to 2007- and even though that worked in some cases it doesn't work for uploading "People or Group" fields.
Note to anyone else trying KMacleans macro, you need to change the join tool to your individual unique key