Developing Microsoft PowerApps - Exporting to PDF

[@ImranAmiKh4n]

Great tutorial - appreciate how you take your time to slowly explain things. What seemed complicated and daunting at first is now simple and straightforward. Thank you

[@rachelshalem]

AWSOME !!! The solution with the Gallery is brilliant. Thank you !!

[@A8OC]

Chino, I love watching your stuff. Your approach is so calm, and incredibly soothing. You seem to take the stress out of learning (I think the music helps too). Brilliant channel, thanks for everything you've published, it's helped me a lot.

[@ChinoDoesStuff]

Thank you so much for the love Tony! It's the fuel that keeps me making more content. Cheers!

[@AaronCalderonSr]

Hi, This was very informative and helped me solve a key step on a solution I am working on. One observation, when you are adding the steps of variable on the workflow, if you rename the workflow step, and then add the variable, it will use your step name to assign the variable name. This will be used latter when are coding the parameters to call the flow. And the parameters on the help text will be easier to understand. Thanks for taking the time to show the world how to create a PDF from PowerApp input.

[@ChinoDoesStuff]

Hi Aaron.. that is an awesome tip about the workflow step name first before creating the variable! Cheers and thanks for watching :)

[@sandrasitar5595]

This video helped me a lot! I've seen versions where html is placed in a variable inside a flow but this one with a screen inside the powerapp is much better (at least in my scenario). Thank you!

[@ChinoDoesStuff]

Thanks Sandra!

[@ChinoDoesStuff]

...and I should add... Of course my way is better!!!

[@ciprianfeier8306]

Nice, thanks. The best example for PDF

[@ChinoDoesStuff]

Cheers!

[@Acdihum]

Thank you so much about the quality of your explanations. Good job!!

[@ChinoDoesStuff]

Cheers Hayden

[@portlandmike]

This is exactly what I needed! Thank you so much for your help!

[@zeedu1]

Thank you, soo much!!! Super slick way to do it

[@ChinoDoesStuff]

Cheers Jose

[@enapier100]

Excellent solution! Works wonderfully. Thank you!

[@ChinoDoesStuff]

My pleasure Erin! I am glad you found this useful.. Hopefully you have subscribed and are exploring my other PowerApps videos! :)

[@RkP41]

Hi Chino - thanks for all your help. It was very informative.

[@ChinoDoesStuff]

Glad it was helpful!

[@tonya3308]

Great presentation. Exactly what I needed for a current project.

[@ChinoDoesStuff]

Great to hear!

[@kanchanabharath9261]

Very nice ,it will clear to understand.thank u so much

[@ChinoDoesStuff]

You are very welcome!

[@dominikkirchner1901]

The best Video about the topic I have seen!!

[@ChinoDoesStuff]

Thank you so much for your feedback! I'm glad it helped you out :)

[@daFrimpster]

I like your approach to this. Cheers!

[@ChinoDoesStuff]

Thanks Sam! I'm glad you liked the video.. hopefully you see equally enjoying my other videos in the series :)

[@premsai9908]

That's a great stuff thank you so much brother

[@DanielSarmientoPayares]

Thanks for sharing this information. It's very helpfull for me!

[@ChinoDoesStuff]

Glad it was helpful!

[@lameritaneta3757]

Great video, thank you for taking the time, love that you are taking the time to do it right. I subscribed to your channel!!!

[@ChinoDoesStuff]

My pleasure!

[@fredrik6504]

Thank you, great video and just what I was looking for!

[@ChinoDoesStuff]

Very happy to hear it help out!

[@kindumelese4335]

Hi Chino, It is really nice and helpful video, Thanks!

[@ChinoDoesStuff]

You're welcome! Thanks for taking the time to comment.. it really helps the channel

[@clasesdeoffice4574]

Excelente. Funciono Perfecto.

[@hmollien]

thank you for providing us your knowledge

[@ChinoDoesStuff]

Cheers!

[@woosaparker4536]

Definitely worth subscribing to your channel! This video has me part of the way to my goal, all I need now is to work out how I can include the data that is in a gallery within the gallery :/

[@ChinoDoesStuff]

Welcome aboard!

[@abuyotam]

Great Video, helped me so much. Thanks!

[@ChinoDoesStuff]

Glad you found it useful.. remember to like and share if you can. Really helps the channel :)

[@NKBobcat]

I've subscribed! Thank you for doing this. It helps me considerably!

[@ChinoDoesStuff]

Awesome, thank you!

[@derekmorriss]

great video very helpful thanks

[@ChinoDoesStuff]

Thanks Derek...I recently did an update to this video...not a great deal has changed but definitely worth taking a look... kzbin.info/www/bejne/lZ7KfYyioayMY7s

[@Johnwilkie77]

Fantastic video. You provided great clarity and ease of following. I have managed to get the export working fine thanks to your steps. My data source is an excel file which has numerous rows and each row has data pertaining to an individual. At present my PDF displays only the first row of data fields (presented in the Browse gallery). I assume it is the HTML I need to alter to have all records show in the PDF export but a little unsure how to do this. Any advice would be appreciated and thanks again for the great tutorial.

[@ChinoDoesStuff]

Hey John.. Sorry for taking so long to get back to you? Are you still trying to solve this problem? If so, the solution is to use the Concat function to build the body of HTML required for the table source (Excel). Embed this into your HTML control using '&' between the strings. Let me know if you need me to explain this further... :)

[@hendrawibowo5995]

Great video! is there any way to insert a fix headers and footers, so when printed as PDF, the headers and footer will be displayed on every page?

[@ChinoDoesStuff]

