Unanswered

Unable to update multi select choice field in SharePoint list!

(0) Share

Report

Posted on by Dave Wi

Hello,

I have a multi select choice field called MultiChoiceField1" in sharepoint with options "abc,xyz" list that I am trying to update via flow, which should accept the value in the following syntax:

However, it still shows data updated as "[
{
"Value": "abc"
},
{
"Value": "xyz"
}
]" in the "MultiChoiceField1" as single line of text instead of multi select seperate option.

Therefore, none of the following logic works for me as it is not working manually as well:

https://sharepains.com/2019/04/01/microsoft-flow-update-a-multi-select-choice-field-in-a-sharepoint-list/

https://spknowledge.com/2020/09/04/update-multichoice-field-using-power-automate/

Can you please share where I am getting wrong?

Thanks,

Categories:

Building flows

I have the same question (0)

All responses (4)

Answers (1)

Expiscornovus 33,189 Most Valuable Professional on at

Like (0)

Report

Hi @dave8,

The format of that array looks ok. Can you check the settings of your MultiChoiceField1 column. Does it actually allow multiple selections? Just to double check.

If that's setup correctly, are you able to show the output of an existing item in the list where multiple choice values are being set to see the MultiChoiceField1 column values and share a screenshot of that with us?

Was this reply helpful? Yes No
Verified answer

Pstork1 68,697 Most Valuable Professional on at

Like (1)

Report

Did you make sure you clicked on the icon above and to the right of the field to switch it to Array entry mode?

Was this reply helpful? Yes No
Dave Wi on at

Like (0)

Report

Hello

@Expiscornovus

Actually I could not share the screenshot, but I can confirm that "Multiple values" are allowed in the field and in the list column MultiChoiceField1 I see that multiple values are seperated by comma e.g. "a,b,c"!

@Pstork1

When I set output as follows, it did not work!

When I reverted it back as follows, it worked!!!!!! ( However that's how it was earlier 😞 , Or I do not remember correctly, but this is the culprit! )

I am glad, the issue is resolved!! Thank you very much for your time 🙂

Best,

Was this reply helpful? Yes No
Pstork1 68,697 Most Valuable Professional on at

Like (0)

Report

If you look at the dialog you will see that the first one is in individual item mode. You can tell by the Add link below it. The second is array mode, which is what you need.

Was this reply helpful? Yes No