How to convert an input string to list item choices in Sharepoint?

[JoseZald101]

Hi Everyone,

I have a weird use case for converting a string into the their correspoding choices in a sharepoint list.

The input string would someting like this:

A;#B;#;D#;G#

The multivalue choice items the Sharepoint item are

A, B, C, D, E, F, G

When MS Flow runs, I only want these choice items selected.

A, B, D, G

Would just replacing ";#" to "," do it?

Thanks in advance.

[JoseZald101]

I tried multiple scenarios.
1) Split the entry into array
[
"A",
"B",
"D",
"G"
]

2) but to assign the array into the muti-value field. the array must read like this:
[
{
"Value": "A"
},
{
"Value": "B"
},
{
"Value": "D"
},
{
"Value": "G"
}
]

[JoseZald101 · Accepted solution]

Hi All,

What a great community of developers! I posted the question last night and got the answer this morning!

Thank you Pieter Veenstra for the great explanation and example. Looping through the array and adding to the variable was the key.

https://veenstra.me.uk/2019/04/01/microsoft-flow-update-a-multi-select-choice-field-in-a-sharepoint-...