Unanswered

How to generate a PDF from Microsoft Forms and get it sent to an email address

(3) Share

Report

Posted on by Community Power Pla...

Hi guys,

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?

Categories:

General topics

I have the same question (0)

All responses (20)

Answers (0)

v-bacao-msft on at

Like (4)

Report

Hi @Anonymous,

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.

Image reference:

The contents of the attachment are as follows:

Please take a try.

Best Regards,

Barry

Was this reply helpful? Yes No
GregorS 5 on at

Like (1)

Report

Hi,
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?

Was this reply helpful? Yes No
Community Power Pla... on at

Like (4)

Report

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.

Was this reply helpful? Yes No
luc0ne 11 on at

Like (0)

Report

ciao, can you post the solution with screenshot.. i have the same problem and i cannot create pdf from microsoft forms
thank you.

Was this reply helpful? Yes No
Jay-Encodian 2,920 on at

Like (1)

Report

There are quite a few options for this. I'd recommend using our 'Populate Word' action to add the Microsoft Form data into a word template and then convert the document to PDF with the 'Convert Word' action, a good example is provided here: https://www.encodian.com/blog/mail-merge-a-word-document-with-a-microsoft-forms-response/

This following article details how to convert a Microsoft Form response direct to a PDF (or Word Document) using the 'Convert HTML to PDF' or 'Convert HTML to Word' actions, but you will need HTML skills to do this: Convert Microsoft Forms Responses to Word or PDF Documents

Finally, if you need to also add any files submitted along with the Microsoft Form response to the PDF document then check out: Handling files provided in a Microsoft Forms response

HTH
Jay

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

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.

Was this reply helpful? Yes No
Jay-Encodian 2,920 on at

Like (0)

Report

@Anonymous

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

HTH

Jay

Was this reply helpful? Yes No
ashleylcruz 3 on at

Like (0)

Report

Do you have a screenshot for your flow, you can provide for this?

Was this reply helpful? Yes No
AndyElliott 2 on at

Like (0)

Report

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.

Was this reply helpful? Yes No
CFernandes 8,402 Most Valuable Professional on at

Like (0)

Report

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-power-automate-2-0/

Was this reply helpful? Yes No