Hi Hendra.. So far I have not found a way to insert headers or even page breaks in the PDF exports.. Hopefully coming soon! :)

[@pipelox]

Hi Handra, how do you create a PDF from HTML with multiple pages?

[@jaredthrasher8059]

This video was a tremendous help! Now I just need to get better at HTML...

[@ChinoDoesStuff]

Your HTML should be looking awesome by now! :) Glad the video helped you out.

[@jaredthrasher8059]

@@ChinoDoesStuff Not really, came to realize that I can't match what can be done in Word. Have moved on to using the premium connector for populating a word template. Now fighting with getting images to come in through that... on top of having to start over from scratch on the whole app because they want offline capabilities. Not bad for a couple weeks into learning powerapps eh?

[@harrietscott9513]

Great video, thank you! Bit confused when creating the trigger button in PowerApps. It is asking me for Run(Initializevariable_Value, Initializevariable2_Value, Initializevariable_Value_1, Initialize_Value_2). Keep re-watching the video to see where I went wrong/what to put in here but can't figure it out!

[@ChinoDoesStuff]

Hey Harriet... Those values in the brackets are just the parameters that you use to pass values from your Power App to Power Automate.. let me know if that makes sense.. :)

[@harrietscott9513]

@@ChinoDoesStuff Thank you! All working now :)

[@ALLCAPS]

I ran into a problem: so when I see my .html version it actually has highlighted rows and other HTML things (NOT CSS) but when my pdf gets made, it's bare bone... and there aren't any highlighted fields--as there should be. I did everything you did.

[@ChinoDoesStuff]

Hey All Caps... I have noticed that there are some incompatibilities with some CSS formating between the HTML and what will appear in the PDF. Trial and error is the way I have managed to get stuff to work but some formatting just refuses to function unfortunately :(

[@househack.withme]

Very helpful! I'm curious if there's a way to download the PDF file to the local device directly without saving the content in OneDrive? Thanks!

[@ChinoDoesStuff]

You could always open it in another browser window as the final step.. effectively that is the same as downloading the pdf..

[@masterkeysolutions4444]

it's very clear and to the point . thanks exactly I got **html** file not **pdf** ?

[@ChinoDoesStuff]

My guess is that there is some html that you have used that is unsupported.

[@mariov.7817]

Excelente ejemplo!

[@ChinoDoesStuff]

¡Gracias por el cumplido!

[@waterborne4838]

Great video! Thanks for this!

[@ChinoDoesStuff]

No problemo! Glad it helped!

[@jhonatanorabadillo]

Great tutorial! An inquiry please. It happens that I have an app in power apps that brings information to a Sharepoint list through a form in which we also capture the photos as an attachment in the records of the Sharepoint list. Is there a way to take these photos (usually more than 2 photos per record) to a template in Word and then convert it into PDF (Currently, we are using the premium connector). Thanks in advance. Greetings,

[@ChinoDoesStuff]

Unfortunately, it's premium connector all the way if you want to export to Word (sad I know!). There may be a 'hackery' way you could do what you want to do without converting to Word so I guess I am challenging you to find one and share it here! Thanks again for watching and commenting, its really appreciated and helps to grow the audience :)

[@larsvanginkel3438]

Great method. Thanks! The fact that it is needed to use onedrive does that mean that all users using the Powerapp need a onedrive for business subscription? In my scenario a lot of users only have the Powerapps per App plan.

[@ChinoDoesStuff]

Hey Lars... Yes unfortunately because the "API" comes from One Drive it is required for the conversion using this method.

[@traveldirt]

This is very useful, thank you for posting this video. Quick question, I have around 4 screens in a canvas app that I want to convert to PDF having one screen per page, what would be the best way to achieve this?

[@ChinoDoesStuff]

TBH there is really no right or wrong way to do this.. well there might be some wrong ways but as long as it works and it doesn't get too complicated I say go for it!

[@541576]

Hi Chino, i have created the automate which connected with One Drive (for html) and SharePoint (for pdf file). I've also successfully run the flow using PowerApps. However, other user 365 with same organization unable to generate pdf. Appreciate you helps to solve this issue. I have posted this issue in PowerApps Community.

[@ChinoDoesStuff]

Ensure that users running the process have access to the SharePoint document library

[@littlemissfavored]

Super! Thanks for sharing - that's a great help

[@ChinoDoesStuff]

It's my great pleasure to have helped you out! Make sure you check back here this weekend as my next video coming up will show you how to include images in your PDF export!

[@christophegutierrez4974]

Thanks a lot for you clear explainations, that's help me a lot for my app project. Now i'm able to export to pdf into my onedrive. I just have a question, when i want to export to pdf an other time, it is erasing my previous export (or writting over the existing file), so how can i do to export another time without erasing ? By an automatic new filename for each export ? I hope you will have time to give me an answer. Thank you for your help. Best regards

[@ChinoDoesStuff]

Hi Christophe! Thank you for your nice comments its always great to hear about someone finding my videos useful. If you want your Flow to create a new file every time with little risk of overwrite you will have to add a unique value when passing the filename from PowerApps to Flow. In my example, at 21:20 I use the unique ID but if you wanted a new file to be created each time you could add a timestamp to the end of the filename string. Hopefully that makes sense. Let me know if you need me to clarify things further. Cheers and thanks for watching!

[@christophegutierrez4974]

Chino Does Stuff, hello, thanks for your quick answer. You gave me the key point to understand and to solve my issue. So, finally it is working. I followed your comment and instead of unique ID in powerapps, I wrote the expression : Now(). With that, each time i'm exporting to pdf, the file is named with present date and time. By this way, i always have a new filename and there is no more overwriting. Thanks a lot for your help. Best regards.

[@ChinoDoesStuff]

My pleasure Christophe! I'm happy that I was able to help.

[@justcoolthings]

Super helpful, thanks! PS. Without musics even better ;-)

