Update item with multiple choice columns

(1) Share

Report

Posted on by Community Power Pla... Microsoft Employee

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

Categories:

Building flows

I have the same question (1)

All responses (10)

Answers (1)

Sort by

Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Was this reply helpful? Yes No
Verified answer

v-litu-msft Microsoft Employee on at

Like
a
(4)

Report
Copy link

Link copied!

Hi @Anonymous,

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:

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.

1 people found this reply helpful.

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

@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

Was this reply helpful? Yes No
FBirnbaum 11 on at

Like
a
(1)

Report
Copy link

Link copied!

Hi!

I am trying to follow the desciption above, however, I can't see the sign marked in red in the picture above, and I can't manage to insert my array variable into the field there.
In my case, it's about topics of a list entry, so the array variable I created and put in the topics is called "arrTopics".

Thank you for your help!

Was this reply helpful? Yes No
jaina 517 on at

Like
a
(0)

Report
Copy link

Link copied!

tried this solution but encountered "BadGateway" which causing the workflow not to proceed to the next action

1 people found this reply helpful.

Was this reply helpful? Yes No
chienhsianghung 235 on at

Like
a
(0)

Report
Copy link

Link copied!

Same problem here. Can't insert the arr variable to it in PA.

Was this reply helpful? Yes No
chienhsianghung 235 on at

Like
a
(1)

Report
Copy link

Link copied!

Hi @FBirnbaum , I've found the reason and documented my steps to solve this. Feel free to check it out
Power Automate Update Sharepoint List Item Choice Column
I hope this is helpful 😀

Was this reply helpful? Yes No
pm325 30 on at

Like
a
(0)

Report
Copy link

Link copied!

Thank you. Is there anywhere to go to read documentation for how all these actions operate and the ins and outs with how to manipulate them? As a programmer, if I want to learn how something works in JavaScript for instance, there is vast documentation detailing every single component, method, function, etc. and how they work and what you can do to them. With Power Automate, I'm left scrounging around and hoping someone has asked a similar question.

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi,
I have left my multiple choice column blank in 'Update Item', so the flow doesn't update it, but then every time the flow outputs null value for that column even though I haven't put it into the action. Would you be able to help me please?

Was this reply helpful? Yes No
Splash58 32 on at

Like
a
(2)

Report
Copy link

Link copied!

I dont want to reopen this topic but this might help some people that rely on parallel "apply to each" loops.
If you use parallel loops, you cant use array variables.
Instead what you can do, is to map your array like in the following screenshot.

This will give you much better performance when working with a lot of records.

Was this reply helpful? Yes No