PnPJS update items - List data validation failed

Question

We loaded a SP list directly from an Access query and now when we try to run a list update with pnpjs I get an "Error code: -2130575163.List data validation failed" .

There are no required fields, no validation on any columns, and no Validation settings on the list. Is this not working because it was uploaded from Access?

Updating it similar to this:

const items = await sp.web.lists.getByTitle("MyList").items.top(1).filter("Title eq 'A Title'").get();

const updatedItem = await sp.web.lists.getByTitle("MyList").items.getById(items[0].Id).update({
    my_id: mynewID,
})

Adding list items works with no issues. Updating a list item does not work.

Is there any update ? Did you resolve the issue in your side ? If the reply is helpful to this question, you could accept as answer so that it could help others in the forum. — Jerry, Jul 17 '20 at 09:11

score 0 · Answer 1 · answered Jul 03 '20 at 23:39

0

Try this.


let list = sp.web.lists.getByTitle("MyList");

const i = await list.items.getById(1).update({
  Title: "My New Title",
  Description: "Here is a new description"
});

console.log(i);

answered Jul 03 '20 at 23:39

spgk

5
4

score 0 · Answer 2 · answered Jul 07 '20 at 09:35

Is items[0].Id valid ? Please try to use console.log (items[0].Id) to check in Developer Tool. I tested the same request in my side, my_id is a number field:

  const items = await sp.web.lists.getByTitle("JqueryList").items.top(1).filter("Title eq 'My New Title'").get();
    console.log(items);
    let list = sp.web.lists.getByTitle("JqueryList");

    const i = await list.items.getById(items[0].Id).update({
      Title: "My New Title",
      my_id: 1
    });

score 0 · Accepted Answer · answered Jul 29 '20 at 19:11

I did resolve it - when you use the StrReverse function in Access and then upload that query to a SP list - the list type is corrupted. To fix it I simply went in and changed the type from single line text to multiline - then back to single line of text.

I was then able to update the list item.

PnPJS update items - List data validation failed

3 Answers3