[@ChinoDoesStuff]

Cheers and thanks for the feedback! Currently there is about a 85% like to dislike ratio for the background music.. I guess you can't please everyone all the time :)

[@DanielSarmientoPayares]

excellent video, one question... if other people use the powerapps app and press flow button, the onedrive files are created in their account or mine?

[@ChinoDoesStuff]

Hey Daniel! Thanks for the nice comment! To answer your question, files are created in the user's own OneDrive

[@DanielSarmientoPayares]

@@ChinoDoesStuff Thanks again!

[@DeepakGaur1]

This is very helpful , I am just stuck in one scenario though , can i show my image captured from camera control in HTML ?

[@ChinoDoesStuff]

Thanks Deepak! A while back I did a follow up video on how to include images in your PDF.. kzbin.info/www/bejne/mJTMdmxrhdV5jpY Should be easy to include images from your camera control. You may have to save them to One Drive first though!

[@GulamMustafa007]

Hi - This is a great video and I was able to successfully export to PDF. I do have one question - I am unable to provide line break between row items in a table. Are you able to help me out with this? Tried a few things but didn't work.

[@ChinoDoesStuff]

Hey Gulam... Unfortunately I also have not been able to get line breaks working.. Hopefully this will be supported in a future PowerApps update.

[@bobbigordon8678]

This video is AMAZING!!! I followed along, learned a little bit of HTML, and was able to create EXACTLY what I needed! Thanks so much. I do, however, have a question for another project. Given what you have taught me to do, wouldn't it be an easy task to attach a PDF form from to my Powerapps form, and save the PDF attachment to OneDrive, like I can the HTML doc that I created? I would think it would be simple, I am only bypassing the HTML steps... but I just can't seem to get it right!!

[@ChinoDoesStuff]

Hi Bobbi, glad you loved the video. At this stage, ( I like to always precursor statements with 'at this stage' as Microsoft are constantly changing and evolving this product!) you must save the HTML to One Drive so that you can perform the following One Drive action to convert it to PDF. If you don't require the HTML file you can always add an additional action to remove the unwanted HTML file. Cheers!

[@TheMathizze]

Chino, thanks a lot for your helpful video and clear explanations. I am able to create an HTML file which exactly shows what I want. 2 tables based on the same dataset (SQL db) but with a different filter. One table has 2 rows, the other has 3 rows as it should be. My Rich HTML textbox in PowerApps is also showing the correct data. After converting to PDF, it only shows the first row of each table and the formatting is screwed up. Any idea why this is happening?

[@ChinoDoesStuff]

My guess it's something to do with the formatting you've used. Try and do the export with minimal HTML styling and see if it changes the data that is rendered to the pdf. Cheers and thanks for watching!

[@TheMathizze]

@@ChinoDoesStuff Got it finally figured out. Took a closer look at the generated HTML and I noticed that my was missing a . The browser didn't mind but apparently the PDF did. Wasted several hours of my life... Thanks for your insights!

[@fussypuppy1952]

Thank you for the great video. How do I call the data in the combo box HTML Text?

[@ChinoDoesStuff]

Thanks! Did you end up working this out for yourself?

[@kittydoes7600]

This is great. Is it possible to export to ppt file as well?

[@utoroprincewill7808]

Hello, your video is topnotch, thanks for this. Just a quick question using exactly this your method how do I add logo to the pdf.

[@ChinoDoesStuff]

I have a video for doing exactly that! kzbin.info/www/bejne/mJTMdmxrhdV5jpY

[@utoroprincewill7808]

Hello Cool video. I have a question. In the Create File OneDrive Connector, Will file path folder be shared to everyone using the app who wants to print his/her data? because from what I see the onedrive folder looks like my folder. How does this work?

[@ChinoDoesStuff]

Hey utoro...glad you liked the video.. the One Drive connector always uses your own one drive so files saved and loaded from there always come from the user's One Drive. If you want to share exports, images etc then I suggest it might be better to save the exported file to SharePoint.

[@utoroprincewill7808]

@@ChinoDoesStuff Thanks for your quick reply, yes I agree with you. So I did use the onedrive to convert from html to pdf. As you can see and know, you cannot just connect and convert pdf and store into sharepoint without consulting onedrive (You can prove me wrong). So if this is the case, then it means any user need to somehow have access to the folder were the html will be before converting and creating it into sharepoint library. WHich brought up my initial question

[@ambujaable]

Great one

[@ChinoDoesStuff]

Thanks Ambuja! Glad the video helped.

[@abgmohdfakhriabgmohdmohtar3416]

Thanks for the detail guide. Really help me to get started with the possibility of auto generating reports. Was wondering whether the html table will be nicely cut into paginated pdf without having to set any page size or would it randomly cut our table?

[@ChinoDoesStuff]

Hey ABG! I'm glad you found the video helpful.. unfortunately I have not been able to find a way to easily paginate the results, if you find a good way please let me know!

[@engandrenavarro]

Sir, great video! Thanks for that!

[@ChinoDoesStuff]

Cheers Andre!

[@CustersBart]

Really Great video mate! Can Flow also return the link of the newly created pdf to powerapp?

[@ChinoDoesStuff]

Hi Bart! Yes you can totally do that! Just add a 'Respond to PowerApps' action as the last step in your Flow then in your application wrap your Flow call inside a Set() function to capture the result. I hope this help!

