Answered

Build Flow to email Responses & Attachments

(0) Share

Report

Posted on by BSh70

I have a form built in Microsoft Forms; it has an upload attachment question, and multiple branches to different sections within the form. I need to set up a flow that would send an email when someone submits a response through the form, and the email would include the responses to the questions in the form, and any attachments that are uploaded. If possible, I would love for the email to only include the questions that have a response, and not all the questions that do not have a response.

Thank you!

All responses (2)

Answers (1)

Verified answer

v-yujincui-msft on at

Like (0)

Report
Re: Build Flow to email Responses & Attachments

Hi @BSh70 ,

Based on your description, i have made a test for your reference.

1. Here is my MS Forms.

2. Here is my Flow.

empty(Dynamic Content)
QuestionName: Dynamic Content<br />
json(Dynamic Content)
items('Apply_to_each')?['id']
{ "Name": @{items('Apply_to_each')?['name']}, "ContentBytes": @{body('Get_file_content')} }
<!DOCTYPE html> <html> <head> <title></title> </head> <body> @{variables('varhtml')} </body> </html>

Result Screenshot:

In addition, here are some links that for your reference.

https://powerusers.microsoft.com/t5/Building-Flows/Power-Automate-Form-to-PDF-remove-blank-answers/td-p/1647546

https://willpage.dev/2021/06/01/processing-microsoft-forms-file-upload-in-power-automate/

https://www.google.com.hk/search?q=Flow+get+MS+form+file&rlz=1C1ONGR_enCN997CN997&oq=Flow+get+MS+form+file&aqs=chrome..69i57j33i160l2j33i22i29i30l7.6736j0j7&sourceid=chrome&ie=UTF-8

Best Regards,
Charlie Choi
ArchitectMadhan 1,580 on at

Like (0)

Report

Re: Build Flow to email Responses & Attachments

Hi @BSh70 ,

Please the below Power Automate Flow template for sending email once the response from MS Forms has been submitted.

Send an email to responder when response submitted in Microsoft Forms | Microsoft Power Automate

Also, if you need to have only questions answered to be shown in the email, Please refer the below link.

Microsoft Flow - Email Notification on Form Completion with Flow (using a template) (lsuhsc.edu)

In the above example you need to use if statement to check the answered questions.