Unanswered

Inserting multiple values in Sharepoint choice field through JSON

(0) Share

Report

Posted on by Mmmarkk

I am trying to do the following:

I have data in 1 list (List A) that needs to be transferred to a different list (List B). In List A I have a multiple choice field that can contain multiple options. Here comes the difficulty I am facing:

- The flow is setup generic, where I use variables to identify list B, resulting in formatting the item in JSON:

The approach in the screenshot doesnt work. Can anyone help me how I should do this and what datatype the value should be (array, string or something else?)

Many thanks in advance!

Mark

Categories:

Building flows

I have the same question (0)

All responses (3)

Answers (0)

Expiscornovus 33,195 Most Valuable Professional on at

Like (0)

Report
Hi @Mmmarkk,

Normally you can use an array for the multi-choice field value in the body.

The structure of that value would be something like:

[ { "Value": "C" }, { "Value": "D" } ]

You can also see that when you switch to entire array input when you create an item in the list (without the string variables)

Because you used variables for the site and list you can use the below (I assumed the Title field is still needed for your item, if you removed that also remove that from my example).

{ "Title": "Testing", "Soortincident_x002f_ongeval": [ { "Value": "C" }, { "Value": "D" } ] }

The result should be something like below

Was this reply helpful? Yes No
Mmmarkk 2 on at

Like (0)

Report

Hi @Expiscornovus ,

The values would be dynamic as well (limited though to the amount of choices), would you then do the following (lets say if there are 3 choices possible)

I am going to try this at least, and will let you know if it works!

Was this reply helpful? Yes No
Expiscornovus 33,195 Most Valuable Professional on at

Like (0)

Report
Hi @Mmmarkk,

So, your options always get retrieved as a string where each option is separated by a comma?

A,B,C,D

If that is the case you can make that part dynamic as well, you could convert the string to an array by using a split on the comma character. After that you can use a Select action to format it so it uses the array structure I demonstrated earlier and use the output of the Select in your create item action instead.

Below is a second example to demonstrate this

split(variables('Options'), ',')

Was this reply helpful? Yes No