Updating a Multi-choice column in Sharepoint using Flow

(0) Share

Report

Posted on by MaryT0905

170

I have a form that asks a series of questions about a new employee. The employee may have mutliple certifications. I have these certification types as choices in a SharePoint. I have a series a condition for each certification type. If this certification type equal yes, then send this type of email, etc. I also have it create a new record in SP for the new employee. I'd like for the flow to also update the certification/roles based on the answers. This works if there is only one, but not multiple. I get an error message saying the update is conflicting with other updates.

I think that I just need to move the update down, or something... not really sure. Would like some help on how to better construct this so I can avoid that error.

THis is where I'm updating both of them if yes

Categories:

Business Process Flows

All responses (1)

Answers (0)

tom_riha 10,127 Most Valuable Professional on at

Like (1)

Report
Re: Updating a Multi-choice column in Sharepoint using Flow

Hello @MaryT0905 ,

you get an error because you've got multiple branches running in parallel, all of them trying to update the same item - they don't like it. Also, as you have it now it won't update multiple values in the choice field, it'd keep only the latest value.

A better approach would be to:

initialize an array variable

in each of the parallel braches use 'Append to array variable' action and append the choice in the format below. Don't update the item yet.

{ "Value": "CertificationShorcut" }

after all the parallel branches are finished use the variable for the update. Switch to the 'Input entire array' and use the variable. This one update will update all the selected values in the item.