Answered

Creating New List Items with Mutli-choice Values from another Multi-choice list item

(1) Share

Report

Posted on by Community Power Pla...

Hello,

I am attempting to create a flow that will take an item from one sharepoint list and create a new item on another sharepoint list with the same exact information.

HOWEVER, I have a multi-choice column on both sharepoint sites and all I want is the exact information from the first Multi-choice column into the new multi-choice column on the second site.

I have a column on both sites labeled "Months to Activate" Which has each of the months in numbers (01, 02, 03...etc. as well as Monthly and weekly. This is the multi-choice column) What im intending to do is based off another column when it reads inactive to move the list item to the inactive sharepoint site, however, all the information is going over as intended... Just not the Multi-choice columns.

Any help is greatly Appreciated.

Thank you,

Categories:

Building flows

I have the same question (0)

All responses (5)

Answers (1)

tom_riha 10,185 Most Valuable Professional on at

Like (1)

Report
Hello @Anonymous ,

the multiple choice column needs an array in a specific format as an input

[ { "value": "Value1" }, { "value": "Value2" } ]

To create it you can use the 'Select' action and then update it as an "entire array" in the second item.

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

So, grabbing the data with a select as shown, I have the From "MonthstoActivate" and the Map "MonthstoActivate Value"
The only isse is, when going into the create item it won't show in the dynamic content.

Was this reply helpful? Yes No
Verified answer

tom_riha 10,185 Most Valuable Professional on at

Like (1)

Report

Hello @Anonymous ,

you must create an array of objects (the second part of the blog post), not a single array, and the item update must be in the same loop as the 'Select' action.

Was this reply helpful? Yes No
allan_t 310 on at

Like (0)

Report

@tom_riha I have the exact same use case as Anonymous. I've read your blog multiple times, and I can't figure out what I'm doing wrong with the Select connector in this scenario. I can't get it to work.

SharePoint List A contains a choice column with multiple choices permitted. It's not a person column. Column name is ServiceGroup.

I need to copy items from SharePoint List A into List B. I've got everything working, except I can't populate the ServiceGroup column in List B in the Create Item loop. When I try to follow the steps in your blog, Power Automate keeps creating nested Apply to Each loops from the ServiceGroup dynamic content. The Select output does not display in the Dynamic Content pane. I've tried Select with single array, Select with object, neither is working.
Here's example of the nested arrays that keep happening.

Is there a way to populate the ServiceGroup column at time of Create item? Or do I have to Create the item first with all the other values, then go back and update it for this ServiceGroup column?

Was this reply helpful? Yes No
Ally16 9 on at

Like (0)

Report

I'm getting the same problem on mine too--I can't get rid of the for each loops.

EDIT: I found a video that helped understand what was happening - Copy multi-select columns in SharePoint using Power Automate (youtube.com)

Was this reply helpful? Yes No