Skip to main content

Notifications

Announcements

Welcome to the Power Platform Communities
Check out the New Agent Creator Community
News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate - Building Flows / Update a Sharepoint Mu...
Power Automate - Building Flows
Suggested answer

Update a Sharepoint Multi-Select People Column using Power Automate

(2) ShareShare
ReportReport
Posted on by CU11101146-0 6
Hello,
 
I have a Sharepoint List and I want to upload the data that is in a Excel table. 
The excel table has a column that contain emails of users, and I can't load those emails to a Multi-select People column in the sharepoint list.
The emails in the Excel column are separeted by ";".
 
Here is the flow that I have right now:
 
 
Categories:
Business Process Flows
  • Ellis Karim Profile Picture
    Ellis Karim 11,049 Super User 2025 Season 1 on at
    Update a Sharepoint Multi-Select People Column using Power Automate
    Please share more of the flow, the column names in the Excel file and some sample data.
     
    Ellis
  • CU11101146-0 Profile Picture
    CU11101146-0 6 on at
    Update a Sharepoint Multi-Select People Column using Power Automate
    @Ekarim
     
    The emails are in an excel file that are stored in a sharepoint. 
    Can you help me to design the workflow?
  • Suggested answer
    Ellis Karim Profile Picture
    Ellis Karim 11,049 Super User 2025 Season 1 on at
    Update a Sharepoint Multi-Select People Column using Power Automate
    You will need to format the data for the claims like this:
     
    [
  {
    "Claims": "JohannaL@onmicrosoft.com"
  },
  {
    "Claims": "HenriettaM@onmicrosoft.com"
  },
  {
    "Claims": "DiegoS@onmicrosoft.com"
  }
]
     
    Then use the output of the Select action for the Claim value. Make sure you switch mode to input entire array:
     
     
     
    Ellis

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

News and Announcements

Welcome to the Power Platform Communities
Check out the New Agent Creator Community

Quick Links

Michael Gernaey – Community Spotlight

We are honored to recognize Michael Gernaey as our June 2025 Community…

Congratulations to the May Top 10 Community Leaders!

These are the community rock stars!

Announcing the Engage with the Community forum!

This forum is your space to connect, share, and grow!

Leaderboard >

Last month Overall leaderboard

Featured topics

Start and wait for an approval action

Product updates

Microsoft Power Platform Community release plans