
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:


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