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

15 thoughts on “Use Power Automate to copy multiple selections from Choice columns between Microsoft Lists

  1. how would this look for a form with more than one multiple questions with the same goal of having the flow add and populate an item in the list from the form. Would it be easiest to have a parallel branch with a delay for each choice variable?

    Like

    1. Hi arkoz,

      You would have to duplicate the variable and apply to each section. I don’t think you need a parallel branch.

      Thanks for reading!

      NY

      Like

  2. Is it possible to transfer the data from my column called “Markets” from a multiple choice source list to a column called “Markets” but made of line of text in the destination list? I was told this is the best way if I want to use my flow to be used on another list in a different language (Spanish, French, etc) The process seems to work fine for me if I do multiple choice to multiple choice. But the destination list doesn’t need the same visual display of the information like the Source list. My destination says { “Value”: “Choice 1”}, {“Value”: “Choice 2” }, instead of just Choice 1, Choice 2. Can you help?

    Like

    1. Hi Kerlyne,

      Yes, it is possible using an expression. In my sample code, the column name is “Products”.

      join(xpath(xml(json(concat(‘{“body”:{“value”:’, item()?[‘Products’] , ‘}}’))), ‘/body/value/Value/text()’), ‘, ‘)

      I hope that helps and thanks for reading.

      NY

      Like

  3. Hello Norm, I am trying to create a flow exactly like the one in your article “Use Power Automate to move Microsoft Lists items to another list”. But I also have a choice column in the source list that needs to copy to a choice column in the destination list. However, I’m having trouble with creating the “Append to array variable” discussed in this article. Could you explain in further detail how to integrate the choice variable array into the flow in your article “Use Power Automate to move Microsoft Lists items to another list”?

    Like

    1. Hi Bryce,

      The Initialize variable, Append to variable steps should be between the Get item and Create item steps.

      I hope this helps.

      NY

      Like

  4. I set this flow up and it works great except for that it is copying over all available choices. How can I alter it so it only copies over the selected choices?

    Like

    1. Hi Hannah,

      The array variable needs to be reset after the create item step. I’ll update the blog post to show this. In the meantime, create a new array variable and don’t specify a value. Add a new set variable action after the create item step and set varChoice to the new empty variable.

      Hope that makes sense and thanks for reading!

      NY

      Like

  5. Hi Norm. Thanks for this solution, it worked perfectly for copying a multiple choice where the field values were just words. However, it doesn’t seem to work when it is a multiple choice/value Person field (i.e. AD Account names). Any thoughts on how to copy that kind of value? There doesn’t appear to be a “Contact Value” field available. Thanks/

    Like

      1. Could you please help with this issue? I have searched high and low for an answer and am totally stumped. Trying to set up an archive list to move items to once complete, but one field is a “person” field with multiple entries (for team members)–it just creates separate items on the new list for each name when I run.

        Like

      2. Hi Kate,

        I’ll dig into this one and if it works create a blog post around it. More to follow.

        Thanks for reading!

        NY

        Like

  6. Hi Norm,

    I am using the trigger of this post, but to then put the value of the choice into a word template. So I start with when item is created or modified, on a list on sharepoint, I want it to create a word doc from a template. The only point where I still get an error, is in the fields that I allowed as multiple choice. Do you think it would work, by doing it exactly the same and referencing to varchoice in the field of the word template? Thank you

    Like

    1. Hi Mari,

      I think it could work but the text would include the additional string characters stored in the variable. You should look at concatenating the multiple choices into a single string “Choice 1, Choice 2, Choice 3” using a “Apply to each” loop and “Append to string variable” action.

      I hope that helps.

      NY

      Like

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