This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
I am trying to import a spreadsheet to a SharePoint List an am getting this error "Error Adding Record #:1 Error: 0x80020005The operation failed because an unexpected error occurred. (Result Code: 0x80020005)". At the last step I also exported the data to a spreadsheet and had our SharePoint person manually load it and it loaded with no issues. A few weeks ago it imported with no problems, the only change I made is that I modified the data to remove a few fields that are not required in SharePoint and I changed the order of a few fields. There are 2 name fields that are SP Lookup fields. Could that be the issue? The Output Options is set at "Delete List and Append".
I'm attaching the packaged workbook and the contents of a sample record that I exported from SharePoint using Alteryx. I'm wondering a couple of things. Could the "Extension #" be an issue for a column name or is it the Lookup fields?
I was able to import into SharePoint using this workflow prior to adding the Extension #, but then I have tested also without and still get this error.
So unfortunately, reading and writing files to SP locations isn't supported with Alteryx. Only the Sharepoint Connector Tools are expected to work consistently. While at times it may work, it may randomly get access denied, and other random error messages like the one you're seeing when trying to read/write to the location. The workaround for this to consistently work is just to sync up the files with OneDrive - https://support.office.com/en-us/article/troubleshoot-mapped-network-drives-that-connect-to-sharepoi...