How to use update sharepoint list

[MD_Farhan1 (MD Farhan)]

i want to update SharePoint list status value as completed inside foreach data table. once update per row data just update status like completed

[arjun.shiroya]

Hi @MD_Farhan1,

Install UiPath.MicrosoftOffice365.Activities package.

SharePoint Scope (your site)
├── For Each Row in DataTable (your DT with ID column)
└── Update List Item
    ├── List: "YourListName"
    ├── ListItem: row("ID").ToString
    └── Values: New Dictionary(Of String, Object) From {{"Status", "Completed"}}

updates 1 row per iteration. Use exact internal column name for “Status”. Test first!

[MD_Farhan1 (MD Farhan)]

@arjun.shiroya

ew Dictionary(Of String, Object) From {{"Status", "Completed"}}

Hi Arjun if possible to send image with activity.

[Anil_G (Anil Gorthi)]

@MD_Farhan1

Please check here for detailed steps

Update Sharepoint list column using column name with Office 365

@Sreelatha278 For that you can get the required index by using a for loop on the retrieved values Listitem.fields And then use if condition to check the fieldname currentitem.DisplayName.Equals("Requiredname") And on then side use the assign as needed Or you can directly use this in assign ListItem.Fields.Where(function(x) x.DisplayName.Equals("Display Name of Field"))(0).Value = "Value to be updated" instead of displayname use name if you want to use the backend names of the fields Chee…

Cheers

[Monali_Vekariya (Mona)]

Hi @MD_Farhan1

Inside the For Each row loop, use Update List Item with the row’s ID and set the Status field to “Completed” so each row updates the corresponding SharePoint item.