Others

Create PDF Reports from Microsoft Forms with Power Automate

Kushani NimanthikaKushani Nimanthika Nov 14, 2026 868 views

Question details

Create a PDF report from each Microsoft Forms response and email it to a designated recipient.

Create PDF Reports from Microsoft Forms with Power Automate
Product
Microsoft Forms, Power Automate, and Microsoft Word
Device & OS
not provided
Scenario
A user collects quantitative and qualitative observations in a form and wants a completed report generated and emailed automatically.
Observed behavior
Each submitted response is inserted into a Word template, converted to PDF, and sent as an email attachment.
Before you start

Create your questionnaire in Microsoft Forms and identify the recipient of the reports. Check that your account can access Power Automate, Word Online (Business), OneDrive for Business, and the email connector, and that your license covers the actions you need.

Solution 1Recommended

Generate and email a PDF from each form response

Use an automated Power Automate flow to populate a Word template and send the resulting PDF.

The Word Online (Business) connector's template action may require a premium Power Automate license. The available actions and connections depend on your organization's account and policies.

1
Prepare the Word template

In Microsoft Word, open the Developer tab and insert a plain text content control for each answer you want in the report. Give each control a unique title through Properties, then save the .docx template to OneDrive for Business or SharePoint.

2
Create the response trigger

In Power Automate, select Create > Automated cloud flow. Choose Microsoft Forms' When a new response is submitted trigger and select your form under Form Id.

3
Retrieve the answers

Add the Microsoft Forms Get response details action. Select the same Form Id and use the trigger's Response Id as the Response Id.

4
Populate and save the document

Add Word Online (Business) > Populate a Microsoft Word template, select the template, and map each content-control field to its corresponding answer from Get response details. Add OneDrive for Business > Create file to save the generated document as a .docx file, using the Response Id in the file name to keep it unique.

5
Convert and email the PDF

Add OneDrive for Business > Convert file, select the file identifier from Create file, and choose PDF as the target type. Add your email connector's Send an email action, enter the recipient, and attach the conversion output with a file name ending in .pdf. Save the flow and submit a test response.

Check the test report: Open the emailed PDF and verify that every answer appears in the correct field. If a response is missing, check the field mapping in Populate a Microsoft Word template.
Free Microsoft Office alternative

Edit and export report documents with WPS Office

WPS Office is a free, lightweight alternative for editing report documents in a familiar interface. Open compatible Word files and export reports to PDF; moving existing documents is straightforward. It does not replace the Microsoft Forms and Power Automate flow.

Edit report templates and completed documents in WPS Writer.Open and edit Microsoft Word DOCX files.Export completed reports to PDF for sharing.Work in a familiar interface with a free, lightweight office suite.
microsoft office alternative - wps office

Frequently Asked Questions

How does the flow get the answers from Microsoft Forms?

Add Get response details after the When a new response is submitted trigger. Select the same form and pass the trigger's Response Id to the action.

Why don't my template fields appear in Power Automate?

In Word, use the Developer tab to add supported content controls and give each one a unique title in Properties. Save the DOCX template, then select it again in Populate a Microsoft Word template.

Does this flow require a premium license?

The Word Online (Business) template action may require a premium Power Automate license. Check the connector's licensing requirements and your organization's plan before building the flow.

How can I send the report to a different recipient?

In the Send an email action, change the address in the To field. You can also map an appropriate email-address answer from Get response details if the report should go to an address supplied in the form.