- Home
- Guides
- Power Automate
- How to turn Microsoft Forms responses into PDFs and email them automatically
How to turn Microsoft Forms responses into PDFs and email them automatically
Build a Power Automate flow that turns each Microsoft Forms response into a formatted PDF, saves it in OneDrive and emails it as an attachment. It works with standard connectors only.
Jump to a step (10)
Forms stores answers in a list or an Excel sheet, but managers, clients and auditors often want a document they can file or forward. People end up copying answers into Word and exporting PDFs by hand for every job application, intake form or inspection report.
Power Automate has no simple free action that turns form answers into a professional PDF, so this flow takes a few steps. A Compose action places the answers into an HTML template, OneDrive saves it as a real HTML file, the OneDrive Convert file action turns it into a PDF, and Outlook sends the PDF as an attachment.
I use a five-question job application form as the example, and ChatGPT writes the HTML template so you do not have to write HTML by hand.
What you need
- Microsoft 365 Business Basic or Standard (no SharePoint, no premium connectors)
- A Microsoft Form (the demo has Name, Email, Position Applied For, Years of Experience and Why Us)
- OneDrive for Business with two folders, one for HTML files and one for PDF files
- ChatGPT or another AI tool to generate the HTML template
- An Outlook mailbox to send the PDF
Step by step
0 of 10 done-
01
Create the automated cloud flow
In Power Automate select
Create>Automated cloud flow. Name it (the demo usesJob Application PDF), search for Forms, chooseWhen a new response is submittedand selectCreate. Pick your form inForm Id. -
02
Get the response details
The trigger only gives you the response ID, not the answers. Add the Microsoft Forms action
Get response details, select the same form and setResponse Idto theResponse Idfrom the trigger. Now every answer is available as dynamic content. -
03
Generate a PDF-friendly HTML template with AI
Ask ChatGPT (or any AI tool) for a PDF-friendly HTML template for Power Automate, not a normal web page. The prompt asks for simple inline CSS, standard fonts like Aptos, and a table-based layout instead of flexbox or grid, because OneDrive's converter handles simple document-style HTML best. Include a placeholder for each form field.
Before using it, paste the code into a text file, save it as
pdf.htmland open it in a browser to preview the layout. -
04
Add the HTML to a Compose action
Add a
Composeaction, rename itConvert to HTMLand paste the code intoInputs. Find each placeholder (name, email, position applied for, years of experience, why us), delete it, type/, chooseInsert dynamic contentand pick the matching answer fromGet response details. -
05
Save the HTML as a file in OneDrive
Add
Create filefrom OneDrive for Business and rename itCreate HTML file. SetFolder Pathto your HTML files folder (the demo usesJob Application PDF/HTML Files).For
File NametypeJob Application-, addPosition Applied For, a dash, theSubmission time(underSee morein Get response details) and end with.html. SetFile Contentto the outputs ofConvert to HTML.The Convert file action needs a real file. It cannot read from Compose directly.
-
06
Add a short Delay
Add a
Delayaction withCount10 andUnitSecond. If you convert a file right after creating it, the flow can fail because OneDrive is not ready yet. The delay makes the flow reliable. -
07
Convert the HTML file to PDF
Add the OneDrive for Business action
Convert fileand rename itConvert to PDF. SetFileto theIdfromCreate HTML file.Target typeis alreadyPDF. The PDF now exists in the flow but is not saved yet. -
08
Save the PDF in OneDrive
Add another
Create file, rename itSave PDF fileand choose your PDF files folder. Use the same naming pattern:Job Application-, the position, the applicant name and the submission time, separated by dashes, ending in.pdf. SetFile Contentto theFile ContentfromConvert to PDF. -
09
Email the PDF as an attachment
Add
Send an email (V2)from Office 365 Outlook. Enter your address inTo, a subject likeNew Job Application Received - <Position> - <Name>, and a short body saying the application summary PDF is attached.Under
Advanced parametersaddAttachments. ForNameuse the file name fromConvert to PDFand type.pdfafter it, because that file name has no extension. ForContentpick theFile ContentfromConvert to PDF.To send a copy to the applicant too, add a second email action using the Email answer from the form.
-
10
Test the flow and tidy the template
Save, select
Test>Manually, and submit a test response. Check that every action succeeds, open the PDF in OneDrive and check the email attachment.If the PDF shows stray text that the AI added to the template (in the demo, extra lines at the top and bottom), delete it from the Compose action. Optionally add a OneDrive
Delete fileaction to remove the temporary HTML file.
Tips and common problems
- Convert file cannot read HTML from a Compose action. Save the HTML to OneDrive with Create file first, then convert that file.
- Add a 10 second Delay between Create file and Convert file. Converting immediately can fail because OneDrive has not finished saving the file.
- The file name from Convert file has no extension. Type .pdf after it in the attachment name or the recipient gets a file that will not open as a PDF.
- Ask the AI for inline CSS, standard fonts and table-based layout. Flexbox and grid do not convert well to PDF.
- Preview the AI's HTML in a browser before pasting it into Power Automate, and remove any extra text the AI invented.
Related builds
Questions
How do I convert Microsoft Forms responses to PDF without SharePoint?
Put the answers into an HTML template in a Compose action, save it to OneDrive for Business with Create file, then use the OneDrive Convert file action with target type PDF. Everything stays in OneDrive.
Can I convert HTML to PDF in Power Automate without a premium connector?
Yes. The OneDrive for Business Convert file action is a standard action and converts an HTML file stored in OneDrive to PDF.
Why does Convert file fail right after Create file?
OneDrive may not have finished saving the new file. A Delay of about 10 seconds between the two actions fixes it.
Can I send the PDF to the person who filled in the form?
Yes. Add another Send an email (V2) action and put the Email answer from Get response details in the To field, with the same PDF attachment.
