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 2 options from a list of 3 different options available.  Let's say the 3 options are Apples, Bananas and Pears and the user selects Apples and Pears.

 

I want the user to receive an automated email receipt to confirm their selections, which is all good as created these before, but when using Dynamic content to return the value of the options question, it returns the answer as ["Apples","Pears"] whereas I want it to say Apples and Pears without the brackets and quotes.

 

Any suggestions on the easiest way to achieve that?

 

Thanks in advance.

 

 

microsoft forms

1 Reply

  • 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