ALTERYX INSPIRE | Join us this May for for a multi-day virtual analytics + data science experience like no other! Register Now
1 Day Left! - The Alteryx Community will be temporarily unavailable for a few hours due to implementation of the new SSO experience starting tomorrow at 5pm MDT. Please plan accordingly. For more information, read the blog.

Alteryx Designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
SOLVED

Updating a list errors out

Yurr24
7 - Meteor

Hello,

 

I loaded my Sharepoint list with data from a query and it took about an hour to complete. I used "Delete List and Append" option for the sharepoint list output. 

However when I change it to "Update; Error on Update Failure" and trying to update the sharepoint list I am getting the below error.

 

Error: SharePoint List Output: Error while updating records: The 'sId' argument is invalid.

 

There is no sId field that I am using in my data/dataset

Yurr24
7 - Meteor

I figured it out, one of the columns had no data in it while it was being used in a join. That column was no longer needed and another unique int64 column was used to perform the join and it was fixed.

Labels