Showing results for 
Search instead for 
Did you mean: 
Frequent Visitor

Forms to Sharepoint Multi Choice Field

We have a Forms input:


Using Flow to move the Forms data to Sharepoint Multi Choice field in List


Same issue but hoping there are better ways of doing it now:


Super User
Super User

Hi @robcarrs 


The issue is that you're passing to SharePoint a "string" that comes from the Form that contains a JSON with an array. Quite tricky, I know, but let's break it down into an example:


The "Create Item" expects something like this:


    "Value": "Option 1"
    "Value": "Option 3"


and you're providing

"Value":"[\"Option 1\",\"Option 3\"]"

You need to convert it to an array of values so that SharePoint can match the items and know what to do with them.


You need to:

  1.  Remove the special characters [," and ]
  2. Create an array
  3. Build a new array with the structure {"Value":"Option 1"}


Here's the full flow:

2020-02-07 15_17_53-Edit your flow _ Power Automate.png


To remove the characters, use a compose with the following formula:




Then create an array with the elements:



To create the array create an empty array variable. Then do a for each and append to the array with the following formula:


Finally, insert the value in the "Create Item."


You'll get something like this:

2020-02-07 15_15_09-Run History _ Power Automate.png2020-02-07 15_15_15-Run History _ Power Automate.png2020-02-07 15_15_29-Run History _ Power Automate.png2020-02-07 15_15_40-Run History _ Power Automate.png


I've added a template so that you can import so that you don't need to create everything manually. 


If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.


Helpful resources

Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

MPA Virtual Workshop Carousel 768x460.png

Register for a Free Workshop

Learn to digitize and optimize business processes and connect all your applications to share data in real time.

Power Automate Designer Feedback_carousel.jpg

Help make Flow Design easier

Are you new to designing flows? What is your biggest struggle with Power Automate Designer? Help us make it more user friendly!

Users online (1,686)