Sending an email from a Form responses

(1) Share

Report

Posted on by CH-08102040-0

Hi,

I'm in need of some help, i've got a flow that works with fetching responses and then emailing them out.

The problem i am having is being able to create the body of the email with the question in the form and the response to that question.

There are multiple questions and not every question is answered so while the email only returns the answered questions, it leaves huge blank spaces in between where questions aren't answered.

I currently use this if(outputs('Get_response_details')?['body/r55447d5e8e3b4535a457a145b6bac5cc']='','0',outputs('Get_response_details')?['body/r55447d5e8e3b4535a457a145b6bac5cc'])

I've attached an example of what i have, so in essence if only the last question is answered, there is a huge gap until the correct answer reflects.

Help :-)

Categories:

Building flows

I have the same question (0)

All responses (2)

Answers (0)

Sort by

Suggested answer

Michael E. Gernaey 53,963 Moderator on at

Like (0)

Report
Copy link

Link copied!

Hi

I'd like to make a suggestion. Add your items to an Array instead. That way you can verify that it has real data and add it to the Array or if its null don't add it.

In addition, you can add the headers to the array when you define the array (instead of it being blank)

Lastly , you can then use the Create HTML Table, in conjunction with CSS to make it look how you want.

This way you never have spaces :-)

Let me know if you need specific exact details.

Examples:

Styling a HTML table in Power Automate - Imenos

Since you already have all the Answers etc.

Was this reply helpful? Yes No
CH-08102040-0 4 on at

Like (0)

Report
Copy link

Link copied!

Thank you for coming back to me Mike.

I am only learning so if you are able to give me specific exact details, that would be amazing.

P.S i wish i had all the answers :-)

I've got about 60 questions, so i imagine they would all need to be present in the array?

Thanks

Chez

Was this reply helpful? Yes No