This video is about how you can save Microsoft Forms responses to customized PDF using Power Automate. This is achieved using custom HTML layout and writing some compose statement in Power Automate. watch full video to learn in detail….(read more)
Convert Word 2 PDF: Word to PDF Converter
Convert PowerPoint 2 PDF: PPT to PDF Converter
Convert Excel 2 PDF: Excel to PDF Converter
Convert an Image 2 PDF: Image to PDF Converter
Convert HTML 2 PDF: HTML to PDF Converter
More Tools: PDF Converter
Is there way to get information from form and generate a custom design pdf like certificate
How do you create the html file? I'm by no means a whizz this 🙁
Such a great tutorial! I would love to know how to keep line breaks in long answers that are submitted in the form. At the moment they are all coming through in one big paragraph.
Hi, This tutorial worked great for me! My question is what do you do if the answer is blank?
@LernenTech – This video is very helpful, however I am facing one small issue. The attachment in the email is not coming as a PDF. I have chosen 'PDF' in the 'convert file' step. Could you help me figure this out ?
Thank you. Such a great help!
HI PRAKASH…WILL YOU EVER POST SAME FOR QUIZ. THIS IS REALLY COOL AND I WANT SAME FOR MS QUIZ
Hi, do you knwo what te problem is if i get this replay: "Unable to process the template language expressions in the input for the Compose action on line 1 and in column 18784: The template language function Replace expects the first parameter string to be a string. The specified value is of type Object." by the first compose?
Really useful video – thanks. It's a pity that MS Forms doesn't have this sort of capability natively but you've come up with a great approach.
Hello:) Thank you for amazing solution!
I just wonder where in the flow above should I add picture/image to custom formatted pdf? After or before the conditions?
Thank you,
Kamila
worked well. thank you
Can you share the flow with us? Many thanks
How do you create the html pdf file?
I'm getting the following error message when I test out my first flow:
Unable to process template language expressions in action 'Compose' inputs at line '1' and column '22124': 'The template language function 'replace' expects its first parameter 'string' to be a string. The provided value is of type 'Object'.
The expression I am using is
replace(outputs('Get_file_content')?['body'],'{submitter}',outputs('Get_response_details')?['body/responder'])
What am I doing wrong?
I stuck in the Compose part Expression replacement. Can You provide detailed text information for this step.
Very clear and easy to follow. By the way sir, can I use this compose function if I want to change the text in my MS Word?
Hi! Firstly, thank you so much for this tutorial it was great and solved a lot of my head scratching.
I have been trying to work out how to get line breaks in long answers. I have done one compose (called NewLine) to decode the line breaks, which is – decodeUriComponent('%0A') and then another to replace the line breaks with a </br> which is –
if(equals(coalesce(outputs('Get_response_details')?['body/rabee45700d67405ba4cd6b4caa1cd3bb'],'NULL'),'NULL'),'',replace(outputs('Get_response_details')?['body/rabee45700d67405ba4cd6b4caa1cd3bb'],outputs('NewLine'),'</br>'))
That works but I can't work out how to incorporate that sort of code into the PDF layout.
Any idea or tips on how I can achieve this?
How to create Html file first ?..kindly could you tell me I am not getting
@ Lernen Tech
Awesome! Anyway to use this with a form that already has 50+ responses?
Thank you, this is perfect!
Is there a way to get the response of the form to go on to a pre-defined business letterhead and have that save as a PDF?
I’ve tried to insert a company logo in the HTML code via URL to the image so it looks like the company’s letterhead and it seems to work well right up until the PDF conversion stage. The final output of PDF just shows a broken image icon, I’m assuming because the URL for the logo isn’t recognised.
Do you know if there’s a better way to do this? Thanks again!
Is there any way to get a hold of you for some help with my flow? I can't find a website or contact info
I'm your fan, and this is a great tutorial as usual ! I'd like to know if the form content is in Thai (or any Non-Latin languages), how to display the content correctly ? Actually it turns question marks (??????????) for Thai language.
May I know how and where can I get the PDF-Layout. html?
This is exactly what I need, thank you!! However, I get an error when I try to do the replace function at the compose step stating 'the expression invalid' – any ideas why this could be?
All worked perfectly, but questions where we have radio buttons it doesnt shows the value of text in answer, what shud i write in the replace query
Huge Huge help my friend. Thank you for sharing your knowledge!