Managing Multiple Selection Responses in Excel: Organizing Data from Microsoft Forms Using Power Automate

[jkollie]

Dear friends,

I created a microsoft form to accept data and store them in a spreadsheet. A flow was also created in power automate to upate the table in the spreadsheet each time a response is submitted. But one of the questions in microsoft form requires mutiple selection based on the responder's choice. Branching was used to achieve that. I want to store the selected values under that question (with multiple selections) in their designated individual columns in the spreadsheet instead of stacking them on top of one another in the same column.

Does anyone know how to achieve this?

Your help is appreciated.

[Joseph_Fadero]

Hi @jkollie ,

I trust you are good, 

Based on my understanding of your request, You would like to split the values coming from a particular column and have it as separate dynamic contents feeding into your particular case, If that's the case, I believe that can be done using Power Fx Expressions, Can you drop a screenshot of your flow and the current output it is giving.

Kindly like my post and mark as a solution if it meets your requirement to aid others in the community with similar request

[jkollie]

It takes multiple steps in Microsoft Form to get the work ticket, which requires branching. I already took care of that. But I want the final output, which is the work ticket, to be placed in the designated column in the online spreadsheet. But it is not working. I don't know what expression to use to fix it. Your help in resolving it will be appreciated. 

Thanks in advance. 

[Joseph_Fadero]

Hi @jkollie ,

I trust you are good,

Thank you for the screenshot, 

Now my initial understanding of what you stated, The final Values which is a Multiple selection or choice column stacks the values inside a single Column, and thus Why I wanted to see the output so I can recommend an expression to split those values. 

Now what you are currently stating is it that the work ticket dynamic content isn't showing at all? Or you don't like how the output of the Work ticket is coming out. Please further clarify to aid in assisting with your issue

[jkollie]

The work ticket is not showing at all. That is the problem I want to address. 

Thank you for your help. 

[Joseph_Fadero]

Hi @jkollie,

I trust you are good,

Can you please share an anonymized version of the form, So I can see how the current data gathering process is, and perhaps identify why that could be the case

[jkollie]

Here is the link to the anonymized form: 

Sample Form (Preview) (office.com)

[Joseph_Fadero]

Hi @jkollie,

Kindly note I don't have access

[sree813]

Hello,

If I understood correctly, You want to save the multiple resonses from MS Form. Check below.

1. Parse JSON so that you can easily get the required column values.

2. Then I am splitting the values of this column with ;
split(outputs('YourColumnName'),';')

3. Then I am having a condition to check what is present in the 0,1,2,3 position of the response

outputs('Split')?[0]

outputs('Split')?[1]

outputs('Split')?[2]
You can use these expressions in compose or a condition based on your requirement.

Let me know if it solves your problem.
Thanks.