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

View solution in original post

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
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Users online (1,843)