Skip to content
This repository has been archived by the owner on May 15, 2023. It is now read-only.

UpdateListItems not working #190

Open
kat-hughes opened this issue Jun 15, 2022 · 1 comment
Open

UpdateListItems not working #190

kat-hughes opened this issue Jun 15, 2022 · 1 comment

Comments

@kat-hughes
Copy link

kat-hughes commented Jun 15, 2022

I have a script I've been running for months that uses shareplum to update various columns of a SharePoint List using UpdateListItems(kind = 'Update'). It has suddenly stopped working and I've no idea why. I don't get any error messages but the changes are not showing up. Creating a new item is working fine, it's only when I try to update an existing list item. I use the Office365 version of SharePoint.

It's a relatively large list with over 500 items and over 100 columns. The maximum list item ID is 1051.

I can update the list items of other Lists, so it must be an issue with the List itself. Since I'm not getting any error message I don't know how to check what could be wrong. Any help would be appreciated.

UPDATE: When I print out the results of the response in the update_list_items() function, I get this error message: '0x80070057', 'Bad parameter passed to Web Server Extensions. Check the information you entered and try again.'

@DanielSkalar
Copy link

Hey!
Had the same issue and I found the problem.

In my case the problem was a Lookup column with selected items on the 'Add a column to show each of these additional fields:' option.
This option is available to display on your list columns of another list.
https://techcommunity.microsoft.com/t5/image/serverpage/image-id/329113iF478D0C0EEA0D5DC/image-size/large?v=v2&px=999

I would suggest to do the same that I have done:
Create a new column on your list.
run a script for each item of your list to add a tag on that column.
Check the difference between the rows with and without tag.

Maybe someone can fix the library.

Sign up for free to subscribe to this conversation on GitHub. Already have an account? Sign in.
Labels
None yet
Projects
None yet
Development

No branches or pull requests

2 participants