cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Specoop
Advocate II
Advocate II

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

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?

1 ACCEPTED SOLUTION

Accepted Solutions

@Specoop 

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

image.pngimage.pngimage.png

 

 

If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.

Scott

View solution in original post

10 REPLIES 10
ScottShearer
Super User
Super User

@Specoop 

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

 

 

If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.

Scott

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
Advocate II
Advocate II

2021-09-27_14-54-59.png

@Specoop 

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

 

 

If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.

Scott
Specoop
Advocate II
Advocate II

Multi-Choice

@Specoop 

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

 

 

If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.

Scott
Specoop
Advocate II
Advocate II

I really appreciate your support! 

 

Thank you kindly,

Spencer

Specoop
Advocate II
Advocate II

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.

@Specoop 

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

image.pngimage.pngimage.png

 

 

If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.

Scott
Specoop
Advocate II
Advocate II

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

Helpful resources

Announcements
Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

May UG Leader Call Carousel 768x460.png

June User Group Leader Call

Join us on June 28 for our monthly User Group leader call!

MPA Virtual Workshop Carousel 768x460.png

Register for a Free Workshop

Learn to digitize and optimize business processes and connect all your applications to share data in real time.

Power Automate Designer Feedback_carousel.jpg

Help make Flow Design easier

Are you new to designing flows? What is your biggest struggle with Power Automate Designer? Help us make it more user friendly!

Users online (1,892)