Forum Discussion

mrtuft's avatar
mrtuft
Copper Contributor
Mar 14, 2023

Format data by examples

Wonder if I can ask for some help please, as a newbie to MS Forms and Flows.  I've set up a new form where one of the questions is an options based question and allows the user to select a maximum of...
microsoft forms
RobElliott's avatar
RobElliott
Silver Contributor
Mar 15, 2023

mrtuft for this example this is my form with at most 5 options selected and I've selected 5 of the options.

 

 

Create your flow (NOT using the template) and add the Forms when a new response is submitted trigger immediately followed by the get response details action and add a terminate action. 

 

Then fillin the form, test the flow and in the results of the flow copy the ID of your choice question:

 

 

Edit the flow again and delete the terminate action.

 

Add a compose action, click the Inputs field and in the expression tab paste in the following expression replacing my question ID with your one that you copied earlier:

replace(replace(replace(replace(outputs('Get_response_details')?['body/r7d861ea010544f01bdc9e0ce4396608e'], ']',''),'[',' '),'"',''),',',', ')

 

 

You can then add the selections to a ShaRepoint column or send an email action, as below, to see the results:

 

 

Rob
Los Gallardos
Microsoft Power Automate Community Super User

 

Resources