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 open the response in an excel spreadsheet.
I was wondering if there was a way for the excel spreadsheet that I can see when viewing the link to be attached directly to the email I receive notifying me of the response instead of just a notification. I have had a look at creating a flow for this but cannot seems to find or create a flow that allows me to do the above. Is there a way to do this?
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
Joel2275 yes, you would put in whatever makes it clear to you what the questions and answers were. Rob
Los Gallardos
Damien_Rosario yes that's the way we do it as well: send an email via flow to the responder which can be nicely formatted with our logo etc and any other info we want to give them, and we often then add the response to a SharePoint list.
Rob
Los GallardosHi Damien:
I noticed your response in this tread about emailing responses in a formatted email. At our office we have a similar need. We have a form our patients fill out. The form was built in MS Forms online through XL. We receive the responses in the XL file online and from there construct the resulting form to "print" in the office to PDF.
I've tried to build the resulting form FIELD BY FIELD in word to absorb the responses, but either due to our version of office365 or other limitations, the WORD CONNECTOR wont fill in the blanks. The form is complex in the sense of having several pages but simple since it does not re-use data or use conditionals or other operators.
I've looked up several videos on the matter but some of the workflows dont seem to FIT.
Was wondering if you had any thoughts on it.
Thanks!
