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.
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”.
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.
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”.
My completed Flow looks like the image below:
Test by creating a new entry in the “Source” list with multiple selections in the “Choice” column.
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.
Thanks for reading.
NY
