Formatting the body of an Email

[bprovost]

Hi!

I have a Flow that takes data from a Form and sends it via email. 

For example, the email will return something like this after the Form is submitted:

Your Name: John Doe

Role:

Location: Remote

Computer Name:

What I want is to *not* have things like "Role:" and "Computer Name:" come up at all in the email if the questions weren't answered in the Form. Is there a way to do this? Thanks for any help or advice you may have!

[mbutterz]

Just don't add those Dynamic content parts to the body of the email - only add the ones you do want!

[bprovost]

Sometimes those questions are answered and would need to be included in the email. So basically, if it's answered, I want it in there, and if it's not answered, I don't want it there.

[v-bacao-msft]

Hi @bprovost ,

You could refer to the following method to configure Flow.

• Determine if the answer is empty, and if it is not empty, append the question and answer to the variable.
• It is also recommended to set some required questions to Required. For example, Your Name is a required question ,this answer can be configured directly in the Email body.

• Use Condition to determine if the submission is empty, and if not, append the content. The configuration of several Conditions is similar.

Image reference:

Hope it helps.

Best Regards,

[bprovost]

The form is over 40 questions long with many multiple answers for each question. Is there a way to do this in an expression within the body of the email, so that if a field has a value, it publishes the category with the response?

For example, a different part of the flow takes a log input by a user that typically runs together as one paragraph. I have an expression written in the body of the email that takes that log and puts every sentence on its own line, thus formatting it correctly. That expression is:

           uriComponentToString(

              replace(

                 uriComponent(body('Get_response_details')[r7571576ae83e40038b69668c8e263d2d']),

                 '%0A',

                 '<br/>'

    )

)

I essentially want to do something similar, but with adding or not adding a category if there is an answer to a question on the form.