cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
New Member

Update item with multiple choice columns

Hi,

 

I have a SharePoint list with an approval flow.

The approval flow is set to inform the right people and all works fine.

The next tweak I would like to make is updating the SharePoint list item when the approval is rejected.

The problem that I'm running in to is with columns that allow multiple choices.

 

I get an apply to each action for all of the columns that potentially have multiple values.

The end result is that for each of the columns, only the last value is retained.

None of the column with multiple choice need to be updated in the first place.

 (I can't get an image of the flow attached)

 

Kind regards,

Wouter

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Community Support
Community Support

Re: Update item with multiple choice columns

Hi @Woutervdv,

 

During the process of Approval request and response, did you ever change the value of multiple choice column?

If you didn't change its value, there is no need to update this column. 

 

If you have changed the value and you want to update this column, you should initialize an Array variable, then use the Apply to each to append each value from the item into the array, after that, put the array into the field of Choice column, please notice the red circle marked:

 

Annotation 2019-12-16 094854.pngAnnotation 2019-12-16 094925.png

 

Best Regards,
Community Support Team _ Lin Tu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

3 REPLIES 3
Highlighted
New Member

Re: Update item with multiple choice columns

approval apply_to_each.png

Highlighted
Community Support
Community Support

Re: Update item with multiple choice columns

Hi @Woutervdv,

 

During the process of Approval request and response, did you ever change the value of multiple choice column?

If you didn't change its value, there is no need to update this column. 

 

If you have changed the value and you want to update this column, you should initialize an Array variable, then use the Apply to each to append each value from the item into the array, after that, put the array into the field of Choice column, please notice the red circle marked:

 

Annotation 2019-12-16 094854.pngAnnotation 2019-12-16 094925.png

 

Best Regards,
Community Support Team _ Lin Tu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

Highlighted
New Member

Re: Update item with multiple choice columns

@v-litu-msft 

Thank you,

I got it to work without the arrey formula. I kept getting a bad gateway error before, but that error seems to have resolved itself.

 

Best regards,

Wouter

Helpful resources

Announcements
Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

Power Platform ISV Studio

Power Platform ISV Studio

ISV Studio is designed to become the go-to Power Platform destination for ISV’s to monitor & manage published applications.

Upcoming Events

Experience what’s next for Power Automate

See the latest Power Automate innovations, updates, and demos from the Microsoft Business Applications Launch Event.

Top Solution Authors
Top Kudoed Authors
Users online (6,776)