Update item with multiple choice columns

(1) Share

Report

Posted on by Community Power Pla...

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)

Community Power Pla... on at

Like (0)

Report

Was this reply helpful? Yes No
Verified answer

v-litu-msft on at

Like (4)

Report

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... on at

Like (0)

Report

@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 (1)

Report

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 (0)

Report

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 (0)

Report

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

Was this reply helpful? Yes No
chienhsianghung 235 on at

Like (1)

Report

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 (0)

Report

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... on at

Like (0)

Report

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 (2)

Report

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