How to create or update multi-select person, group, and choice fields in a Microsft SharePoint List using Microsoft Power Automate (Flow).
A quick guide on how to handle multi-select person, groups, and choice fields in a Flow.
1. Initial Situation
Let’s say we have two Microsoft SharePoint lists with a multi-select person and a multiple-choice column each.
In this example, we want to copy values from List A to List B.
List A has the following data:
List B has no data yet:
Now, let’s see how we can get the data from List A and create the rows in List B.
2. Trigger the flow and get the data from List A
But first things first… for our example, we need to trigger the flow and get all values from List A using the Get items action.
3. Using the Select action, copy a multiple person or multiple choice column.
To create or update a multiple-person, group, or multi-select choice column in a Microsoft SharePoint list, you’ll need to use the Select action.
Add an Apply to each action and loop through all rows from List A using the dynamic content value from the Get items action.
Inside the loop, add two Select actions.
In the From field of the first Select action, insert the dynamic content People.
In the Map section of the first Select action, write Claims inside the key field and the expression item()?[‘Claims’] inside the value field.
In the From field of the second Select action, insert the dynamic content Devices.
In the Map section of the second Select action, write value inside the key field and the expression item()?[‘Value’] inside the value field.
4. Update the Microsoft SharePoint List B
All we now have to do is simply add a Create item action to create the items in List B.
In the People and Devices column, click on the icon on the right side of the field to change the input to an entire array.
Then select the dynamic content Output from the Select actions. Make sure you select the right dynamic content for the right field… (People / Devices)
Let’s test the Flow and check if it worked.
As you can see, all the data from List A is now inside List B.