Unanswered

MS Form to PDF to Email

(0) Share

Report

Posted on by agnbaker

I would like to use MS form to ask my need questions, then put those responses into a PDF doc, which can then be emailed to my service group. All idea are welcome

Categories:

Building flows

I have the same question (0)

All responses (4)

Answers (0)

Sort by

v-xida-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!
Hi @agnbaker,

Do you want to put those response into a PDF file and then send it to your service group as an attachment file?

I have made a test on my side and please take a try with the following workaround:

Add a "When a new response is submitted" trigger.

Add a "Apply to each", input parameter set to output of the trigger.

Within "Apply to each", add a "Get response details" action. Then add a "Create HTML table" action, From set to output of the trigger, Include headers set to Yes, Columns set to Custom:
Add a "Convert HTML to PDF" action of Muhimbi PDF connector, Source URL or HTML field set to output of "Create HTML table" action.

Add a "Send an email" action, Attachments Name field set to Response.pdf and Attachments Content set to Processed file content dynamic content of "Convert HTML to PDF" action.

Image reference:

The flow works successfully as below:

Best regards,

Kris

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

Like (0)

Report
Copy link

Link copied!
Hi Kris,

Thank you for the response above. Is there a way to create a PDF that looks any nicer? When I create the table with all responses, they all come out horizontally and it ends up being really small font and the PDF has only one row filled up and the rest is white space. Is there a way to create the table so that it lays out vertically?

Hannah
@v-xida-msft wrote:
Hi @agnbaker,

Do you want to put those response into a PDF file and then send it to your service group as an attachment file?

I have made a test on my side and please take a try with the following workaround:
Add a "When a new response is submitted" trigger.
Add a "Apply to each", input parameter set to output of the trigger.
Within "Apply to each", add a "Get response details" action. Then add a "Create HTML table" action, From set to output of the trigger, Include headers set to Yes, Columns set to Custom:
Add a "Convert HTML to PDF" action of Muhimbi PDF connector, Source URL or HTML field set to output of "Create HTML table" action.
Add a "Send an email" action, Attachments Name field set to Response.pdf and Attachments Content set to Processed file content dynamic content of "Convert HTML to PDF" action.

Image reference:

The flow works successfully as below:

Best regards,
Kris

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

Like (0)

Report
Copy link

Link copied!

I have created a similar blog post.

https://clavinfernandes.wordpress.com/2019/01/29/convert-response-from-microsoft-form-to-pdf/

With regards to Formatting, in Muhimbi "Convert HTML to PDF" action you can create Tables using HTML tags (sky is the limit when it comes to HTML).

Was this reply helpful? Yes No
Gowtham Reddy 56 on at

Like (0)

Report
Copy link

Link copied!

Hi @agnbaker ,

You can create a HTML file and use Concat to add your dynamic content save it as HTML and then save it as PDF.

The video here might help you.

https://www.youtube.com/watch?v=2rfAQe1kK8M

Regards,

Gowtham

Was this reply helpful? Yes No