[@SergeySenkin]

Please, can you show how I can export various data from powerapps to excel online? This is will be cool!!!

[@ChinoDoesStuff]

I will definitely look at doing a video on this subject in the near future! Thanks for watching!

[@hounamao7140]

This is awesome. I'm trying to do something slightly different though, could you tell me how to populate a word document instead of creating a pdf from the inputs of powerapp ? I'm quite desperate.... Thanks a lot

[@ChinoDoesStuff]

Hey Houna... I'm so glad you're enjoying the videos! Currently there really is only one straightforward way to export to Word from PowerApps and that is using the Word Online (Business) (preview) which is also a Premium connector so not for everyone :( If you and your users will have a premium subscription then this is the way to go!

[@michaelkelly3017]

Amazing Video! How would I go about exporting data if its from a form and not a series of text fields in a table?

[@ChinoDoesStuff]

Hi Michael.. Thank you so much for your nice feedback! Brings me much joy that found the video useful :) Its very easy to include fields from a form in your HTML/ PDF export and all you have to do is reference the specific datacard value you wish to add. For example, I have a PowerApps form that contains fields from a SharePoint list. To include the list item's Title field within my PDF export I need to make reference to it within my HTML - DataCardValue17.Text. This reference will be different in your app but the theory should be the same. Let me know how you go!

[@nickchapman7562]

HI, great video. 1 question, the HTML file is created in one drive as expected and the pdf in a SharePoint library, what i cannot understand is why there is also a HTML file created in the sharePoint ;library?? any idea? Thanks Nick

[@ChinoDoesStuff]

Cheers Nick for the great feedback! As far as your issue, I would go back and check each step of your Flow. There shouldn't be a HTML file created in SharePoint if you followed each step in the video. Pay particular attention to your Create File in SharePoint step. Cheers and let me know how you go!

[@mykid8yours]

I’m having the same issue and do not see where I went wrong.

[@manuel_antonio_rivera_socarras]

Yesss... Great!!! Aweson!! video and explaning!... but stil I can see my file... is generated but with 0 KB... please help me...I dont know why

[@ChinoDoesStuff]

Hey Manuel, there's got to be something you've missed during the video.. go back and follow each step, maybe start with one or two lines of html and go from there.

[@manuel_antonio_rivera_socarras]

@@ChinoDoesStuff thanks to one of the best teacher....what I am doing is generating a pdf from an excel not from a form but I will continue trying because I have to learn...is not an option for me...thanks for reply sir

[@santhoshvm7621]

Hello, great instructional video. But i have an issue with "Record Number -" & Gallery1.Selected.ID) step as am unable to understand the logic. This is also causing Flow to fail. Any solution is highly appreciated.

[@ChinoDoesStuff]

Hi Santhosh... Thank you so much for your feedback. It's always really nice hearing good things about my videos and keeps me enthusiastic about doing more! Now about your question... Are you talking about the reference to this field within the HTML control? If so, Gallery1.Selected.Id is a reference to the current selected value for my Gallery. Effectively, its the item that I last clicked on. In your application, 'Gallery1' will be the name of your Gallery control that you want to reference. If you are unsure about Galleries in PowerApps and how to use and reference data from them then I can suggest watching my video on the subject - kzbin.info/www/bejne/oZmqo3x_oJWUoK8 I hope this helps! Let me know if that answers your question and how you get on :)

[@santhoshvm7621]

@@ChinoDoesStuff Thanks for the tip. Apparently had an issue in Flow and solved it. But i do see same document is getting created with same name when i fill form. Is there any way to make sure, the unique documents are created each time we fill the form? Thanks in advance !

[@ariyadasouvanlasy7438]

This is a great video which help me a lot ! But how can I send the convert PDF by mail using the same flow ? Thanks

[@ChinoDoesStuff]

This is an interesting question. Sorry for taking so long to get back to you. I am not personally done this but my educated guess would be to add an additional send email step in your flow and attach the PDF via the file reference. I may still do a follow up video on this subject. Cheers and thanks for the feedback!

[@nickchapman7562]

This would be really useful as I am looking for the same functionality.

[@MrAbueslam]

Your video helped enermousely with my invoice generation with pdf and logo. I have been asked to add a side foot logo and I wonder if you can help me adding this to my flow. Thanks

[@ChinoDoesStuff]

Glad it helped!

[@ALLCAPS]

Thank you for such a good tutorial! :D This language is a doozy

[@ChinoDoesStuff]

Hey All CAPS... How's your PowerApps experiences going?

[@ALLCAPS]

@@ChinoDoesStuff it went WELL. I had to build an interactive credit calculator for a childhood development schooling program and completed a program that, otherwise, would've cost the company $6,000

[@junec5985]

Thanks for the great tutorial! I've tried to use to embed a static or dynamic image, but no success once it's printed to PDF. Any suggestions that we may be able to do this?

[@ChinoDoesStuff]

Hi June... I'm so glad you liked the video and hopefully found it useful. With images, you must URI encode your images using your FLOW first before they can be displayed. There are a few steps that go before the HTML creation step to get this working but I chose not to include them in this video as I was trying to keep things simple and the video time short. I'm going to do a follow up video (probably post it this weekend) that will show how to include images in the PDF. In a nutshell, begin with some images stored in One Drive, then use the Get File Contents action in your FLOW to retrieve the desired image from One Drive. Next use the Initialize a Variable step to create a string variable and set the value to be the expression - DataURI(body('get_file_contents')). Call the variable whatever you like. Once you have your variable initialized, you use it as the source for the image tag. E.g. Cheers and please post back here letting me know how you go and if you need any more help!

