Answered

Conditionally add html text to email based on Microsoft Forms responses

(0) Share

Report

Posted on by Dominion85

Hi,

I have a flow that receives input from a Microsoft Form, creates an approval workflow, and then sends a custom approval email to the required parties:

In the approval email, an HTML table that contains the form questions and the form response variables is sent.

I would like to know how to only include specific text or rows in the approval email when the corresponding Forms question is answered. If the question is not answered, I would not like the question to show up in the email table.

For example if there are three questions in my form, and questions 1 and 3 are answered, but question 2 is not answered, I would like the email to only show the questions and responses for 1 and 3 in the table.

Please let me know if this makes sense or if you need more details or clarification of my question.

Any help would be GREATLY appreciated!

Thank you!

- Mike

Categories:

Building flows

I have the same question (0)

All responses (4)

Answers (1)

ChristianAbata 8,951 Most Valuable Professional on at

Like (0)

Report

hi @Dominion85 if the user don't fill the question in the space of email is going to appear empty. But you ca't hide the part of the html code in email if the user don't fill the question because as you know is HTML and is hardcoded. The only option you have is leave that option empty if ths user don't fill the question.

Was this reply helpful? Yes No
Dominion85 2 on at

Like (0)

Report

Thanks for your response Christian.

Is it possible to accomplish this by using a SharePoint list to automatically populate the email with the questions and answers; or is it possible if I use a document template to pull the text instead of HTML?

Was this reply helpful? Yes No
ChristianAbata 8,951 Most Valuable Professional on at

Like (0)

Report

mmm could be the same result friend

Was this reply helpful? Yes No
Verified answer

v-alzhan-msft on at

Like (0)

Report

Hi @Dominion85 ,

Sorry for I'm afraid that your requirement couldn't be easy achieved in Microsoft flow currently.

And the only way may be check all the question to see if the each question answer is null, then you could create different cases with different emails.

Best Regards,

Alice

Community Support Team _ Alice Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Was this reply helpful? Yes No