PowerApps PDF Generator using Microsoft Flow PDF Converter 

Stop apologising about the video length, I am always happy to see the enthusiasm and passion of your learnings. The more, the merrier! Awesome video again, Shane, great job!

I have watched countless hours of CS and coding tutorials during my education and career, yours are by far my favorite. These PowerApps tutorials are an absolute lifesaver. Thank you!

Just started working with Powerapps and Flow. Thanks to your videos I achieved a great progress.

Shane! Just by watching your videos I was able to program a power app to track absence times of our students. All teachers can now work together in that app and it saves them a whole bunch of time (AND PAPER!!). Thank you so much, rock!!

Good video, it really helped for my first application. A few things I learned along the way: - I used the "Compose" step to make the HTML more readable instead of directly entering it in the "Create File" step. - If you can store the data you want to print in a Sharepoint list it makes it a lot easier to include dynamic variables in your HTML

"That took me...[Briefly reflects what day is it /damn I need to shower and sleep] I don't wanna talk about it." Nice work dude

I wish I could like this video twice. I was jumping and down with you when I got my company logo and my own custom power apps data out there!

"You can choose any option you want, as long as it's PDF...Because that's the only option you have" :'D

my superstars to follow used to be Roger Federer, Guns N Roses, Tool, Megadeth, now the rockstars for me are Shane Young and Reza Dorani. Thanks, that´s just what I needed

Great video. I know I was struggling but I've learn a few things about a few limitation to take note of when desiging your html files for pdf conversion. 1. No flexbox or grid support. 2. Overflow doesn't work. 3. Body width has a max I've found 600px to be the sweet spot.

Shane, thank you so much for this and all the great videos that have made Power Apps truly accessible to me in my job. I was able to use a "Get Row by ID" function in the flow, add its output to my HTML, and get dynamic values from Dataverse (even LookUps) to populate in my PDF. Now I can export a PDF with all the Dataverse record's fields. So cool, and useful. Cheers!

Another great informative video. Top tip for avoiding having to do all that hard work with the concat expression in the single line editor... if you initialise another variable of type string and put all your HTML text in that, it is way easier to maintain and you don't need to concat any of it. Then you just drop the variable into the FileContent of your OneDrive Create File action :D

I thought my enthusiasm for learning powerapps was weird. I feel you, bro. GREAT job, as usual. Thank you for your effort!

Hi Shane, just wanted to thank you for posting this video. I used your method for inserting a picture, except I tokenized the hmtl and then used replace() to add all of the pictures and elements. You're the best!!!

Hi Shane, Fantastic Video as usual. The length was necessary to convey each step with enough detail. I especially appreciated the Button to test the Flow. Looking forward to the next Video! Thanks.

Awesome video Shane. Really does open up a lot of possibilities. One thing to add though, you can convert a word document to HTML which comes in handy when designing your document and then only needing to tweak a few things rather than having to write it all from scratch.

Shanne you are awsome, you just can't imagine how much time you made us save. Please keep posting videos!

I love your enthusiasm! So in the end, you were able to insert only one input (the 9 cups of food) how would we make it to submit dozens of inputs in a table or form that I am making? Almost like an application to enter a program? Thank you appreciate any feedback!

Hey Shane, This was the missing link in a solution I am building for my schools (I help look after a whole district). You sir are awesome!!! You should set up a Patreon Page. I for one would support you.

Thanks Shane. Had a customer the other day that wanted this and u solved it for me so easy. Thanks

OMG you're a hero !!! And this Concat function is just perfect

thinking you were making this video in 2018... Awsome , thank you a lot for the sharing

This is a great video thank you, Someone mentioned you had a way to also convert to Word? I need to create a dynamic template document based on Power Apps data/SharePoint. So looking to build a complete formatted word document in html with dynamic tables and then convert to Word. It seems easy enough in theory, but why is there no html to Word option - this seems more useful then pdf. Appreciate you thanks.

Great tutorial, thanks! Would you know how to turn left the pdf page?

