Solved: Re: Update a List Item - Multiple Select Choice Fi...

Anonymous · ‎12-05-2018

I am trying to update a multiple select choice field. This was working but the chocie control has changed and I can't figure out how to update it.

The Country field has 3 choices and a user can select 1-3 w/ checkboxes.

The Country field is required.

I am updating the item to set it the "Control" value to "Complete". Since Country is required I must update it as well.

This is where I am stuck.

The apply each loop was generated when I tried to set the Country field to Country Value (it's an array).

It is a very simple Flow. Hoping there is a simple answer that eludes me.

v-yuazh-msft · ‎12-06-2018

Hi @Anonymous,

I have made a test on my side, you could click the button as below in the Country Value field to "Switch to input entire Array" :

And then you could choose the "Country" dynamic content of the trigger in the "Country" field of "Update item" action, please refer to screenshot below to create the flow to keep the values in the Country field as below:

The flow would run successfully as below:

Best regards,

Alice

View solution in original post

Pieter_Veenstra · ‎12-06-2018

HI @Anonymous,

I thk you migth need to use the REST API for this using the Send an HTTP request to SharePoint action:

https://veenstra.me.uk/2018/07/05/microsoft-flow-setting-multi-people-fields-in-sharepoint/

Anonymous · ‎12-06-2018

Hmm...I hope not. The article you shared reference the old control in Flow. I was able to update that one with Flow. This recent update to the control is what broke it. Note the new box and the ability to create the array in the control.

I appreciate the info.

v-yuazh-msft · ‎12-06-2018

Hi @Anonymous,

I have made a test on my side, you could click the button as below in the Country Value field to "Switch to input entire Array" :

And then you could choose the "Country" dynamic content of the trigger in the "Country" field of "Update item" action, please refer to screenshot below to create the flow to keep the values in the Country field as below:

The flow would run successfully as below:

Best regards,

Alice

Anonymous · ‎12-06-2018

Yes!!

You are my hero! Thank you very much. This fixes a production issue for me.

VinMSConsultant · ‎08-28-2020

Alternate and simple approach to handle multi choice field in update item.

1. Use 'Select' Action from 'Data Operations' and get the multi choice field value[array].

2. Use the output in Update item as shown below.

zigq8vc0 · ‎12-03-2020

@VinMSConsultant

Thank you...this was the solution for me!

innov8iv · ‎04-30-2021

Perfect solution!

(Took me a bit to realize I had to type the word "Value" into the Map > Enter key field.)

Thank you so much.

clengcleng · ‎12-14-2021

i encountered this error, The 'inputs.parameters' of workflow operation 'Create_item' of type 'OpenApiConnection' is not valid. Error details: The API operation does not allow writing a value for parameter 'item/________[0]/Value'. This parameter is read only.

mioiox · ‎02-01-2022

@clengcleng, I got the same error when I tried the first method suggested. However, the one that @VinMSConsultant proposed, worked flawlessly. I suggest you try that one.

mrobbins · ‎07-26-2022

I know this is an old post, but I just ran across it. This was the easiest approach for me and IT WORKED!!! Thanks!

JayBabcock

YES! YES! YES!

I have been searching for hours to find a solution to this problem. I kept setting array variables and they would not update... I would just get Bad Gateway errors. Finally, I came across this post and it did exactly what I needed in a very simple format... Thank you so much! 😀