Use Power Automate to copy multi-select Person values between Microsoft Lists

In this blog post I will show how to copy multi-select Person values from one list to another. This post is a supplement to: Use Power Automate to move Microsoft Lists items to another list.

I am using two lists called Source and Destination. Both lists have a Person column called “Person” that allows multiple selections.

Person column that allows multiple selections

Create a new Flow from the Source list by clicking Automate > Power Automate > See your Flows > Create new > Automated from blank. Provide a Flow name, i.e., “Source to Destination”, select the SharePoint “When an item is created” trigger and click “Create”.

Automated cloud flow for when an item is created

Set the Site Address and List Name to your source site and list.

When an item is created

Create a new Initialize variable action and set:

  • Name to “varUser”
  • Type to “Array”
Initialize variable varUser

Insert a new Apply to each action and set:

  • Select an output from previous steps to “Person” from the When an item is created action

Add a new Append to array variable action to the Apply to each loop and set:

  • Name to “varUser”
  • Value to: { "Claims": "Person Claims" } where “Person Claims” comes from the When an item is created action
Apply to each and Append to array variable

Insert a new SharePoint – Create item action and set:

  • Set the “Site Address” and “List Name” to your destination site and list.
  • Title to “Title” from the Create item step
  • Person to “varUser”
SharePoint Create item action

My completed Flow looks like the image below.

My completed Flow

Save and test your Flow by creating a new item in the source list with multiple people selected in the Person column. If all goes well your destination list will have the same values including the multi-select users.

Source test item
Destination item

Moving and manipulating data is an important component in many “information” based solutions and as tools like Microsoft Lists and the Power Platform become more widely adopted, citizen developers can use Flow patterns like the described above to reduce their dependence on traditional IT for these activities.

Thanks for reading!

NY

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s