Forum Discussion
Attach Microsoft Forms response in email
Hi, When a respondant competes a form that I have sent them, I get an email notifying me that they have completed it and to click on the link to view the results. I then follow this link and ope...
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
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
