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
Solved! Go to Solution.
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.
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.
Proud to be a Flownaut!
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?
mmm could be the same result friend
Proud to be a Flownaut!
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.
User | Count |
---|---|
92 | |
43 | |
20 | |
19 | |
15 |
User | Count |
---|---|
135 | |
54 | |
44 | |
40 | |
31 |