Update SharePoint group in the Person or group column (Power Automate)

“I’m able to update a specific user or M365 group in the Person or Group column with Power Automate, but how can I update a SharePoint group?”


When you need to update the SharePoint Person or Group column, it’s all about the format. What format should the user have? What format is needed to update a Microsoft 365 group? And what about a SharePoint group? The user and M365 group was already covered in a previous post. This post is about the third option, a SharePoint group.

HTTP request to update the column

As in the previous post, one option is to use an HTTP request to update the people picker column. It’s a preferred option if you want to update only that one column.

Method: POST

Uri: _api/web/lists/GetByTitle('<ListName>')/items(<ItemID>)/validateUpdateListItem

Body:
{
    "formValues":[
	{
	    "FieldName": "<FieldToUpdate>",
	    "FieldValue": "<ValueToUpdate>"
	}
    ]
}

Note: < … > are placeholders, replace them including the < and >.

The difference will be again only in the ‘FieldValue’ part. When updating a user or Microsoft 365 group, you use their claims login. For SharePoint group it’s much easier. You must still use the same format…

"FieldValue": "[{'Key':'claims'}]"

… but instead of the claims login you need only the SharePoint group name(s), e.g.

"FieldValue": "[{'Key':'Playground Members'}]"

or

"FieldValue": "[{'Key':'Playground Members'}, {'Key':'Playground Owners'}]"
SharePoint group column update Power Automate

Such HTTP request will update two SharePoint groups, ‘Playground Members’ and ‘Playground Owners’, in the people picker column.

‘Update…’ action to update the column

If there’re more columns you want to update at the same time, the second option is to use the standard ‘Update…’ action. Again, it’s the same approach as when updating users in that field, only the value changes. Instead of the user email addresses, use the group name(s).

SharePoint group column update Power Automate

Summary

To update the SharePoint Person or Group column with Power Automate, you must know the right value. Which is very simple when working with SharePoint group – just use the group name in the right format. Only the group name if it’s a single people picker column, or an array of groups for multiple people picker.


Do you struggle with the various expressions, conditions, filters, or HTTP requests available in Power Automate?

I send one email per week with a summary of the new solutions, designed to help even non IT people to automate some of their repetitive tasks.

All subscribers have also access to resources like a SharePoint Filter Query cheat sheet or Date expressions cheat sheet.

Zero spam, unsubscribe anytime.

Add a Comment

Your email address will not be published. Required fields are marked *