You are awesome Shane. I love your videos!

Hey Shane, Great work as always. Did you find a way to right justify last column (numbers) ???

Great video once again Shane! I have a use case for this exact process; however, I need to embed the possibility of word, pdf, and jpgs. Any advice for this process with word or pdf docs?

Brooo... Thank you so much for making our lives easier! This is very helpful!

That is a great tip Shane, thanks for sharing! Just a little question, how would you handle multiple variables?

Hi Shane My name is Marco and I'm writing from you from Sydney Australia. Firstly I want to thank you for these videos! I watched them all over and over again and I learnt powerapps. I use your techniques in my apps that I am creating. I watched this video many many times and the way that it converts a HTML to PDF using flow. My big dilemma is that my html is Landscape and Onedrive does not convert the landscape HTML to PDF. Would you know what I have to do ? Anyway Shane I appreciate everything you have done for me and thank you so much. Ciao Marco!

awesome, it works, any chance i could get certain parts of the html to pdf to print out instead of the entire portion based on drop down selections inside the app? or is that too much?

Thank you Shane, this is really helpful and easy to follow.

Once more, great video! I also must say that ive just started using Powerapp and your videos have been great as I dont know coding... Thanks a lot!!!!

Hi! All of your tutorials have been so helpful! Your presentation style is also the best I have seen and makes it much easier to understand than some of the other PowerApps videos on RU-vid. I have a question -- I'm using CSS in my HTML (not a lot, just adding some color to the tables mostly). When I use Flow(Power Automate) to convert to HTML, the HTML file looks right. But when it converts the HTML file over to PDF, the PDF no longer has the CSS formatting in the tables. Any ideas?

Good video Shane. 1 question regarding the HTML code using the TriggerBody expression: why did u use the 'CreateFile Filename' syntax in the td cell?thx

Hey Shane, awesome tutorial as always! Hope you don't mind me asking how would I be able to send the data I made in your repeating tables (gallery items and collection) into this PDF file? I'm kind of stumped how to do that, I feel like it's a get item from that library where the master ID = ID of that form, and I'll need to do a loop (for each) but I don't know how to put all of that in to the HTML you did. Any ideas?

Perfect timing. I was trying to figure out how to do just this. Thank you so much! Is there a way to save the PDF to a different name, based on an entry? What about a print button to print the created PDF right from the App itself?

THANK YOU!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!! I was just trying to figure this out myself. You just saved me a TON of time!

Awesome! Can you loop through a collection or gallery to display into an HTML table?

Shane you are awesome! I've learned so much watching your videos. I'm currently working on this PDF conversion and have everything working, except figuring out alignment. My html included center aligned headers and tables, but everything gets left aligned in power apps. Any thoughts? Thanks!

It’s like you knew that I needed this video in my life :-)

Thanks so much- great video as usual Shane! Is it possible to use Rich Text fields without getting square characters at strange places in the pdf (mostly at the beginning of a line)? There's actually one in the middle of a word which I can't figure out. I don't see it even when looking at the native html via a label. Also do you know of a good explanation (video) of how to Email a file (pdf) as an attachment from a SharePoint library? (The second step of the operation) Best Regards, Paul

Hi Shane, First off thanks for the videos they've helped out tremendously. However, any suggestions on how to pull an image into the dynamic content flow in the above video? Appreciate the help!

Hi Shane! this video was so helpful. I am able to create the HTML but when I convert to PDF and open the file I get a message that it doesn't have a preview and similar message when I download it to view. THANK YOU SO MUCH!

Hello Shane - Great video! Thank you so much for all the videos you put up, helps a lot!!! I have a question, I have a rich text box which our end users want to add image along with the text (not always and not the names number of images). What can I do in this situation?

Hey Shane. Great video! Do you have a video (or other resource) on sending more than one value from PowerApps to Automate, to be able to then insert them into separate cells in the table (for eventual conversion to PDF)?

