How to update Multi Choice Value to SharePoint List Item

Efficient way to update a multi choice column value in SharePoint List Item using Power Automate

SharePoint Online uses the Lists and Libraries to store the collection of data and documents respectively.¬† Each row in both is considered as a List Item and each List Item consists of collection of fields / columns. In this blog,¬†We’ll see how to update the Multiple Choice Column value in SharePoint List Item using Power Automate.

REST API Syntax

Method: Post
https://<tenant>.sharepoint.com/sites/<site_name>/_api/web/lists/getbytitle('<list_title>')/
items(<item_id>)/validateUpdateListItem()

Let’s create a Power Automate¬† and add the “Send an HTTP request to SharePoint” action and input the details below,

Action Inputs

Site Address SharePoint Site Collection URL
I have added an environment variable
Method POST
Uri _api/web/lists/getbytitle(‘<list_title>’)/items(<item_id>)/validateUpdateListItem()
Headers Accept: application/json;odata=verbose
Content-Type: application/json;odata=verbose
Body
{
  "formValues": [
    {
      "FieldName": "ChoiceColumn",
      "FieldValue": ";#Choice 1;#Choice 2;#"
    }
  ]
}

In the Field Value, use the syntax ;#<choice_value1>;#<choice_value2>;#
Always the value is surrounded with ;#

Power Automate Action

Update Multiple Choice Field Value

Response Body

After the successful update, Flow returns the following output in response,

 

{
  "d": {
    "ValidateUpdateListItem": {
      "__metadata": {
        "type": "Collection(SP.ListItemFormUpdateValue)"
      },
      "results": [
        {
          "ErrorCode": 0,
          "ErrorMessage": null,
          "FieldName": "ChoiceColumn",
          "FieldValue": ";#Choice 1;#Choice 2;#",
          "HasException": false,
          "ItemId": 2
        }
      ]
    }
  }
}

 

 

Shantha Kumar
Shantha Kumar
Articles: 296