Issue keeping Required Choice Field data - Get Items, Append to Array, Apply to Each, Update Items

[Specoop]

Good afternoon community! I've got a situation where I need to update all items in a sharepoint list (daily recurrence) and I am having trouble preserving a required choice (can select multiple) data column.

Get Items

Apply to each (value - outputs('Get_items_-_Main')?[body/value])

Append to array - 

(Maybe Select? to Map the Value?)

Update Item

------

The main issue I'm running into is that I think I'm going to need two "apply to" each one for get items, one for the choice field). I've tried, it's duplicating my choice answers. Any ideas?

[ScottShearer]

@Specoop 

You need to use an array to update the choice column.  Here is a link to a blog post that shows how.

[Specoop]

Really appreciate the quick reply! I used this blog-post and was able to get it work for a single item trigger (e.g. when an item is created, do this). But for Get Items (multiple, I'm ending up with two Apply to Each) and this process didn't work for me.

NOTE: I didn't use "Claims," as I think this is just for People/Groups - I used "Value:" instead. 

[Specoop]

[ScottShearer]

@Specoop 

Is this a choice or a multi-select person or group column?

[Specoop]

Multi-Choice

[ScottShearer]

@Specoop 

I am off base in my response and am working on a solution which I will post later today....

[Specoop]

I really appreciate your support! 

Thank you kindly,

Spencer

[Specoop]

Not sure if this helps, but I just did a test with 3 items in my SharePoint form, each having 1 different Program choice metadata. After running the flow, the first item had one Program choice, the second item had 2 program choices (the 1st items choice and the 2nd item's choice). The 3rd item had all 3 Program choices.

Basically, it seems to be looping through everything (maybe this is because there are two apply to each?). Thanks again for the support.

[ScottShearer · Accepted solution]

@Specoop 

See my example below and let me know if you have any questions.

[Specoop]

Thank you kindly! This worked perfectly! Really appreciate the time you put into helping find a solution.