Unanswered

Inserting Form Responses into Email Body

(0) Share

Report

Posted on by devatron

Hi There!

Completely new to forms and power automate - trying to determine if there is a way to insert responses and questions from a form into the body of an email. So if Someone submits a survey, instead of having to visit that survey response form the responses are there in the message body.

Additionally, I would love to have any attachments added to the email as well (where possible).

Is this a possibility?

Thank you!

Devon

Categories:

Building flows

I have the same question (0)

All responses (8)

Answers (2)

fchopo 8,003 Moderator on at

Like (0)

Report

Hi @devatron
Please, have a look at the Send an Outlook email for each Microsoft Forms survey response template.
Hope it helps.
Ferran

Was this reply helpful? Yes No
ChristianAbata 8,951 Most Valuable Professional on at

Like (0)

Report

hi @devatron sure is possible please try this.

Folow this link https://www.bythedevs.com/post/working-with-files-on-ms-forms-in-ms-power-automate

Was this reply helpful? Yes No
devatron 45 on at

Like (0)

Report

Hi @fchopo Thank you - I am digging into this automation but it doesn't intuitively explain HOW to get responses into the body of the email. Right now all that offers is how to set up a trigger alerting someone when a response is made. As far as I can tell here at least.

Was this reply helpful? Yes No
devatron 45 on at

Like (0)

Report

Hi @ChristianAbata - thank you.

It seems like this may work. I am including a snap of the current flow I built based on your image. For the "Get Response Details" option - what input ID should I be using? This is very plug and play for me right now as I am wholly unfamiliar with JSON and these other java functions.

The only response ID available to me is the list of responses you see in the image and I am unsure of what to enter for the Input under compose. I would have thought it would be related to the response details flow above the compose box but seems it is not.

Thoughts? And also thank you very much!

Was this reply helpful? Yes No
Verified answer

abm abm 32,865 Most Valuable Professional on at

Like (2)

Report

Hi @devatron

See the below links.

https://www.youtube.com/watch?v=iEm0M_2EP_Y

https://techcommunity.microsoft.com/t5/microsoft-forms/attach-microsoft-forms-response-in-email/m-p/680349

Thanks

Was this reply helpful? Yes No
ChristianAbata 8,951 Most Valuable Professional on at

Like (1)

Report

hi @devatron Everythink you need to add the responses in you email body and for the questions you need to type the question manually.

in your first compose need to pass the variable of you file
And in json response the output of your compose.
Then the schema depends on you answer of the forms.

Follow this steps.

Was this reply helpful? Yes No
devatron 45 on at

Like (1)

Report

@abm - this is great! thank you!

Was this reply helpful? Yes No
Verified answer

abm abm 32,865 Most Valuable Professional on at

Like (0)

Report

Hi @devatron

If you have resolved your issue please mark it as answered which will help others in community.

Thanks

Was this reply helpful? Yes No