Awesome video Shane, thanks. FYI I needed to look at the HTML a different way as I need data from sharepoint. All is good until I do the PDF. I use Compose -Select and Compose-Create HTML to setup the file. When I run I get no errors, the HTML output opens up to show I have the table OK, but the PDF output simply shows all the code as text not as a table as desired. I found I had to add concat('',outputs('Compose'),'') in order to achieve the proper output. All I need now is to set the PDF to Landscape as my table is too large (any ideas)

Hi Shane, I love it your video ...still my flow is not working but I could do it. Thanks for share yours knowledge. Thanks a lot.

Shane your videos are AWESOME! They have helped so much. I have successfully gotten this to work - the picture since there is the bug. The one snag that I am running into is that I am creating a button in powerapps to start the flow (like the video) and then a popup in powerapps that provides a web-link to the file. It works fine for me but when someone else uses it the flow creates the file in their personal one drive folder and not the shared one drive folder that the link opens. Do you have any ideas how to get this to work?

Hey Shane, Great video's I'm a big fan. Quick question how would I get multiple text inputs into the PDF. Example you've done it for chewys cup amounts for Tuesday but how about Wednesday Thursday and Friday.

Hi Shane, Great stuff I really get a lot out of your videos! Is there a limit to the amount of HTML you can put into the concat function in a flow? I have a one page doc worth of HTML and it looks to be fine but flow will not take it.

Great Video Shane! One question though, how would you send multiple feeds back to flow for the HTML from PowerApps. In your case, you had one field you sent through, what if you want to dynamically add another line to that grid for the next day with all 3 it's values coming from PowerApps input. Thanks.

thank you so much!!!! all your videos are very helpful .. but my questions is if exist a way to create a PDF file in landscape view??.

Hi Shane, I have been following your videos and are very helpful. Just a quick question, have you figured out a way to send a link back to power apps so we can download the created pdf from the App?

Dude you are the best! You make the learning process easier and enjoyable. keep the hard work!!

Anyone looking for a low tech work around can try this 1)On your powerapps screen select the gear icon and choose fit to screen 2) right click and choose print 3) choose save as PDF, then edit the layout 4) click the more Settings and choose the paper size and scale that will best fit your screen 5) uncheck headers and footers ( to disable all the annoying text and dates that will appear on your page from web printing) 6)check background graphics ( to show all your logos and images) Then just save the file and you now have a perfect PDF replica of your screen. Hopefully this saves someone the endless hours of frustration that I had to endure trying to print to PDF

Amazing video super helpful! One quick Q - after creating the PDF, is there anyway to have it automatically open for the end user?

Hey Shane, your videos are a real life-saver, thank you! I built a Flow just like in your video, but the PDF part of the OneDrive connector is still in Preview state (and probably will be forever) and my IT department wont let me put this into production. I looked into 3rd Party connectors, but we cannot use them because they're mostly American companies who dont comply with GDPR (PDF will contain sensitive company data). I'm now building an Azure Function which does just the same, what a hassle!

hi Shane, that's a great knowledge. What if I want to only add all choosed buttons or entered text WHEN send button is clicked? For example I have 4 buttons where person can choose and option and two text fields where he can enter some details.

A.M.A.Z.I.N.G !! saved me hours of endless training, forever grateful ;)

Great Video! Got a new subscriber. I'm running into an issue tho. Lets say two different logos need to be displayed in your demo depending on a Boolean. How would I go about doing this?

