Let's POWER Automate

From no-code to low-code

Menu
  • Expressions
  • Filters
  • General
  • Application specific solutions
    • Dataverse
    • Excel
    • Forms
    • Outlook
    • Planner
    • Power Apps
    • SharePoint
    • Teams
  • Triggers
  • Ready to use solutions
    • Approval Process Template
    • Task Delegation App
    • The Ultimate Power Automate expressions cheat sheet
    • Power Automate HTTP requests to SharePoint cheat sheet
    • Power Automate HTTP requests to Graph API cheat sheet
  • ABOUT ME
  • Get help with your flow
  • POWER PLATFORM SERVICES
Menu

How to update multiple people or group column in Power Automate

Posted on November 18, 2020May 23, 2021 by Tom

“I want to update a multi-selection people picker field with the results of a different SharePoint list using Power Automate.”


‘Person or Group’ SharePoint column is one of the complicated ones to update using Power automate. When it’s just one user, it works fine. But once you try to update multiple people, it gets more complicated. You can’t use simply the dynamic from another item, or list of email addresses of the users either. The ‘Update item’ action requires an array with email addresses in the following format.

[
   { "Claims": "user1@company.com" },
   { "Claims": "user2@company.com" }
]

It’s just one of the user properties available, so how to extract it?

‘Select’ action

The easiest way is to use ‘Select’ action. This action expects an array, e.g. the dynamic content with multiple users. By default, the dynamic content contains multiple users with multiple properties. You can see an example below.

[
    {
        "@odata.type": "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedUser",
        "Claims": "i:0#.f|membership|user1@company.com",
        "DisplayName": "User One",
        "Email": "user1@company.com",
        "Picture": "https://..."
    },
    {
        "@odata.type": "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedUser",
        "Claims": "i:0#.f|membership|user2@company.com",
        "DisplayName": "User Two",
        "Email": "user2@company.com",
        "Picture": "https://..."
    }
],

Using the ‘Select’ action, you can select only the properties you need and skip the rest. Here you’re interested only in the ‘Claims’ property. You’ll tell the action: “take the whole array of ‘Approvers’, and select only ‘Approver email’ for each of them. And map the property to ‘Claims’ key”. Output of the action can be then used to update the column.

Power Automate update multiple people picker column

Update: if you’d like to update only one, person or group column, you can do that with an HTTP request.

Summary

Taking users from multiple people picker column is the easy way to update another multiple people picker. You already got all the data you need in an array, you just need to reduce it. Keep only the email with proper key, and that’s it.

It’s one of the basic functionalities when building approval processes based on configuration lists, updating users for scheduled task reminders, or just keeping lists synchronized.


πŸš€ Master Power Automate

Join 2,000+ professionals getting actionable Power Automate tutorials, solutions, cheat sheets & tips every week.

No spam. Unsubscribe anytime.

12 thoughts on “How to update multiple people or group column in Power Automate”

  1. Karen Cuenco says:
    July 29, 2021 at 7:55 am

    Thank you!!!!

    Reply
  2. Jameel says:
    December 14, 2021 at 12:45 am

    I’ve checked multiple sites for this and your method is BY FAR the easiest and cleanest. Just Select. Others try to loop and add to arrays and then use select on those arrays. Here its much easier just to use what Power Automate already provides. Well done.

    Reply
  3. Becca L says:
    January 28, 2022 at 10:43 pm

    This is great when you want to update a list, but I need a solution to update a file property that is a people or group column for the approvers that a create an approval went to. Any ideas?

    Reply
    1. Tom says:
      January 29, 2022 at 7:28 pm

      Hello Becca,
      it doesn’t matter if it’s a SharePoint list or a document library, the update is the same, it just uses a different action: Update item vs. Update file properties.

      Reply
  4. Andy says:
    February 3, 2022 at 8:07 pm

    Thank you !!
    This post gave the inspiration to solve a big problem

    Kisses

    Andy

    Reply
  5. S.P. says:
    July 8, 2022 at 2:27 pm

    Thank you very much indeed Tom for your help. Your advice helped me fix my problem – How to collect multiple email addresses on MS Form and Update SharePoint List via Power Automate?

    With the very best wishes…

    Reply
  6. Eric says:
    July 18, 2023 at 4:23 am

    I have 10 single-person People columns that I want to combine into one mulitple-person People column. The trigger should be if any one of the 10 source columns get updated. I see lots of search results on how to use Select with multi-person columns, but Select returns an error if used with a single-person column. How would I go about doing the combining of the single-person columns?

    Thanks.

    Reply
    1. Tom says:
      August 13, 2023 at 8:55 pm

      Hello Eric,
      you can’t use ‘Select’ on a single people picker column, you’ll have to manually build the array of objects using the columns one by one, e.g. in a ‘Compose action’:
      [
      { “Claims”: “column1 email” },
      { “Claims”: “column2 email” },
      …
      { “Claims”: “column10 email” }
      ]

      Reply
  7. Emma Stewart says:
    August 21, 2023 at 10:48 am

    Hi! thanks so much for this, your tutorials are so good, even for beginners like me!

    Just a QUICK QUESTION – Is this whole thing wrapped in an apply to each, or are the step standalone? Just trying to get an invoice approvals sorted, Any help appreciated πŸ™‚

    Thanks

    Reply
    1. Tom says:
      September 7, 2023 at 12:26 pm

      Hello Emma,
      it’s a standalone action – 1 item -> Select -> Update item. The only situation when it should be inside ‘Apply to each’ is if you’re processing multiple items at once – 2+ items -> Apply to each -> (Select -> Update item)

      Reply
  8. Nithya says:
    August 1, 2024 at 8:12 am

    Assume I have an array of objects like :

    Testdata : [
    { name : A , ID : 1} ,
    {name : B , ID : 2},
    {name : C , ID : 3} .
    ]

    I want na output to be column : 1,2,3 (only the id part)

    Reply
  9. rajiv says:
    September 12, 2024 at 2:02 pm

    getting error
    “The specified user [{“Claims”:”i:0#.XXXX”}] could not be found.

    Reply

Leave a Reply Cancel reply

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

πŸš€ Master Power Automate

Join 2,000+ professionals getting actionable Power Automate tutorials, solutions, cheat sheets & tips every week.

No spam. Unsubscribe anytime.

Working on an Approval process?

Use the Approval Process Template and the Task Delegation App to skip the hard part and deploy a fully functional approval solution on a SharePoint list in minutes! And then the next one, and the next one...

Approval Template Preview ✨ Learn more ✨

Turn ideas into flows with ease!

Grab the complete Power Automate Cheat Sheet Bundleβ€”everything you need to master expressions, SharePoint HTTP calls, and Graph API in Power Automate.

Cheat Sheet Bundle Preview ✨ Get the Cheat Sheets

Didn't find what you were looking for?
Need to adjust a solution to fit your needs?
Or would you just like to get an assistance from somebody with thousands of hours of experience with Power Automate?

Power Automate blogs worth visiting

Damien Bird
Dennis (Expiscornovus)
Paul Murana

©2025 Let's POWER Automate | Theme by SuperbThemes