[@junec5985]

@@ChinoDoesStuff That's wonderful news! This is a good approach for getting me and others started! Look forward to your follow up video!!

[@ChinoDoesStuff]

Hey June.. how did you go with adding images to your pdf export? Did you watch my follow up video on the subject?

[@junec5985]

@@ChinoDoesStuff Thanks so much for putting together the follow up video. I really like the part that you just put the dynamic content into a variable instead of including it in the same variable. The video definitely solved my initial issue of how to include a static image in a PDF document. However, my case gone complicate now. I need to include a dynamic image in the PDF. So I have a list of cases studies, each case study contains some basic case study info and the customer's company logo. The logo column is a hyperlink column and has the URL to the image. When the users click to open a case study, I need to provide a Print/Export option for them to print/export the case study in PDF format. The PDF needs to include the customer's logo. Any idea of how I might be able to achieve this? Again, thanks so much for the video :)

[@ChinoDoesStuff]

Hi June! I'm so glad that you found the video helpful. You are going to have to get a little 'creative' to get the export with images working exactly how you want them. I can nudge you in a couple of ways I think perhaps would be a good approach for you. One way would be to have all the company logos that your app will require pre-loaded somewhere like SharePoint in a document library that is readable by all users of the application. Pass the company value as a parameter to your 'Export to PDF' Flow much like you did with the HTML and filename. Flow can load the corresponding image from SharePoint (instead of One Drive) for the company based on your passed parameter. This means, however, that there is always a static list of companies / images that the PowerApp/Flow can handle and you must have some kind of lookup reference for each company -> image table. For simplicity you could just bake this into the Flow but you could also look this up from a SharePoint list so that it's dynamic. I guess another way, albeit somewhat more complicated, would be to allow for uploading of a company image inside of your PowerApps application. Pass the filename string as a parameter to Flow then use that as a reference to your image to include. This gives you a lot less control over what kinds of images get uploaded (file sizes, image content) so that may not be ideal. Hopefully that makes sense. Let me know how you go! Cheers.

[@vineetarai2088]

It nice video...Can you please make videos to export data from powerapps directly and in data source is the SharePoint.Thanks in advance

[@ChinoDoesStuff]

Hi Vineeta, Sorry for taking so long to get back to you. Here is a video a did on saving data from PowerApps to SharePoint. Hope this help! kzbin.info/www/bejne/moW4poNvp7Fqlas

[@rafaelcortes5290]

Hi Chino, great stuff, i have a question, i do everything as you do, i got my HTML ready but when i see the PDF it just exports the "fixed Data", no Format and no information contained in the table, what could it be?

[@ChinoDoesStuff]

Hey Rafael! Glad you enjoyed the video... My advice would be to go back through the video and make sure you follow every step exactly how I have outlined it. If you are struggling, perhaps try first with a very simple export and get that working before attempting more complex formatting.. hope that helps! Let me know how you go

[@rafaelcortes5290]

@@ChinoDoesStuff the thing is that if if check the HTML it is exported flawlessly, the PDF isn't!

[@carlw]

Looks good. NOW, try it with enough items so the pdf spans two or more. You will no longer have that nice title at the top as a header for example. Have you ever tried that real life example?

[@ChinoDoesStuff]

Yep..I mention it quite a few times in comments and follow up videos that involve pdf exporting that there isn't a way to do page breaks using this old method... Perhaps check out one of my newest videos which uses the new pdf() in power apps.

[@carlw]

@@ChinoDoesStuff Thanks Chino. I'm trying out the encoding power automate connection. It is great BUT still the margin issue.

[@shivtomar7328]

Very nice. Great.

[@ChinoDoesStuff]

Thanks so much for the feedback Shiv.. I will be posting more videos next month so stay tuned for new content. :)

[@blutkraehe_official]

HI, thanks for that ... my table is too large, who i can convert PDF in landscape?

[@ChinoDoesStuff]

Hi Patrick.. Make sure you include some HTML / CSS styling in the table you are exporting to PDF. Its always going to be a challenge to fit all of the content across the page and you may have to reduce the amount of columns that you want to display. Hope this helps.

[@AmitManwar-Sniper]

@@ChinoDoesStuff That was awesome. Thanks a lot. I have similar question. Even i have a large table and it is getting cropped. Can we have horizontal scroll bar in pdf?

[@AmitManwar-Sniper]

Hi @Patrick, did you found any solution for large table?

[@AmitManwar-Sniper]

Hi @Patrick, did you found any solution for large table?

[@blutkraehe_official]

No

[@paulpearson3162]

Hello, I have been trying to get this to work for a while now. Everything works as far as html to PDF, but it is coming from sharepoint list and the conversion breaks the links and strips the images. Is this possible to do? I've read your comments to Jessica below but didn't see a solution. YOu mentioned the GetFileInfo, will this pull images or links without changing from to file:\\? Thanks!

[@ChinoDoesStuff]

Hi Paul.. I didn't include the additional steps required to export images as I was trying to keep this video as simple as possible. I have since posted a follow up video that goes into how to export images as well! kzbin.info/www/bejne/mJTMdmxrhdV5jpY Hope this help!

[@priyashah9888]

Thank you so much for this! With the database table, I've stored signature from peninput.....can I also fetch that in PDF? Thank you 😊

[@ChinoDoesStuff]

Tbh I am not sure. First check to see if the output from the pen shows up in the html control. I suspect it may not but give it a go and please let us all know in the comments!

[@priyashah9888]

