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

 

3 REPLIES 3
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

 

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!

Helpful resources

Announcements
firstImage

Microsoft Business Applications Virtual Launch Event

Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

firstImage

Watch Sessions On Demand!

Continue your learning in our online communities.

Power Platform 2019 Release Wave 2 Plan

Power Platform 2019 Release Wave 2 Plan

Features releasing from October 2019 through March 2020

thirdimage

Flow Community User Group Member Badge

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

fifthimage

Microsoft Learn

Learn how to build the business apps that you need

sixthImage

Power Platform World Tour

Find out where you can attend!

seventhimage

Webinars & Video Gallery

Watch & learn from the Flow Community Video Gallery!

Top Kudoed Authors
Users Online
Currently online: 54 members 4,682 guests
Please welcome our newest community members: