POWER AUTOMATE FLOW - CONVERT MS FORM TO PDF & SEND VIA EMAIL

This topic is quite old but I decided to post because JDeeb mentioned that he had troubles with converting to PDF using the OneDrive connector. In fact, Damien_Rosario already suggested the solution here but I would follow up his answer with some screenshots and optimized flow structure. Also, I will suggest an advanced solution at the end of my reply.

So, here is the flow I would suggest.

1. When a new response is submitted.
   
2. Get response details.
   
3. Create an HTML file using the OneDrive connector. Its content can be provided as raw marked-up text. Apply the required formatting using HTML tags and CSS styles and embed the dynamic content from the submitted response. I used just a basic HTML structure.
   
4. Convert the HTML file to PDF using its ID.
   
5. Finally, send the converted file through e-mail.
   
6. Flow overview.
   
7. Here is a result file I received by e-mail.
   

Advanced form conversion to PDF

The solution above is good because it does not involve other paid products but it may be convenient not for all:

• it may be hard to apply the required formatting using HTML and CSS;
• HTML does not provide as much tools to build a document layout as text editors;
• it may be necessary to embed uploaded documents as well, not just text of responses.

To solve these and maybe other issues, it is necessary to use third-party tools. Other users already advised Encodian and Muhimbi ‒ I would add Plumsail Documents to those options. There is a detailed guide accompanied with a video instruction showing how to convert Microsoft Form responses to PDF. Though, the last step in the suggested flow is saving the PDF file to a SharePoint library but it can be easily replaced with the 'Send email' step I advised above.

Hi, I use the "Muhimbi" Connectors "Convert HTML to PDF" action to Convert Microsoft Form's to PDF.

In the above screenshot, I create an HTML and then insert the Microsoft Forms list fields in the appropriate places just before each line’s <br/> element.

For more details you can refer to my blog, https://clavinfernandes.wordpress.com/2019/01/29/convert-response-from-microsoft-form-to-pdf/

and if you want to Convert Microsoft Form's with attachment, see: https://clavinfernandes.wordpress.com/2020/01/01/convertmerge-microsoft-form-attachments-to-pdf/

Hi JDeeb 

It's probably failing as the OneDrive Convert file option is expecting a file to convert to PDF, of which Microsoft Forms does not produce.

If you have programmed something in your flow to convert the Form to a docx file, can you please screen shot it and show more of the flow (redact any sensitive info such as URLs)?

If you wanted to streamline your process as having the details in an email rather than a file, you could have a 3 step flow with the trigger to:

1. [Trigger] Catch the new form submission (When a new response is submitted)

2. Get response details

3. Send an email (V2) - where you add in the name for each dynamic attribute so that people know what each of the responses are called in the email.

Happy to discuss further if you want to show your flow?

Cheers

Damien