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?
Solved! Go to Solution.
See my example below and let me know if you have any questions.
You need to use an array to update the choice column. Here is a link to a blog post that shows how.
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.
Is this a choice or a multi-select person or group column?
Multi-Choice
I am off base in my response and am working on a solution which I will post later today....
I really appreciate your support!
Thank you kindly,
Spencer
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.
See my example below and let me know if you have any questions.
Thank you kindly! This worked perfectly! Really appreciate the time you put into helping find a solution.
The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.
Learn to digitize and optimize business processes and connect all your applications to share data in real time.
User | Count |
---|---|
12 | |
9 | |
7 | |
7 | |
7 |
User | Count |
---|---|
19 | |
18 | |
17 | |
10 | |
7 |