How to Update a Specific SharePoint List Item Using UiPath?

Help Activities
,
1

Hi everyone,

@loginerror

I’m able to read data from a SharePoint List and add new items successfully using UiPath. However, I’m struggling to update an existing record.

The Update List Item activity requires the List Item ID, but I’m unable to figure out how to retrieve that ID for a specific record.

image
image283×261 19.2 KB

Could anyone please help me with the following?

  • How can I retrieve the SharePoint List Item ID for an existing record?

  • What is the recommended approach to update specific columns for that record?

  • Is there a way to get the Item ID using a filter (e.g., based on a unique column value) before performing the update?

Any guidance or example workflow would be greatly appreciated.

Thanks in advance!

2

@Mahendra_T

Use get list item whcih gives the ID

cheers

3

Hi @Mahendra_T ,
To update a SharePoint list item in UiPath, first use Get List Items with a filter on a unique column (e.g., PO Number, Request ID, or Email). The output will contain the matching record along with its ID field.

Extract the ID from the returned item and pass it to the Update List Item activity’s List Item ID property.

Then create a Dictionary(Of String, Object) containing only the columns you want to update and provide it in the Data row field.

Flow: Get List Items (with filter) → Retrieve Item ID → Update List Item using that ID.

This is the recommended approach when you need to update a specific SharePoint record based on a unique column value.

4

Hi @Mahendra_T,

You can try this approach.

  1. Use the “Get List Items” activity and set the Filter Query field with an OData-style filter based on your unique column, e.g.:
    “Title eq ‘PO12345’” or “PONumber eq ‘PO12345’”.
  2. This returns a DataTable. The Id column in that table is your List Item ID.
  3. Extract it through dtResult.Rows(0)(“Id”).ToString and use it in your Update List Item activity.

Cheers!

5

Hi @Mahendra_T

Yes, you can update a specific SharePoint List item by first retrieving its Item ID based on a unique column value.

A common approach is:

  1. Use Get List Items to retrieve the SharePoint list records.

  2. Apply a filter using your unique column/value, either through the activity’s filter options or by filtering the returned DataTable.

  3. Read the ID column from the matching item.

  4. Pass that ID to the Update List Item activity.

  5. Specify only the columns/fields that you want to update.

For example, if EmployeeID is unique:

Get List Items → Filter EmployeeID → Get ID → Update List Item

You can also use the SharePoint/Graph API approach if you need more advanced filtering or performance with large lists.

Make sure you use the SharePoint Item ID (the system-generated numeric ID), not another business key such as EmployeeID.

Hope this helps! :+1: