Forum Discussion

Copper Contributor

Jun 10, 2019

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

microsoft forms

Damien_Rosario
Jun 12, 2019
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

Damien_Rosario

Silver Contributor

Mar 10, 2021

Hi michellekafel

I hope you are well.

I'm not aware of any easy way to extract the actual form response link itself and have it emailed to SolarWinds via Power Automate.

I would suggest just populating the email with the relevant fields so that the response is captured in the body (I know it's not what you wanted but it's one of the viable options you can do [recommended])

you can dump the output of the form response into a file to then attach to the email and send (this will require more work).

Looking at your Flow, you'll need to have Get responses to allow you to grab the form responses to add into your email (using Dynamic content) before sending the email.

Hope something in there helps.

Cheers & best wishes

Damien