SOLVED
Home

Attach Microsoft Forms response in email

%3CLINGO-SUB%20id%3D%22lingo-sub-680349%22%20slang%3D%22en-US%22%3EAttach%20Microsoft%20Forms%20response%20in%20email%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-680349%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWhen%20a%20respondant%20competes%20a%20form%20that%20I%20have%20sent%20them%2C%20I%20get%20an%20email%20notifying%20me%20that%20they%20have%20completed%20it%20and%20to%20click%20on%20the%20link%26nbsp%3B%20to%20view%20the%20results.%20I%20then%20follow%20this%20link%20and%20open%20the%20response%20in%20an%20excel%20spreadsheet.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20was%20wondering%20if%20there%20was%20a%20way%20for%20the%20excel%20spreadsheet%20that%20I%20can%20see%20when%20viewing%20the%20link%20to%20be%20attached%20directly%20to%20the%20email%20I%20receive%20notifying%20me%20of%20the%20response%20instead%20of%20just%20a%20notification.%20I%20have%20had%20a%20look%20at%20creating%20a%20flow%20for%20this%20but%20cannot%20seems%20to%20find%20or%20create%20a%20flow%20that%20allows%20me%20to%20do%20the%20above.%20Is%20there%20a%20way%20to%20do%20this%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-680349%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EForms%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-685805%22%20slang%3D%22en-US%22%3ERe%3A%20Attach%20Microsoft%20Forms%20response%20in%20email%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-685805%22%20slang%3D%22en-US%22%3E%3CP%3EHi%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F357482%22%20target%3D%22_blank%22%3E%40Joel2275%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThere's%20currently%20no%20direct%20way%20to%20get%20the%20result%20in%20this%20way.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHowever%2C%20you%20could%20try%20instead%20to%20use%20Microsoft%20Flow%20and%20when%20a%20new%20form%20is%20submitted%2C%20to%20have%20the%20results%20emailed%20to%20you%20(see%20my%20template%20below%20as%20an%20example).%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20954px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F117857i671B2B2C7DC3C970%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22capture20190612144615877.png%22%20title%3D%22capture20190612144615877.png%22%20%2F%3E%3CSPAN%20class%3D%22lia-inline-image-caption%22%20onclick%3D%22event.preventDefault()%3B%22%3EStep%201%20-%20Use%20this%20to%20retrieve%20the%20submitted%20forms%20info.%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20616px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F117858i1E670A6A9BDB8C04%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22capture20190612145453131.png%22%20title%3D%22capture20190612145453131.png%22%20%2F%3E%3CSPAN%20class%3D%22lia-inline-image-caption%22%20onclick%3D%22event.preventDefault()%3B%22%3EStep%202%20-%20Using%20Outlook%20-%20Send%20an%20email%20(V2)%2C%20you%20can%20specify%20yourself%20as%20the%20recipient%20and%20then%20populate%20the%20Body%20with%20the%20headers%20and%20(green)%20form%20attributes.%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWould%20save%20you%20having%20to%20actually%20hunt%20for%20the%20result%20in%20Forms%20as%20it's%20sent%20directly%20to%20your%20inbox.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHope%20that%20makes%20sense%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ECheers%3C%2FP%3E%3CP%3EDamien%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-686708%22%20slang%3D%22en-US%22%3ERe%3A%20Attach%20Microsoft%20Forms%20response%20in%20email%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-686708%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F89704%22%20target%3D%22_blank%22%3E%40Damien%20Rosario%3C%2FA%3E%26nbsp%3Byes%20that's%20the%20way%20we%20do%20it%20as%20well%3A%20send%20an%20email%20via%20flow%20to%20the%20responder%20which%20can%20be%20nicely%20formatted%20with%20our%20logo%20etc%20and%20any%20other%20info%20we%20want%20to%20give%20them%2C%20and%20we%20often%20then%20add%20the%20response%20to%20a%20SharePoint%20list.%3C%2FP%3E%3CP%3ERob%3CBR%20%2F%3ELos%20Gallardos%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-686709%22%20slang%3D%22en-US%22%3ERe%3A%20Attach%20Microsoft%20Forms%20response%20in%20email%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-686709%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20Damien%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you.%20For%20the%20body%20in%20the%20send%20an%20email%20section%20of%20the%20flow%2C%20would%20I%20have%20to%20put%20a%20heading%20for%20every%20question%20I%20have%20included%20in%20my%20form%20for%20it%20to%20display%20the%20results%20in%20an%20email%3F%20I%20have%20included%20around%2025%20quesitons%20in%20my%20form.%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F89704%22%20target%3D%22_blank%22%3E%40Damien%20Rosario%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-686723%22%20slang%3D%22en-US%22%3ERe%3A%20Attach%20Microsoft%20Forms%20response%20in%20email%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-686723%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F357482%22%20target%3D%22_blank%22%3E%40Joel2275%3C%2FA%3E%26nbsp%3Byes%2C%20you%20would%20put%20in%20whatever%20makes%20it%20clear%20to%20you%20what%20the%20questions%20and%20answers%20were.%20%3CSPAN%3ERob%3C%2FSPAN%3E%3C%2FP%3E%3CP%3ELos%20Gallardos%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-left%22%20style%3D%22width%3A%20616px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F117884iDFC1DCAA0B9E7A92%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%2299-longform.png%22%20title%3D%2299-longform.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-688960%22%20slang%3D%22en-US%22%3ERe%3A%20Attach%20Microsoft%20Forms%20response%20in%20email%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-688960%22%20slang%3D%22en-US%22%3E%3CP%3EHi%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F357482%22%20target%3D%22_blank%22%3E%40Joel2275%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EYes%2C%20the%20outputs%20will%20likely%20be%20meaningless%20without%20headers.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAnd%20as%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F174092%22%20target%3D%22_blank%22%3E%40Rob%20Elliott%3C%2FA%3E%26nbsp%3Bhas%20shown%2C%20you%20can%20also%20format%20the%20email%20to%20present%20a%20particular%20format%20which%20is%20handy%20when%20you%20want%20to%20see%20things%20in%20certain%20ways.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20would%20suggest%20having%20a%20play%20with%20the%20email%20option%2C%20I%20suspect%20it's%20the%20best%20way%20for%20you%20to%20resolve%20your%20issue.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ETag%20us%20in%20if%20you%20have%20any%20issues%20and%20we%20can%20help%20you%20navigate%20it%2C%20but%20I%20think%20you'll%20be%20alright!%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ECheers%20and%20best%20wishes%3C%2FP%3E%3CP%3EDamien%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-689560%22%20slang%3D%22en-US%22%3ERe%3A%20Attach%20Microsoft%20Forms%20response%20in%20email%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-689560%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20Damien%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI've%20been%20playing%20around%20with%20the%20email%20option%20as%20you%20suggested%20and%20have%20gotten%20it%20to%20work.%20The%20responses%20are%20now%20being%20directly%20attached%20to%20the%20email%20which%20is%20working%20fantastic%20for%20me.%20Thank%20you.%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F89704%22%20target%3D%22_blank%22%3E%40Damien%20Rosario%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-689643%22%20slang%3D%22en-US%22%3ERe%3A%20Attach%20Microsoft%20Forms%20response%20in%20email%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-689643%22%20slang%3D%22en-US%22%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHi%20Damien%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI've%20been%20playing%20around%20with%20the%20email%20option%20as%20you%20suggested%20and%20have%20gotten%20it%20to%20work.%20The%20responses%20are%20now%20being%20directly%20attached%20to%20the%20email%20which%20is%20working%20fantastic%20for%20me.%20Thank%20you.%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F89704%22%20target%3D%22_blank%22%3E%40Damien%20Rosario%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
Occasional Contributor

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?

7 Replies
Highlighted
Solution

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 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.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 

Highlighted

@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 Gallardos

Highlighted

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 

Highlighted

@Joel2275 yes, you would put in whatever makes it clear to you what the questions and answers were. Rob

Los Gallardos

99-longform.png

Highlighted

Hi @Joel2275 

 

Yes, the outputs will likely be meaningless without headers.

 

And as @Rob Elliott 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

Highlighted

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 

Highlighted

 

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 

 

Related Conversations
Restricting choices on Likert
jsdoupe in Microsoft Forms on
0 Replies
British summer time/daylight saving time
angefoster in Microsoft Forms on
0 Replies
Something Went Wrong Please Try Again
Maric06 in Microsoft Forms on
2 Replies
Something went wrong. Error code: 752
GoodCity in Microsoft Forms on
0 Replies
Managing the access to the result summary page.
annienak in Microsoft Forms on
0 Replies