Forum Discussion

paulbe4's avatar
paulbe4
Copper Contributor
Feb 03, 2021

Get answer in the text of the email

Hello,

 

I'm not skilled with Forms/Power Automate but trying to build something and I fail on one point.

 

The forms has a list and for each line, the user can choose "To create" or "Do not create".

If "To create" is ticked, an email is sent to someone and I'd like to have the list of answers to the list in the mail.

In Power Automate, I created the Send email step, and in the text I typed:

 

If the user ticked "To create" for the question 1 only, I'd like it to look like this:

- question 1 : To create

- question 2 : 

 

What I get is:

- question 1 : { "id": 2, "order": 1.0, "displayText": "To create", "description": null, "isCustomChoice": false, "customProperties": "{\"IsGenerated\":false}", "key": "b05b447d-9596-4961-a969-942b3048f033", "formsProDisplayRTText": null }

 

So I need help! I just want the text "To create" to be displayed.

 

How can I do that?

 

Thank you in advance for you help and your time, it'll be much appreciated.

 

Cheers!

  • RobElliott's avatar
    RobElliott
    Silver Contributor

    paulbe4 could you post a screenshot of the whole flow as that will make it easier to identify where the problem is. I assume that after your trigger you have added "Get response details" as the first action as you always need to have that:

     

    Rob
    Los Gallardos
    Microsoft Power Automate Community Super User

    • paulbe4's avatar
      paulbe4
      Copper Contributor

      RobElliott 

      Hello,

       

      Actually when I set this up, it doesn't work. So I deleted it and it works but the text isn't the right one. I found on Internet something that makes it work but I still face an issue.

       

      Lemme explain, here's the full flow:

                                     If yes                                 

                                       V

       

      So this works.

      The initial Forms where it's taken from is like this:

      So what I want is that if the user ticks the "A créer" box (= "To be created") for lines 1 or 2, an email is sent to someone (person 1) / if the user ticks "A créer" box for lines 5 or 6, a second email is sent to someone else (person 2).

      (Lines 3 and 4 are managed differently and don't create any issues for me.)

       

      So I want the email to be sent to PERSON 1 only if one of the two first lines is ticked (only box To be created). Same thing for the email for PERSON 2.

      If the user only ticks the first line, there should be an email to be send to PERSON 1, but no email to be send to PERSON 2.

       

      How to do that?

      I hope you'll be able to help me.

      • RobElliott's avatar
        RobElliott
        Silver Contributor

        paulbe4 I'll go through your email but the first thing I noticed immediately was that you don't have a "Get response details" action in your flow. You MUST have this and usually it is placed immediately after the trigger. I haven't yet read the post to see why you have a couple of Parse JSON actions but if you have the "Get response details" you don't need those.

         

        Rob
        Los Gallardos
        Microsoft Power Automate Community Super User

Resources