How to Automatically Create PDF or Word Files from Microsoft Forms
Question details
The user wants to automatically generate a PDF or Word document from each Microsoft Forms response and add the generated file or link to the related Excel response record using Microsoft Power Automate.

- Product
- Microsoft Forms, Power Automate, Word, Excel, SharePoint/OneDrive
- Device & OS
- not provided
- Scenario
- A user collects responses in Microsoft Forms and needs each submission converted into a Word or PDF document, with the file or link stored in the Excel table that tracks responses.
- Observed behavior
- Documents are currently created manually from Form responses; the goal is an automated Power Automate flow that generates and links the documents without manual intervention.
Make sure you have a Microsoft Forms form with at least one test response, a Word template saved in SharePoint or OneDrive, and access to Power Automate with the same work or school account used by Microsoft Forms and Excel.
Use the prebuilt Power Automate template to create Word and PDF documents from Microsoft Forms
Use this when you want the fastest setup. Microsoft publishes a template that wires together the Forms trigger, Word template population, file creation, and Excel update.
This template uses the standard Microsoft Forms trigger and connectors for SharePoint, OneDrive, Excel, and Word. If your organization restricts template gallery access or you need custom fields, build the flow manually instead.
Go to flow.microsoft.com and sign in, then open the template "Create Word and PDF documents from Microsoft Forms" or use the provided public template link.
On the template connections screen, select or sign in to the Microsoft Forms, Excel Online, SharePoint/OneDrive, and Word Online connectors used by the flow.
Choose the Microsoft Form that will trigger the flow, the Excel workbook and table where responses are stored, and the SharePoint or OneDrive location for generated files.
Submit a new Microsoft Forms response or use the Test feature in Power Automate, then confirm that the Word or PDF file is created and the file link appears in the correct Excel row.
Build a custom Power Automate flow from blank to generate Word or PDF files
Use this when you need full control over template fields, file naming, storage locations, or multiple output formats.
Use WPS Office as a Free Microsoft Office Alternative for Generated Word, Excel, and PDF Files
Microsoft Power Automate handles the automation, but you can open, edit, and share the generated Word and PDF files in WPS Office at no cost. WPS preserves Microsoft Office formatting, supports .docx, .xlsx, and PDF, and offers a familiar ribbon interface for seamless migration.
- 1. Download WPS Office Free: Visit the WPS Office download page and install the free Windows, macOS, Linux, Android, or iOS version for your device.
- 2. Open the generated file: Launch WPS Office, open the Word or PDF file created by Power Automate from its SharePoint, OneDrive, or local download location.
- 3. Edit and save in Microsoft-compatible format: Use Writer to edit .docx or the PDF tools to annotate, then save or export as Word (.docx), Excel (.xlsx), or PDF as needed.

Frequently Asked Questions
Can Power Automate create both Word and PDF files from one Microsoft Forms response?
Yes. The flow can populate a Word template and then create both a Word document and a PDF from that populated template, or convert the Word file to PDF using the OneDrive or SharePoint connector.
Do I need a premium Power Automate license to use Word templates?
Standard connectors for Forms, Excel, OneDrive, and SharePoint are available in many Microsoft plans. Some Word template actions may require a work or school account with appropriate licensing.
Where are the generated files stored?
You choose a SharePoint document library or OneDrive folder in the Create file action. The flow then writes the returned file URL into the related Excel response row.
Can I test the flow with an existing Form response?
Yes. Submit a test response or trigger the flow manually in Power Automate, then check the output file and the Excel row for the generated link.
Does WPS Office integrate with Microsoft Forms or Power Automate?
No, WPS Office does not replace Microsoft Power Automate. However, you can use WPS Office to open, edit, and save the generated Word and PDF files while maintaining Microsoft Office compatibility.




