How Do I Update a Multi-Select People Column in Power Automate?

Update item error message: Open Api Operation Parameter Validation Failed.

Hello, I’m attempting to update multiple users (placing emphasis on the plural) using the SharePoint “Update item” action. However, I’m uncertain about the correct value format to input. As far as I’m aware, an Array is necessary, and that’s what I’ve currently implemented:

[
{
“email”: “XXXXXXXXXXXXX”,
“claims”: “updated claim value for user 1”
},
{
“email”: “XXXXXXXXXXXXX”,
“claims”: “updated claim value for user 2”
},
{
“email”: “XXXXXXXXXXXXX”,
“claims”: “updated claim value for user 3”
}
]

But I get the error: Open Api Operation Parameter Validation Failed. Where am I going wrong?


To update a multi-select people column in Power Automate, you can use the SharePoint “Update item” action. In the “Update item” action, you need to provide the values for the multi-select people column in the correct format.

The multi-select people column stores its values as an array of user objects. Here is an example of how you can format the array and use that array in the “Update item” action:

USAGE:
[
  {
    "Claims": "<userPrincipalName #1>"
  },
  {
    "Claims": "<userPrincipalName #2>"
  },
  {
    "Claims": "<userPrincipalName #3>"
  }
]

The userPrincipalName (UPN) of the person is usually the same as the person’s email address.

EXAMPLE:
[
  {
    "Claims": "JohannaL@onmicrosoft.com"
  },
  {
    "Claims": "HenriettaM@onmicrosoft.com"
  },
  {
    "Claims": "DiegoS@onmicrosoft.com"
  }
]

Here is an example of the flow:

To update a multi-select columns with a multiple persons the array is formatted as an array of JSON objects containing one or more items (Claims)
Create item action using an array for the Added By column

With the correct array format the “Update item” action can easily update the values in a SharePoint multi-select people column. To learn more see: 🚹SharePoint People Column : How to Update and Patch in Power Automate and Power Apps .

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Website Built with WordPress.com.

Up ↑

%d bloggers like this: