Does someone know the flow to generate a PDF file from a Microsoft Forms form's responses and get that file sent to an email?
You could use OneDrive-Create file to generate a pdf file with the file name suffix ".pdf".
Then use Get file content to get the file content and send it as an attachment to the message.
You could consider configuring Delete file action at the end, because the process of creating file is just a transition here, you could delete the previously created file.
I have made a test on my side and the flow works well.
The contents of the attachment are as follows:
Please take a try.
I have a problem with this soluition. I exectly build it like you did. But everytime I recieve the E-Mail it is only 1kb big and it is not possible to open it with Adobe Acrobat Reader or the browser. Do you know what the problem could be?
This solution didn't work for me, either, but I used it as a starting point for one that ultimately did. Rather than making the pdf with the "Create File" function, which wasn't able to generate a properly encoded PDF for me, I had it create an HTML file instead. That way I was able to format everyhting exatly the way I wanted using CSS. After that, I used the "Convert File Using Path" function to convert it to a PDF and attach it. That was able to make a pdf that opened fine in Acrobat reader, although at times it didn't play nicely with previewing in Outlook.
This may be of interest... provides some detailed steps/ guidance: https://blog.encodian.com/2019/08/building-word-documents-from-microsoft-forms-responses/
Can you please share with me how you made the CSS work ? I have tried but it does not apply the CSS rules. It even removes some text formatted with CSS.
I assume you're using the OneDrive approach? The OneDrive connector doesn't provide full CSS support... can you share your HTML and I'll take a look
I've done it a slightly different way. Not very sophisticated but it's worked for me.
I completed my form myself.
Then I went back in and went to review it and then selected print response.
Rather than print, I saved it as a PDF
Annoyingly, this gives you all the answers so I then had to highlight all, copy and paste into word and then go through and delete the irrelevant info before re-saving it.
You can use Muhimbi PDF Converter to Convert responses from Microsoft Form to PDF - For details see: https://clavinfernandes.wordpress.com/2019/01/29/convert-response-from-microsoft-form-to-pdf/
Muhimbi PDF Converter also support Print Specific CSS, so you can also create\mimic you form layout, for details see: https://clavinfernandes.wordpress.com/2020/08/04/convert-microsoft-forms-responses-to-pdf-using-powe...
You can also do this using the out-of-the-box OneDrive connector, without the need for any third-party connectors in your Power Automate workflow.
The OneDrive connector allows you to create a HTML file containing your MS Forms responses and then convert it to PDF.
If you want more info, the steps are documented in more detail at the below link.
1. CTRL + P to open the Printer dialog box.
2. Scroll left in the "Select Printer" window and select "Microsoft Print to PDF".
3. Click Print.
4. Type the filename.
it seems to me that Convert Microsoft Forms to PDF or Create a PDF file from Microsoft Forms responses are quite wide-spread issues. There is one more way how to do that with the help of the Plumsail Documents connector for Power Automate Flow.
There are detailed instructions for various scenarios on the Plumsail site:
Note: this is a paid solution. But there is a free one-month trial.
Hi, I am trying this but whenever I run the flow, it errors saying that the file content cannot be null or empty. Any idea what is causing that? I followed your guide on your link.
Check out the News & Announcements to learn more.
Check out the new Power Platform Community Connections gallery!
Congratulations, the new Super User Season 2 for 2021 has started!
Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.