Problem Statement: When updating a multiple-person or group field in Power Automate, it often causes issues. Instead of updating all the people in the field, it creates multiple records—one for each person—resulting in duplicates or incomplete updates.
Solution: To effectively update a multiple-person field in Power Automate, we start by creating a simple array variable to store the emails of the persons to be updated. Next, we use the “Select” action to transform this array into the correct Claims format required by SharePoint. This formatted variable is then used when updating or creating the SharePoint item, ensuring smooth and accurate updates. Lets see in detail.
Step 1 :
Suppose you are retrieving emails or claims from a field using a “Get Item” action.
Step 2 :
Use the “Append to array variable” action (assuming you’ve already created an array variable) to add the emails from the person/group field. This will create an array of emails that we can use in the next step to generate the Claims.
When using the “Append to variable” action for a multiple-person field, it automatically runs in a loop. This is fine because we only need the final result stored in the variable.
The output of the variable will be a collection of emails:
[
"johndoe@truerows.com",
"vijaya@truerows.com"
]Step 3 :
Let’s use the Select action to transform the array of emails into a new array with the Claims format required by SharePoint. This formatted array will be used to update the item seamlessly.
In the “From” field of the Select action, use the array variable containing the emails. For the Key (left side), enter the text "Claims". On the right side (Value), use the expression item().
The output would be something like below:
[
{
"Claims": "johndoe@truerows.com"
},
{
"Claims": "vijaya@truerows.com"
}
]Now, we will use the output from the Select action as the value for the person/group field.
This will update the multiple-person group field without any errors. It ensures that all entries are formatted correctly in the Claims structure required by SharePoint.
If you need any assistance on this, please email me vijaya@truerows.com