@@ChinoDoesStuff no, it's not coming up in html. I have done with img src and JsonFormat but not working

[@ChinoDoesStuff]

Yes you might have to add the image using my follow up tutorial for adding images into the pdf export.. it's a bit painful but works kzbin.info/www/bejne/mJTMdmxrhdV5jpY

[@priyashah9888]

@@ChinoDoesStuff Thank you 😊

[@bismarkbrito8100]

very helpful , thank you !!

[@ChinoDoesStuff]

I'm glad that it was able to help.. Stay tuned for more videos in the new year :)

[@kindumelese4335]

HI Chino, it is very helpful video, do you have other video that the logo put dynamically if so please let me know, Thanks again

[@ChinoDoesStuff]

Hey kindu..what about this - kzbin.info/www/bejne/mJTMdmxrhdV5jpY

[@kmuralikrishna1582]

I just understand if we did from SPO its very fast, but if we did from SQL(on-premises) it taking more time ...

[@ChinoDoesStuff]

Yes it most likely will be much slower working with on-prem SQL as the service needs to connect back to your on-prem servers and many factors can come into play that will affect performance.

[@dileep_kumar_s]

Hi , Is It possible to save a record of Model driven app with entire data in it as PDF ? IF yes how save that record as PDF in Model driven app. Reply is much appreciated. Thank you.

[@samgibbs8194]

Hi, thanks for this (and the images video) - is it possible to add a step at the end to delete the html file? I tried using the Onedrive for business delete file step, using the path from the create file step, but this gets an error.

[@samgibbs8194]

I realised I should have been using the ID, rather than the path.

[@ChinoDoesStuff]

No worries Sam.. I'm glad my videos were helpful in you completing your task! :) Cheers and thanks for watching!

[@johnmoleski2899]

I know this is an older post, but i am using this great outline to print a form. Problem is that I have a Choice Field and i am unable to find a value that i can place in the html that does not error. I was using 'FieldName'.Default and .Value but both are invalid, do you have any direction for me? Thanks Again

[@ChinoDoesStuff]

Hey John... Thanks for watching! Even though I posted this video a while back I am still pretty sure that it's the best way to generate pdfs in PowerApps so thanks again for your support! On your question... There shouldn't be an issue with displaying your choice field value in your pdf.. does it display in your html?

[@johnmoleski2899]

@@ChinoDoesStuff Unfortunately No it does not, When i use the Default it underlines it. Says that Invalid Argument type. Expecting one of the following: Text, Number, Boolean, OptionSetValue, ViewValue " & 'Want Improved CI?_DataCard1'.Default & "

[@ChinoDoesStuff]

Hey John.. I'm not in front of a computer right now so I can't confirm but I'm pretty sure for fields like choice fields you need to reference the value by using .selected.value

[@johnmoleski2899]

@@ChinoDoesStuff o was able to make it work by using a different variable. Thanks so much for a great video.

[@nurulnabilah9721]

Great video! however why my flow failed at convert file using path? i already follow your steps. thank you

[@ChinoDoesStuff]

Hi Nurul... Go through each step and make sure you have followed the video precisely. The error could be caused by a problem with your HTML. Maybe try a simpler export first, something with one or two lines of HTML and work from there.

[@nurulnabilah9721]

@@ChinoDoesStuff alright. Thank you for the quick response. Its work already. 😊

[@thurstanp]

Very useful video thx. 1 Q is you created/initialized 3 variables in the Flow but.when you triggered the Run Flow syntax in Powerapp it only asked.for 2! Why is that? Thx

[@ChinoDoesStuff]

Hey Thurstan... I havent watched this video for some time but I might of used the third parameter for something that wasnt passed from Power Apps? It might also be that I didnt end up using the parameter at all in the end.

[@jessicavestel6998]

Hello. Thank you for your great video! This solves a big problem we were having. Unfortunately, when rendering to PDF from html, all of my style changes are deleted. If I open as an HTML document, it works fine. For example, if I change the font size using Example Text here, the text will appear smaller in the HTML version but the same size as the rest of the text in the document in the PDF version. The same goes for changing font colors. The only time it renders larger is if I use the ... tags. All images are ignored as well. Any thoughts?

[@ChinoDoesStuff]

Hi Jessica! I'm glad my video was of some assistance. I think the CSS support for PDF creation is kind of limited with PowerApps so you will need to experiment with different ways to apply formatting to your tags. You could try encapsulating your text in a div instead of a font tag and applying inline styles to the div. E.g. Example Text , or try and set a class for the div and add a section at the beginning of your HTML file. As for images, you must URI encode your images using your FLOW first before they can be displayed. There are a few steps that go before the HTML creation step to get this working but I chose not to include them in this video as I was trying to keep things as simple as possible and the video time as short as I could. I will probably do a follow up video next month. In a nutshell, begin with some images stored in One Drive, then use the Get File Contents action in your FLOW to retrieve the desired image from One Drive. Next use the Initialise a Variable step to create a string variable and set the value to be the expression - DataURI(body('get_file_contents')). Call the variable whatever you like. Once you have your variable initialised you use it as the source for the image tag. E.g. Hopefully this helps. Like I said I will probably try and do a follow up video on this in the coming weeks. Cheers and let me know how you go!

[@Balrog74Fr]

@@ChinoDoesStuff Hi, I have the same issue, my pdf convert has missed all the style changes. The problem is not about font styles but about align and line breaks, even with . I have a , all lines are separated with a strange line break and the table is no more aligned center. Maybe Microsoft should improve the convert PDF process ?

[@iamdarylv7237]

