cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Super User
Super User

Split multi answer Forms question

Hello all,

 

I'm looking for some way how to split multi answer question in Forms. It seems like it is not possible to work with this content as array, even it looks like array.

 

Forms1.PNG

 

Here is how output looks

 

Forms2.PNG

It behaves like string so when added to SharePoint list it looks quite strange and I want to format it in way Item1, Item2, Item3, but I am not able to find way how to do it.

 

Forms3.PNG

Any ideas?

 

Thank anybody for help.

 

 

1 ACCEPTED SOLUTION

Accepted Solutions
Community Support Team
Community Support Team

Re: Split multi answer Forms question

Hi @vecerpa,

 

You could take a try to create the flow as below:

Capture.PNG

 

Please insert the following expression in the Parse JSON action:

{
    "type": "array",
    "items": {
        "type": "string"
    }
}

The flow would run successfully as below:

Capture.PNG

 

Best regards,

Alice

 

View solution in original post

4 REPLIES 4
Community Support Team
Community Support Team

Re: Split multi answer Forms question

Hi @vecerpa,

 

You could take a try to create the flow as below:

Capture.PNG

 

Please insert the following expression in the Parse JSON action:

{
    "type": "array",
    "items": {
        "type": "string"
    }
}

The flow would run successfully as below:

Capture.PNG

 

Best regards,

Alice

 

View solution in original post

Community Support Team
Community Support Team

Re: Split multi answer Forms question

Hi @vecerpa,

 

Have your problem be solved according to my solution?  If yes, please go ahead and mark the post as solved by clicking “Accept as Solution” so that this thread will be marked for other users to easily identify!

 

Best Regards,

Alice

Vip3rSKF
Level: Power Up

Re: Split multi answer Forms question

Hello!

I'm running into a similar issue where I need to split the output of a multi-choice field but I'm looking to convert it into a regular list - that's then emailed.

Where I'm stuck is just converting the array of strings into a bullet list to then drop into the Email.

I tried using the flow process and was able to get a single item to output but, because of the nested for-each that's auto-created, it sent an email for each string inside that array. Is there a way to have it convert the whole question response from something like this,

[
"Administer process permissions",
"Administer Workspaces",
"Alter trace settings",
"Delete process",
"Edit instance-level information",
"Make requests on behalf of others",
"Manage build resources",
"Manage test controllers",
"View instance-level information",
"View system synchronization information"
]

In to something like this,

  • Administer process permissions
  • Administer Workspaces
  • Alter trace settings
  • Delete process
  • Edit instance-level information
  • Make requests on behalf of others
  • Manage build resources
  • Manage Test Controllers
  • View instance-level information
  • View system synchronization information

without the use of another nested for-each block? I just want to be able to put into an Outlook email the items someone selected in the multichoice question from the MS Form.

Any help or insights would be appreciated!

colbyturybury
Level: Powered On

Re: Split multi answer Forms question

I can not insert the text into the Pars JSON action.

Helpful resources

Announcements
firstImage

Power Platform Online Conference

Join us for the first ever Power Platform Online Conference!

firstImage

Incoming: New and improved badges!

Look out for new contribution recognition badges coming SOON!

firstImage

New & Improved Power Automate Community Cookbook

We've updated and improved the layout and uploading format of the Power Automate Cookbook!

thirdimage

Power Automate Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

sixthImage

Power Platform World Tour

Find out where you can attend!

seventhimage

Webinars & Video Gallery

Watch & learn from the Power Automate Community Video Gallery!

Top Solution Authors
Top Kudoed Authors
Users online (4,935)