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.
Solved! Go to Solution.
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"
}
]
User | Count |
---|---|
93 | |
44 | |
21 | |
17 | |
16 |
User | Count |
---|---|
137 | |
50 | |
42 | |
39 | |
29 |