Great Video! Thanks for sharing. Would like to ask assistance if possible to put the html in the body of email. Instead of attaching as pdf. Thanks in advance and keep sharing your knowledge.

[@ChinoDoesStuff]

Hey daryl.. Thanks for your awesome feedback! I posted a video a while back on sending emails from PowerApps. You have the option when sending emails from PowerApps/Flow to format your email body using HTML - kzbin.info/www/bejne/jWTFgouCaMl8Y7s Hopefully this helps. Let me know how you get on...

[@iamdarylv7237]

@@ChinoDoesStuff Thanks.. I was able to send email via powerapps button. More power! 💪

[@ChinoDoesStuff]

Very awesome!

[@1wheeladam]

Great video and very helpful. i have an issue though. my power app and flow generates the HTML and a PDF, but the data in the table tat comes from my gallery seems to be missing. it usually converts the html and keeps the headers, but the cells are missing.... can you help?

[@ChinoDoesStuff]

Did you manage to solve this issue?

[@mblherry]

Great video! Many thanks. 1 question, is it the same OneDrive folder that everyone uses or does each user need to have their own folder? What I mean is with multiple users do I need to setup a shared OneDrive folder so they can all access it?

[@ChinoDoesStuff]

Hey Marlon... The folder is automatically generated within the user's own One Drive and the file is saved there. No need to have a shared space if one is not required. Thanks for watching!

[@mblherry]

@@ChinoDoesStuff To deploy this across an organization would a PowerApps for Office license be sufficient for users?

[@mblherry]

@@ChinoDoesStuff Thanks again for the video and response.

[@ChinoDoesStuff]

Yes as long as you stick to non premium data connectors then you can do this enterprise wide without a special licence

[@danacygan-nehs6219]

I'm almost where I need to get! When creating the HTML, it will pull only if I create a New Screen with a couple things in a gallery. I have 3 screens and using tabs in my form. It wont pull in any of the info from those other screens. It continues to tell me that the Name isn't valid. This identifier isn't recognized. Should I still be able to pull from the card information from my edit form? THANKS!

[@ChinoDoesStuff]

There shouldn't be an issue as those fields should be 'global' in all of your app screens. Have you tried displaying the value out of the card in a label on the same screen? Perhaps you are not accessing the value correctly? Try the label test first then when you get that working try it in your HTML.

[@helenm0905]

Thanks for this Chino. Is there a way to prompt the user to choose where to save the pdf file instead of saving to sharepoint or onedrive?

[@ChinoDoesStuff]

You could pass a value to the workflow..

[@danielbell9192]

Great Video. very informative. When you did the html from the gallery is there a way to insert column headers? Thanks

[@ChinoDoesStuff]

Hey Daniel! Thanks so much for your nice comment. It really means a lot to know that these videos are helping out. To answer your question, yes you can definitely insert column headers into the table. All you need to do is add another bit to the HMTL string just before the Concat() function. E.g. "" & InsertedValue_1 & "" & insertedValue_2 & " etc... Hope this helps!

[@danielbell9192]

Chino Does Stuff Great! I’ll give it a go! Thanks again!

[@ChinoDoesStuff]

Anytime :)

[@limitlessboy6423]

Hi, for some reason the pdf conversion doesn’t work. The html file works fine but it doesn‘t create a pdf file. The pdf conversion worked a couple of times but then stopped working for no reason.. maybe it‘s because of my HTML style? I‘am using OneDrive by the way.

[@ChinoDoesStuff]

Hey Limitless... Unless you have changed something else since it worked, my guess would be that it's something to do with your html styling. Try simplifying it and run your export again until it works.

[@raghavani2710]

Thanks for the video, really helpful. I have gotten stuck at the very end though. When I try to use datacardvalue instead of gallery.selected as you show here, my pdf output is showing the same data for every new record I create. Any help?

[@ChinoDoesStuff]

Probably more of an issue with how you are accessing the datacard value.. without knowing more that's really all I can give you right now :)

[@mustafahussainmohsin320]

Hello Sir, I have done what you have did in this video for showing Picture, but I am still getting that Red Cross when I am displaying it into PDF, can you help please!!

[@ChinoDoesStuff]

You need to watch my follow up video on adding images to your PDF! :) here is a link - kzbin.info/www/bejne/mJTMdmxrhdV5jpY

[@akmalakmal7]

I follow this method. However, i found that, for long tables HTML, the PDF files result in only half of the HTML content. Any tips?

[@ChinoDoesStuff]

I have not run into this issue.

[@dankirchner4460]

Hello. I'm new to power apps and I was wondering if you can achieve the same result when using a gallery with a nested gallery containing child information

[@ChinoDoesStuff]

I wouldn't think so. Different applications.

[@carolblay]

thank you so much

[@ChinoDoesStuff]

You're very welcome Carol :)

[@pauldouglas6161]

Great video. I successfully created PDFs using your guide. I am however unable to save html images in PDFs. Do you have a video showing how to save html with images to PDF?

[@ChinoDoesStuff]

Hi Paul.. Thanks so much for your feedback! Unfortunately I don't have a video demonstrating PDF with images right now as it is a little more complicated and I was trying to keep this video as short and as simple as I could. If you take a look at my reply below to Jessica Vestel I outline how to include images in your PDF. I am planning on a follow up video next month that will demonstrate how to do this. Cheers!

[@spencercooper4546]

@@ChinoDoesStuff Excellent Video! I've got a collection (with images/ContentBytes and other fields) - and it would be awesome to have them appear in the PDF! Would love that video too. Well done!

[@spencercooper4546]

