Sharepoint List Output : Input String was not in a correct format

Question

I am trying to load records from teradata to a Share point List.

Getting the below error. Tried making all the fields V_WString(forced). Still not working.

Error: SharePoint List Output (21): Error while adding records: Input string was not in a correct format.

Please help.

kgordish · Answer

@Pinaki Sometimes if you have renamed Title Column to a custom name in SharePoint in Alteryx rename back to Title and solves upload problem.

Don't understand why, but worked for me.

jaltes · Answer

Just in case someone else is looking for this answer.  You can write to a SharePoint lookup field by formatting the data as RecordID;#LookupName.  ie for my scenario I wrote 3;#Categories to the lookup field.

Pinaki · Answer

There were lookup columns which were posing the issue.

Once I made all the sharepoint target columns as text, it worked.