Choice column copying all values into destination list - Power Automate Flow

[om3r]

I have created the Source list and Destination list and want to copy the Choice column with its values to the destination list. I have created a flow that looks like this:

The flow is running successfully, however, in the destination list it is capturing all the values of the choice column and all the rows. The results look like this:

Can someone please help me why it is happening like this? What am I doing wrong? Is my flow not correct?

Any help would be much appreciated!!

Kind regards,

Omer

[rickdg]

I saw this and thought "Hey I think I know the answer"

When configuring your choice, you have three choices as to what to display to the user. DropDown, Radio boxes, and checkboxes. I'm guessing you picked the checkboxes, because they are a multi-value selection. So, when you use that one the field that is bound to it will create a list of all the selected values from the checkboxes.

[om3r]

This is how my column listing looks:

[om3r]

When I am copying the items from the source list, I have only selected two options out of 4 and when getting copied to the destination list, it should display only the selected options. Rather, in each row, it is displaying the selected options for all the rows and repeats the same for every row

[rickdg]

Turn off the Allow Multiple selections.

[om3r]

I need that column to have the option of multiple-choice selections. Turning it off will not allow that

[Rhiassuring]

Your flow is a bit off. I always recommend naming your labels - it'll help you see where there's cross over. 

Right now what you're telling it to do, based on your flow above, is to loop through every item and append every choice made across all items into a single array. 

Then, in your second loop, you're telling it to the array to every item you create. 

My guess is that you're referencing this blog which is a great one, but it's for a single item creation.

Let's try this instead: 

Step 1 & 2 - You've already done perfectly; Get Items (filtered if need be), and Initialize your array for your multi-choice. 

Step 3 - Create Item. (We're going to do this in a slightly different order, just to get rid of confusion with the Apply to Each.) In your Apply to Each, populate all the non-multi-choice values from the other. Watch it turn into an Apply to Each before your very eyes.

Step 4 - Append to Array. Create it below the Create Item, and then drag the Create Item below it. In your Append to Array action, name is your initialized Array, and then when you choose Value, if you type the word "value" into your dynamic content, you should see "YOURCOLUMNNAME value". Select that. Add the array-stuff around it And - boom - another apply to each automatically appears. This time, in the right spot. 

Step 5 - You can now put your Array into your Create Item (since it's below it!)  

And you might think that's the last step, but, there's one more very important step since you're creating multiple: 

Step 6: CLEAR YOUR ARRAY.  Use a "Set Variable", point it at your arrChoices, and set it to [].

Otherwise, your loop will keep on packing in every choice value through each iteration.

Here's the whole flow: 

[om3r]

@Rhiassuring Thank you for helping me out. I have a few questions about how you created this flow and will share my results by following your inputs.

In your suggestion of Step 3 & Step 4

(Step 3 - Create Item. (We're going to do this in a slightly different order, just to get rid of confusion with the Apply to Each.) In your Apply to Each, populate all the non-multi-choice values from the other. Watch it turn into an Apply to Each before your very eyes.
Step 4 - Append to Array. Create it below the Create Item, and then drag the Create Item below it. In your Append to Array action, name is your initialized Array, and then when you choose Value, if you type the word "value" into your dynamic content, you should see "YOURCOLUMNNAME value". Select that. Add the array-stuff around it And - boom - another apply to each automatically appears. This time, in the right spot. )

This is how my STEP 3 looks when creating it:

-After filling in the Title, it collapsed and I clicked on Create Item again, I filled the box "Select output from previous step" with  "value" from Dynamic content.

Step3_1Step3_2

I couldn't get what you meant by this "In your Apply to Each, populate all the non-multi-choice values from the other. Watch it turn into an Apply to Each before your very eyes."

In STEP 4, I created Append To Array below the Create Item and tried dragging Create Item below Append To Array, however, it didn't let me do that and gave an error.

Step4_1Step4_2 

So I Deleted Create Item from the above, as I deleted it,  - just above the Append to array variable, "Select an output from previous steps" went blank and I filled it in with "value" from Dynamic content.

Step4_4Step4_5

In your Step 4 "Select that. Add the array-stuff around it And - boom - another apply to each automatically appears. This time, in the right spot." - I Didn't get it.

I then proceeded with Steps 5 & 6

Step 5&6

After the flow was created, I tested it out, it ran successfully. However, in the results in the destination list, I didn't get any values for my Choice column.

successful flowresults

This is what the final flow after completion looks like:

Final

Please help me out! I'd highly appreciate your help.

[om3r]

I edited the same flow again, and changed the values in Append to array variable  - In "Select an output from previous steps" I changed it to "RSVP" and in the "Value" to "RSVP Value".

When I first created the flow, I had correct values as you can see from the previous screen shots

Previous SS

However, after the flow ran, it got changed to just "values"

after flow ran

Now in the destination list, the results of each row are summed up and recorded in the first row of the list

Destination List

[om3r]

Can some one please help me on this