Forum Discussion
Solved
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
michellekafel if I understand the process correctly, from a previous flow I put together. all your form answers are collected in an online spreadsheet. You should be able to share the link to the responses in the body of the OUTGOING email telling your team there is a new response. Always the same link embedded in said email.
You should be able to access it from the admin page of the form itself.
This link will be to all responses generated by that form, but will be sent as soon as a new entry is added. That's as easy as it gets.
I understand that, but I don't think I set up the FLOW correctly, then. So far, I only get a new ticket created (the email to HelpDesk) w/no info or links to further data. The body of the ticket/email is blank.
michellekafel this is the simple flow I put together for my form. Since im using some of the fields of my form on the email I added the GET RESPONSE step. However if your message doesn't use that info, you can skip and go straight to the SEND AN EMAIL step. Once you click on it you can then edit the body of the email to your linking.
Once you click on it you can then edit the body of the email to your linking.
I didn't use links on my message body since all the relevant users already had a shortcut available, also the needed data was on the body.
Hi, Came across this topic, Just wondering how you get the format tools within the body object (HTML is enabled)..? (Fonts/Bold Etc)... Thanks In Advance
Brett_Inology click the </> code view button then add html tags:
Rob
Los Gallardos
Microsoft Power Automate Community Super User
oemmanuelli you can't omit the the Get response details action because if you do you won't be able to get any of the response details info in later steps in your flow.
Rob
Los Gallardos
Microsoft Power Automate Community Super User- RobElliott thanks rob! as im not that experienced, you just helped on one of those blind leading the blind. michellekafel as he indicated, the GET RESPONSE step cant be omitted. likely you already knew that! that being said, next step is to edit your email body as per your needs.
