Use Power Automate to copy multiple selections from Choice columns between Microsoft Lists

In this blog post I will show how to copy multiple selected Choice column values to another list. 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 choice column called “Choice” that allows multiple selections.

Choice column with allow multiple selections

Create a new Flow from the Source list > 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”.

When an item is created

Insert a new “Initialize variable” step. Set Name to “varChoice” and Type to “Array”.

Insert a new “Append to array variable” step. Set Name to “varChoice” and Vale to:

{
"Value": "@{items('Apply_to_each')?['Value']}"
}

“Choice” will cause the “Append to array variable” to be contained in a “Apply to each” loop.

Append to array variable

Insert a new SharePoint “Create item” step. Set Site Address to your target site and destination list. Set Title to “Title” and Choice to “varChoice”.

SharePoint create item

My completed Flow looks like the image below:

Completed FLow

Test by creating a new entry in the “Source” list with multiple selections in the “Choice” column.

Test item

The “Append to array variable” step will create the following string:

{    "Value": "Choice 1"  },  {    "Value": "Choice 2"  },  {    "Value": "Choice 3"  }

Microsoft Lists will interpret these values as valid choice selections.

Destination item

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