We are celebrating the 10-year anniversary of the Alteryx Community! Learn more and join in on the fun here.
Start Free Trial

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
fireworks
SOLVED

Updating a list errors out

Yuri24
8 - Asteroid

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

2 REPLIES 2
Yuri24
8 - Asteroid

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.

JPSeagull
8 - Asteroid

Thanks for solving this....I had the same issue and drove me crazy trying to resolve it. As it turns, I too used a Join that occasionally had NULLS in the data. I changed my SQL code to enter another value if the data would be null that day. 

 

 

Labels
Top Solution Authors