Updated List item : invalid request

Help Activities
, ,
1

Hello Everyone,

can you please anyone help me on this ? I am unable to Update the list item for few Libraries in the same SharePoint.

Error message : Update List Item: Code: invalidRequest
Message: Invalid request
Inner error:
** AdditionalData:**
** date: 2023-07-10T09:12:17**
** request-id: b27d7ef8-886a-4e27-a17c-8df4c9bdfb4c**
** client-request-id: b27d7ef8-886a-4e27-a17c-8df4c9bdfb4c**
ClientRequestId: b27d7ef8-886a-4e27-a17c-8df4c9bdfb4c

with the same code I can able to Update the list items for few Libraries in the same SharePoint site.

image
image596×702 25.4 KB

2

@shruthi_are

Does the value contain a special character in it? if yes then they needs to be urlencoded…please check the data…

also currently update is supported for most of the general datatypes and complex datatypes like multi select etc are not working as of now

cheers

3

Can you please clarify on Special Character. You mean the special characters are in the List URL or Columns data types ?

4

@shruthi_are

Special characters in your data

eg: D’Souza - there is a single literal here in data which might be a problem

cheers

5

No, we are not using any special characters in my data. Even If I am trying to Update a list with out providing any columns, still getting same error

6

@shruthi_are

To know exact error it would be better to see the inner exception details from locals panel when run in debug mode

Also are you able to read the list info properly ?

can you provide more insights on what kind of data you are trying to update

cheers

7

Yes I can able to read the list properly. Please find the more details.

image
image1511×837 97.9 KB

image
image822×734 34.7 KB

8

@shruthi_are

Is there a unique reference on the field?

Also is empid column type number or string?

Can you please verify the datatypes once

Cheers

9

Hi,

There is not Unique reference on the field EMPID

EMPID datatype is string in both SharePoint Columns settings and in the Code.

10

@shruthi_are

And the account your using have rights on that list to update?

Cheers

11

Yes I have full control access to the List

12

@shruthi_are

Just to check can you try updating any other column on the list please

Cheers

13

I have tried it, But I am not able lo Update any columns on the Few Librarys
But with same code I can able to Update all the columns.

14

@shruthi_are

So you mean few lists you are not able to update any column?

And few other lists you are able to update the values?

Cheers

15

Yes, You are correct

16

@shruthi_are

Is it on different sharepoints…or same?

Are you able to add items?

This does not look like the activity error though…any validations on sp list?

Cheers

17

Hello, sorry to interrupt.
I have the same issue in this moment. I need to update only the ‘Status’ column with value ‘In Progress’
The problem appears from another column in the Sharepoint list which is multiple Choice drop down (checkboxes allow multiple selections). Called ‘Departments’
The type of this column is red by UiPath as an Object, which is correct (we may have multiple values in it.). The error appears only if the user selects some values in the column (one or many).
When we call the ‘Update List item’ activity it tries to update the whole line. If the filed Departments is empty it removes the column from the update query and all works just fine.
IS there a way to invoke code to call ‘Update List Item’ only for one column or several columns? For example, the status column (a String) which works just fine.

18

hello, can someone help me on this subject, please ?

20

Hi, I also have the same issue. Have someone solve this problem?