web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Automate Update a Sharepoint Mu...

Power Automate

Suggested Answer

Update a Sharepoint Multi-Select People Column using Power Automate

(2) Share

Report

Report

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:

I have the same question (0)

All responses Img

All responses (3)

Answers Img

Answers (0)

Suggested answer

Ellis Karim 11,683 Super User 2025 Season 2 on at

Like (2)

Report
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

Ellis Karim's Blog – IT doesn't have to be complicated!

Was this reply helpful? Yes No
CU11101146-0 6 on at

Like (0)

Report

@Ekarim

The emails are in an excel file that are stored in a sharepoint.

Can you help me to design the workflow?

Was this reply helpful? Yes No
Ellis Karim 11,683 Super User 2025 Season 2 on at

Like (0)

Report

Please share more of the flow, the column names in the Excel file and some sample data.

Ellis

Ellis Karim's Blog – IT doesn't have to be complicated!

Was this reply helpful? Yes No

Join the conversation