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
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?
LikeLike
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
LikeLike
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?
LikeLike
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
LikeLike
Hi! This happened to me too. To fix this, make sure to click the “switch to entire array” icon next to the choice field before adding the array to the choice field.
LikeLiked by 1 person
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”?
LikeLike
Hi Bryce,
The Initialize variable, Append to variable steps should be between the Get item and Create item steps.
I hope this helps.
NY
LikeLike
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?
LikeLike
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
LikeLike
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/
LikeLike
Hi David,
That sounds like a great next blog post!
Thanks for reading!
NY
LikeLike
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.
LikeLike
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
LikeLike
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
LikeLike
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
LikeLike