Hi,
I am using an Alteryx 2020 version and I am trying to upload data to SP list (version 2007) which has People/Group data type.
I currently get the error "0x80020005 - The operation failed because an unexpected error occured".
I have come to the conclusion that it is happening only because my Alteryx is trying to upload an email ID into the People/Group column (however SharePoint is not accepting this)
Any workaround for this? I really would like to maintain the SP list column as People/Group and not change it to a Single Line Text.
Interestingly, when I use the SP list Input to see how the People/Group data looks inside Alteryx, I get it as : random number;#Name (eg, 408;#Red,Veena)
SO not able to figure how to get my Mail IDs/Name into a format that is acceptable for SharePoint People/Group Data type.
(The SP column settings are : Require that column contains info: No; Enforce unique values: No;Allow multiple selections: No; Allow Selection of: People Only; Choose from: All Users;)
Very much appreciate any help on this. Thanks
