Archiving multiple select values with an array

[Dro640]

Hello, 

I am trying to create a recurring flow that copies values from one Sharepoint list to another. The original sharepoint list has a multi-choice column and I can't figure out how to move the data from that column to the new list. 

I have initialized an array variable, appended to the array variable, and created the item in the new list. However, when the entry is created in the new list, the new item has values from multiple items. The top count is limited to 5 items and all 5 values are in one sharepoint item. Any help would be appreciated. 

[Rhiassuring]

Hi there, 

You're on the right path, but I think your Apply To Eaches might be getting jumbled.

Does this help..? :

(In my example, "Positions" are my Multi-Choice)

[v-jefferni · Accepted solution]

Hi @Dro640 ,

It will be much easier to use a Select action to process on a multiple Choices column value.

Best regards,

[Dro640]

Thank you for your response but I am still having the issue. I think it may have something to do with my sharepoint list. When I look at each instance of the append to array, I see a single value but when I look at the create item I still see all the values added to one item 

[Dro640]

Thanks for your help but I think the issue might be with my sharepoint list. When I look at each apply to each for the select it shows that there is only one value but when I add the create item it appends all values to one sharepoint list item. 

[v-jefferni]

Hi @Dro640 ,

I don't understand the situation. Could you please share your entire flow in edit mode with some screenshots? Do you have "append to array variable" now? 

Best regards,

[Dro640]

I was able to get this to work today using the select method you outlined. I don't think I did anything different than what you outlined above but it's working now. Thanks.