Forum Discussion
Attach Microsoft Forms response in email
Hi Joel2275
There's currently no direct way to get the result in this way.
However, you could try instead to use Microsoft Flow and when a new form is submitted, to have the results emailed to you (see my template below as an example).
Step 1 - Use this to retrieve the submitted forms info.
Step 2 - Using Outlook - Send an email (V2), you can specify yourself as the recipient and then populate the Body with the headers and (green) form attributes.
Would save you having to actually hunt for the result in Forms as it's sent directly to your inbox.
Hope that makes sense?
Cheers
Damien
Hi Joel2275
There's currently no direct way to get the result in this way.
However, you could try instead to use Microsoft Flow and when a new form is submitted, to have the results emailed to you (see my template below as an example).
Step 1 - Use this to retrieve the submitted forms info.
Step 2 - Using Outlook - Send an email (V2), you can specify yourself as the recipient and then populate the Body with the headers and (green) form attributes.
Would save you having to actually hunt for the result in Forms as it's sent directly to your inbox.
Hope that makes sense?
Cheers
Damien
Hi Damien,
Thank you. For the body in the send an email section of the flow, would I have to put a heading for every question I have included in my form for it to display the results in an email? I have included around 25 quesitons in my form. Damien_Rosario
Hi Joel2275
Yes, the outputs will likely be meaningless without headers.
And as RobElliott has shown, you can also format the email to present a particular format which is handy when you want to see things in certain ways.
I would suggest having a play with the email option, I suspect it's the best way for you to resolve your issue.
Tag us in if you have any issues and we can help you navigate it, but I think you'll be alright!
Cheers and best wishes
Damien
Hi Damien,
I've been playing around with the email option as you suggested and have gotten it to work. The responses are now being directly attached to the email which is working fantastic for me. Thank you. Damien_Rosario
Hi Damien,
I've been playing around with the email option as you suggested and have gotten it to work. The responses are now being directly attached to the email which is working fantastic for me. Thank you. Damien_Rosario
Joel2275 yes, you would put in whatever makes it clear to you what the questions and answers were. Rob
Los Gallardos
This is what I needed. The only question I have is what about the form responses that the user leaves blank? I created a form that has branching so the user may not have a need to answer all of the questions.
If they don't answer all of the question, I will be generating an email that has a bunch of null answers. Do you have any suggestions as to how I can send emails from Microsoft Flow only for the questions people answer?
ersula82 if you try to trap every question that hasn't been answered and then have a separate email for each combination of possible answers you will end up with a massive and very complicated flow. We just leave the answer as blank if the user hasn't answered the question, it's far easier!
Rob
Los Gallardos
Microsoft Power Automate Community Super User
