Moving multi-choice column values from Excel to SP List

[GauravG]

Hi All,

I have a SP list with 45 columns.

13 of which are multi-select choice columns.

Can anybody please share how do I migrate those values using flow to SP List?

Also, can anyone share link for creating child flow in such cases because I do not want to repeat Array Variable steps for all these 13 columns- Thanks

[abm · Accepted solution]

Hi @GauravG 

Create a child flow where you need to pass the multi-select choice values. Split the values by semi-colon and construct an array using the following format 

{

  "Value": xxxxx

},

{

  "Value": xxxxx

}

Finally return the above format via response action method back to your parent flow. Use the response result for mapping the SP list multi-select choice field.

Thanks