SharePoint Output Tool Error

[aimzy72]

Good morning Super Stars! 

I need a little help! I know the answer is right in front of me but I can't quite riddle it out. I am trying to upload an Excel sheet to an existing SharePoint list. I've uploaded to this site before without an issue but now I'm getting an error that i just can't shake. 

I am sorry, I can't include screen shots because big brother won't let me. The error says, "An error occurred while writing record. Record was partially written. Check List in SharePoint." I've seen various numbers. This morning it's 129 and 127. There are no blank fields or rows in my data that I can see. No weird characters. My SharePoint doesn't have any drop down fields that mismatch what I'm trying to input. Like I said, I've done it before. 

This looks like some sort of data integrity error (from my extensive Googling.) I've adjusted the data times to and from String, V-String, V-W String, etc. and it doesn't work. The field names from the source document are the same as the SharePoint. They appear to be formatted the same and in the same order. 

I just can't figure it out but I know you are all going to point out something so simple, I'm going to face palm. 

Help me Alteryx Community you're my only hope!

[Brando · Accepted solution]

Hey @aimzy72,

Interesting error you've found, it sounds like something my team faced a few months ago (and are still facing). We developed a pipeline to move around, upload, delete, and do other things with SharePoint and for most occurrences, the pipeline worked as expected. However; there was always a small batch of errors that we recently discovered was attributed to the special characters in the names of the files being uploaded to SharePoint. 

SharePoint creates a unique id and url based name for every item and for most special characters, SharePoint automagically converts them into underlines or compatible values. This is tough because now the new names and the old names don't match. I'd mess around with some Regex to change the ones that are failing.

I hope that's helpful,

 - Brandon Shuey

[aimzy72]

That did it! Helped me find the data that was giving me trouble!!!

Thank you1