Hi Shane, your videos have enabled me to produce a few apps and flows and my work colleagues think i'm amazing! The problem I have is with the image process in this tutorial in that I do not have the option to add dynamic content and then the option to add a function (fx). Instead I get blue (OD) and Purple (flow) icons with text. These are similar because if I hover the OD icon/text I can see it refers to "body('Get_file_content')". I suspect i'm using a different Sharepoint version, but would I still need to input dataUri( before the blue OD icon/text? I've tried with and without but cannot get the image to show. Thanks in advance!

Hey Shane, This video is very helpful.My question is this can we also generate power point slide when a new item is created?

Hi Shane, Thanks for the awesome video. It's very informative. However I'm struggling with the convert pdf function. I'm using a grid format for my HTML code. Everything shows up properly when looking at the .HTML file that is generated through power automate but the PDF looks wonky. It would seem that it doesn't recognize the CSS? I've tinkered around quite a bit with this and it seems that tables are the only that that formats well. Does the PDF converter not work well with CSS? Thanks again, your tutorials are the best.

This video was super helpful! I used to to in an approval flow, so the approval could quickly view a collection (based on a shopping cart). I would like to take the approval flow a step further and, if approved, create a SharePoint list entry with columns for Item Name, Quantity, Campus, Cost. I have all of this info in a collection, and in an HTML control that I used to create the PDF. Is there a way to use that information to generate a SharePoint list row?

Hey Shane, Great video. I wanted to know if there is any option to write more fields to PDF SharePoint? Currently you have one field in PowerApp as an example and my requirement is for 26 fields. Any tip would be helpful.

Hi Shane, A lot of really good stuff!!! I have a question: I really need to have a word document in a SharePoint document library converted to PDF. Can you build out such a video or describe what if at doable must be done for that? Thanks in advance!

Thanks you! Nice video for starters!! In the example we are sending only one field value from PowerApps to flow. What if we want to send multiple field values from PowerApps to flow, how do we refer to those different values in the HTML.

Hi Shane, Great video! I have followed your steps to make multiple different solutions for my company. I have noticed that there are many html style options that work when using the W3 Tryit Editor, but do not work once the HTML is put into the Flow. Do you know why this is? Does flow use it's own HTML compiler that has a different library of actions? Thank you.

great video! thanks so much for explaining every step! Great job!

Hi Shane. Great videos! What is the best way to merge two pdf files using flow and or power apps?

Hey Shane, Great video with lots of solid information! I had a quick question about the flow. I am using this for a rec form, so the form saves to onedrive of the user who is submitting the request, what would be the best way to move this pdf to the SharePoint team site I need it to be located in? I have been researching and cannot find a definitive answer or solution. Any help will be greatly appreciated!

Can you skip the HTML and send your collection into a table in an Excel template, then convert that Excel file to PDF?

Hello, Shane. Thank you very much for all of your videos. They are awesome! I am constantly telling colleagues interested in PowerApps to check out your page. Question for you, I am following along with your video and the flow expression is working just fine until I paste in the PowerApps trigger syntax, then I get a "The expression is invalid." error. I even checked the expression with the ' , ' as you do in the video. The syntax is copied and pasted directly from Flow (as you do with everything after the "x"). Any idea what can be causing this?

THANK YOUU AGAIN! I've been having such trouble trying to combine powerapps and flow. Nothing is ever too simple - is it? :')

Thanks for your wonderful video, I got a lot of knowledge from your video. And for this topic, I have two question . Could I create file in SharePoint at first step when I create HTML context file？ But I founded that there is no method to convert file to PDF from SharePoint directly, So if an apps need some people besides me to edit and generate a PDF file in SharePoint, where need to create html file at first? One drive only for personal I think, other people couldn't get access to edit. Could you give me some suggestion? The other problem is when I make a declaration for html file language is Chinese, but after file generated to PDF is mess code. So whether "html text "couldn't support Chinese language in Power Apps? Thanks a lot.

Great video, I'm learning a lot from them. My question is if I can generate the PDF in landscape mode? Do you have any idea that the htmltext of powerapps does not accept css?

Hi Shane thank for the video. I've tested this in our environment and it works very well. Is it possible to print 2 related SharePoint lists in one PDF, on one I want to pull the master data and on the other one I want to pull the details. Thank you

Thanks shane this was just what we needed and was really easy to consume. Just out of my ignorance, how to handle if we want all the records in a gallery like repeating table to be printed? I have tried by passing the variables to run the flow and it is only printing the last record in the gallery. can you please shed some light?

