Tag: multiple-choice

Categories
Guides Microsoft Flow Microsoft List Power Automate Power Platform SharePoint SharePoint List SharePoint On-Premise SharePoint Online

How to copy “multiple people” and “multiple choice” column fields from one SharePoint List to another using a Microsoft Power Automate Cloud Flow in 4 easy steps

Create or update multi-select person, group, and choice fields in a SharePoint List using a Microsoft Power Automate Cloud Flow

A quick and simple guide by Caspar Rubin that is easy to understand and follow.

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 A has multiple users and multiple devices in each row.
The Title column is irrelevant.

List B has no data yet:

List B is empty.

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.

I’ve decided to manually start the Flow. For you, the trigger might be a scheduled event.

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.

item()?['Claims']
Make sure you enter the item()?[‘Claims’] string as an Expression!

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.

item()?['Value']
Make sure you enter the item()?[‘Value’] string as an Expression!

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)

Dynamic content Output People goes into the People column.
Dynamic content Output Devices goes into the Devices column.

5. Check

Let’s test the Flow and check if it worked.

The whole Flow in edit mode.
The Flow ran without any errors.

As you can see, all the data from List A is now inside List B.

How to copy “multiple people” and “multiple choice” column fields from one SharePoint List to another using a Microsoft Power Automate Cloud Flow in 4 easy steps

A quick and simple guide by Caspar Rubin that is easy to understand and follow on how to copy “multiple people” and “multiple choice” column fields from one SharePoint List to another using a Microsoft Power Automate Cloud Flow in 4 easy steps or how to create or update multi-select person, group, and choice fields in a SharePoint List using a Microsoft Power Automate Cloud Flow.