How to Create PDF from Microsoft Form using Power Automate

[@Leigh-s8q1j]

Would be very helpful to show exactly how to orientate the table vertically

[@Trippitaka2]

This is a while old, so I don't know if you will still be looking at it. There is a step where you add "Compose" and you create an expression which looks like replace(body('create_HTML_table')... I don't see how you made that. It is as if it suddenly skipped a few seconds and that expression appeared. Anyway, I paused the video and just typed in the expression exactly as it appears on screen for a second. The problem is, once I come to test the flow, it fails at this point, and the error message it gives is just mumbo jumbo to me. I have tried to do it different ways, but I always get an error. I am hoping you, or someone, can explain that step a little.

[@גליתמרדכי-נ2כ]

Hey, i did everything you show but i stuck on step 3 select(createArray()). there are no dynamic content. what could be the reason? i did the second step form id and response id. please help

[@joetteunks7071]

Thank you for breaking this down for me!

[@TSInfoTechnologies]

Any time!

[@corylazenko1276]

This video is great but as a newbie.. I am struggling with the gap at 8:07. I keep getting errors.

[@_whodisdude]

me 2 , did you find a solution?

[@Trippitaka2]

@@_whodisdude Me three

[@carlhollier9182]

I found this video very helpful. I was able to generate the file successfully. However I would prefer to have a table with 2 columns with the MS form header info in column 1 (vs row 1 in your output) and the forms data in the second column. Not surprised as I am using the HTML code provided in the Compose step (replace(body('Create_HTML_table'),'','')). How would I change this code to create the table I described (i.e., transpose the output from your tutorial)?

[@jethrokwaghkar2892]

Hi Carl, please share the HTML code for the Compose step. For an unknown reason I am finding it difficult to get it right.

[@EdHohlbein]

GREAT job! This video was so helpful! Thank you.

[@TSInfoTechnologies]

Glad it was helpful!

[@Aessidhes]

Thank you, this was so helpful. I do have one question. How do I change the format in the PDF so the question and response are horizontal. Currently they are vertical.

[@_whodisdude]

good q

[@abangaabanga4677]

Good guide but I am struggling to understand how you placed Inputs Expression Under the Compose Flow i.e. replace()

[@TSInfoTechnologies]

Hi, Thank u for showing us interest. I have used the below expression in the Compose's Input to give a border to the converted HTML table. replace(body('Create_HTML_table'),'',''). You can follow www.spguides.com/power-automate-create-pdf/#Power_Automate_create_pdf_from_form for the theoretical tutorial.

[@nicolasmoya1902]

@@TSInfoTechnologies Hi! Can you please help with changing the format in the Pdf file, so the information appears in vertical? My form has too many questions

[@PKCKMK]

The PDF file doesn't show the border. Any suggestions?

[@Rimjeet9564]

Can i replace the data from to Microsoft forms into tamplate

[@ahadpalwala7145]

I did all the steps and it worked for me however my form have 38 questions and in this format it does show only 5-6

[@alexisperez-gonzalez8988]

Yes, I am facing the same issue at work. Did you ever figure it out?

[@allensaborio6365]

Hello The contribution you give us is very great. I had a question, regarding the pdf format, how can I make the information appear in a vertical orientation in the "REPLACE"

[@quotesdaily2023]

Same question.

[@mannykhan7752]

@Allen Saborio when you are creating the html use "" to insert line breaks after each line and be sure to end them with . You can even use " and " to put them a paragraph apart.

[@nicolasmoya1902]

@@mannykhan7752 that means that we have to repeat what we did in the "Select" step?

[@mannykhan7752]

Not exactly the most efficient way to convert to PDF. The HTML could use a bit of work to make it more vertically oriented, there is no need to use the createArray() function and afterwards, you need to clean up the temporary html file by using the "delete file" action. Overall not a bad video.

[@TSInfoTechnologies]

Hey, thanks for sharing your thoughts.

[@lanemoreland9087]

Any suggestions to make this more vertically orientated?