Thank you for the video. Everything works like a charm when I am logged in as the user that created the flow. The base files (logo, HTML, pdf) are all saved in the Share with Everyone OneDrive for Business folder. When I run the app/flow using a different account the flow fails on the getting the image file for the logo - says the resource cannot be found. That would be a permission thing right? But the file is in the Shared with Everyone folder and appears to open to all. Heck, I think they can even edit it. So, what am I missing?

Hello Shane! It's awesome all the work you're doing for us, thank you!! I wanted to ask how the procedure would change if I have different inputs for the pdf, for example a pdf about a cart from a marketplace. In my project I'm trying to generate reports for every business that's associated with any of the items in the shop cart and filtering the products for each report as needed, thing is as difficult as it hears o not that much?? Thanks in advance!!

Hi Shane, Very nice videos I watch them all. Was wondering if you knew of a way to have the powerapps image pass through to flow and render properly on the pdf? I have several powerapps and flows generating reports but I cannot get the image to pass through. It shows in the HTML text box in my powerapps but not on the converted PDF. Any insights would be most appreciated. Thanks again for all of the great videos

This channel is so helpful!! Thank you.

Hi Shane, I am really loviong this series on PowerApps and Flow(Power Automate). However, I am seeing a lot of differences between your version, produced in 2018 and the PowerApps version out now (in 2020). One thing I cannot find regarding the PDF flow video, is what is the new name for the "Ask in PowerApps area and I also could not find the CreafFile_FileName variable either. Was it removed? Thanks!

Excellent tutorial... Any ideas on how to rotate the PDF orientation? (defaults to Portrait, need landscape).

Shane, thank you so much! One question and it may sound silly, is there anyway to include a CSS with this? Or any sort of styling rather than HTML?

Yo the trick to get the expression value got me out my chair like no waaaaaaaaaaay! nice one Shane! I was always a hover and type kind of guy! Not anymore!

Shane, you are a saviour! Happy new year :)

Hi Shane As per-usual a great informative video helping people like me :) Just a quick question i use a HTML template with {holdertag}s utilising individual Compose functions and Replace expressions. How do you add an image utilising this method?

That was worth watching, very helpful....

Hi Shane, great work as always and great video, but I have a question, how can I send the generated PDF to an email? Thank you.

Hi Shane, Thanks so much for the great video. I had one question Is it possible to download a bunch of monthly bills in pdf from a legacy system in bulk, split them and send the same as attachments to the respective customer on the bill. Regards,

Really helpful vid, thanks. I've used the trick of creating string variables to pass DataURI(file content) to HTML using Concat, which I'm then using in the body of an email to show a fancy logo. The final email renders beautifully in Outlook and in my personal webmail client, but not in Gmail. Would you have any idea why that might be?

Great video very useful. Just one question, am I able to convert SPO list to PDF. Thank you.

Another great useful topic...there are many times I need to create a dynamic filename (like with the date) and I am sure I could use Variable to create a string formatted the way I need and then Concat() to the rest of the filename.

Hey Shane, another awesome tutorial - have you found a way to use a web hosted image asset within the output PDF? It displays fine in the HTML generated but then errors in the PDF.

HI Mr Young, thank you so much for your teaching to us. Is that you mean that a traditional HTML file with embedded jpg, png, docx. to PDF? and even using tag to display outlook email content in HTML?

Excellent video content, easy to follow, great concept. I did, however, find what I believe to be a character limit on the expression field. I don't know the exact number, but my initial html code was too long to be valid. I did, eventually, get it to work after tinkering & removing several lines of code. Looking forward to more videos on PowerApps.

Hi Shane, that`s a great video as always, thanks a lot !!! 🙂 In your example you`re passing only one information/field (= 9 cups) from Power Apps to Flow/Power Automate. How does the VideoMakePDF.Run(XXXXX) expression needs to look like if i want to pass multiple fields and how can i reference/select the various variables in the HTML code via the triggerBody() expression in Power Automate then? Thanks in advance.

@Shane Young, two years later ago you posted this video and I'm learning it now! :)