Hello All,
I'm new to Forms and Power Automate and was wondering if the following was possible. I have a form with numerous safety questions. They are all Yes / No answers but a No response opens a Comments box where further detail is added. I can get the system to email me notification of a form submission but I'd like to extract all the comments into the body of the mail. Can I get it to automatically include just the completed comments boxes or do I need to point to every single comments box and see the blanks as well as completed?
Thanks in advance
Baz
Hi @BazMan You can use the parallel branching in Power Automate. Below is my suggested way:
1. Create a Flow on trigger of Submit Response of MS Flow and get the response:
2. Initialize the Array varilable of type Array:
3. Add parallel branch to check if question has no response if question has no response then add the comment in the array, refer the below screenshot:
4. Use the Join to make array to string:
5. Add the output of the join in the body:
Below is my summited responses:
And below is the email I have received
Now you will only received only those comment for those related response is NO.
Hope this help, do verify the answer.