Just submitted a ticket - will let you know if I find anything out. powerusers.microsoft.com/t5/General-Discussion/Collection-with-Camera-Images-to-appear-in-HTML-which-is-then/td-p/213565

[@ChinoDoesStuff]

That's great Spencer! My gut feeling is that you will still need to save the images first to OneDrive then use FLOW to encode and display the them in your PDF but PowerApps is pretty flexible and there may be a more straightforward way of doing this. Looking forward to hearing what the response to your ticket is.. Cheers!

[@spencercooper4546]

@@ChinoDoesStuff Quick follow up: No responses yet - but I tried hacking it a little - and used this: Collect(CameraPhotos2,{Base64: Concatenate("") Basically my thought was to make the really long base64 random numbers into a hyperlink that HTML can understand. The results were meh - sometimes it would show one photo, sometimes two, sometimes none. Will keep working.

[@enzisblog9716]

Hi @Chino Does Stuff and Marcello, is there a way to send the PDF to a physically printer? Or (better) send the HTML output to the printer?

[@ChinoDoesStuff]

You could just print straight from the Browser.... Once the PDF is generated, link / open the PDF from Power Apps which will open it in a new Browser window. Print from there.

[@tombions]

Awesome video, Chino. Thank you!! Do you think it's possible to add an image to the exported PDF? I included

[@tombions]

Oh, you do have another video to do it already. I just found it! You're amazing man!!!

[@ChinoDoesStuff]

Thanks Santiago! Glad I could help :)

[@tonya3308]

I am trying to create a html to PDF output from PowerApps where I have a gallery embedded in my html code in a PowerApps html text box - however, I am having a difficult time getting this to convert to PDF with the desired format and tables. The report has a multiple column table where in the middle of each column is a gallery that can have between one and six rows of data depending on the item selected to report on. Any tricks or ideas - it seems that issue is having a gallery embedded in the PowerApps html text box requires the html to be a text script which doesn't convert well to PDF. The report displays well in PowerApps and Google html - converting to PDF or trying to print seems out of reach at this point.

[@ChinoDoesStuff]

Hi Anthony.... There are definitely some limitations when exporting to PDF to which I haven't explored them all.. Watch my follow up video on Exporting to Word as a possible alternative ... way more customisation available with Word document exports including PDF and its super easy to use!!! ....Here is a link - kzbin.info/www/bejne/qqqnhmyYraZjgpI

[@createanand7599]

Great video and very well explained, I followed the same and able to generate the PDF file, in my case I have sent that file to mail. But when I tried to add the CSS for html content pdf didn't recognize that. Can I know is this is the limitation or do we need to do any settings, can you please help me here.

[@ChinoDoesStuff]

Thanks for the nice feedback! You can use in-line CSS or styles embedded within your HTML file using style tags e.g. (don't use include files). Most styling should work for your PDF file but there may be some limitations so my suggestion would be to just experiment a little! :) Confirm your HTML is correct by opening your HTML document in a web browser and/or use a good IDE with intelli-sense that will confirm your syntax. The thing about styling is that it only takes a little error somewhere in your code and your whole document formatting will be affected. Cheers.

[@createanand7599]

@@ChinoDoesStuff Thanks for your quick response, I tried my html in web pages and its rendering fine, but when I tried to add the same here its not working, my sample html goes below. " .headerContainer { border-top-left-radius: 25px; border-top-right-radius: 25px; background: #73AD21; padding: 5px; width: 200px; height: 25px; text-align: center; font-weight: bold; } .headerText { color: #ffffff; font-size: medium; font-family: Arial; } .visitorContainer { padding: 5px; width: 200px; text-align: center; font-weight: bold; border: 1px; border-color: gray; } .visitorText { color: #000000; font-size: large; font-family: Arial; } .nameContainer { padding: 5px; width: 200px; text-align: center; font-weight: bold; border: 1px; border-color: gray; } .validityContainer { padding: 5px; width: 200px; text-align: center; font-weight: bold; border: 1px; border-color: gray; } .imgVisitor { height:60px; width:60px; } Visitor Badge Visitor Badge Number "&Name.Text&" Valid till: " Can you please let me know if any mistake is here

[@ChinoDoesStuff]

No worries... I'm glad to help out in any way I can. At a quick glance, I don't see anything wrong with your HTML except perhaps with how you are trying to display the tag. You need to encode the string into a valid URI first which I unfortunately didn't demonstrate in my video. Is it the display of the image file where you are having the issue? Try removing the img tag and let me know how you go.

[@createanand7599]

@@ChinoDoesStuff Thanks for your reply, it seems there is no issue with Image its rendering properly, only the styles which are declared in the header section is not applying properly.

[@ChinoDoesStuff]

My guess is that there is something still not quite right with your HTML. HTML can be tricky because you could have a character out of place and it will still display OK in a browser but will not render as a PDF in PowerApps. I suggest stripping back your HTML until you get something working and then add styles until you get to the point of failure. Hopefully that will highlight where the issue might be.

[@keimomon822]

Hi Chino, your procedure work on my app :) would like to know how to save the HTML in PDF in landscape format? Is it possible? Kindly advise. Thanks!

[@ChinoDoesStuff]

Hi Kei... I have been asked this question quite a few times and I am unsure if it is possible... Maybe if someone else has solved this problem they can comment it here. If you find the answer Kei I would also appreciate it if you can comment here how you achieved it! Cheers and thanks for watching.

[@keimomon822]

@@ChinoDoesStuff this is noted. Stay safe! Thankie!

[@osmarsilvasantos5077]

thanks man!!!!!

[@ChinoDoesStuff]

No problem!