PowerApps PDF Generator using Microsoft Flow PDF Converter

[@AdiCristea]

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!

[@ShanesCows]

Thank yoU!

[@hahahaha7023]

i think i'm gonna dial 911

[@tysonleonidas2955]

I know im asking the wrong place but does anyone know of a tool to log back into an Instagram account?? I was stupid forgot the login password. I love any assistance you can give me!

[@davianbrayan2585]

@Tyson Leonidas instablaster =)

[@tysonleonidas2955]

@Davian Brayan thanks for your reply. I got to the site thru google and Im trying it out now. Takes a while so I will get back to you later when my account password hopefully is recovered.

[@feliciadawn5014]

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!

[@ShanesCows]

You are very kind. 🐶

[@snork2209]

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!!

[@ShanesCows]

That is awesome! Good job to you Snork!

[@rambonumber007]

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

[@christianpilon163]

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

[@ShanesCows]

Cool

[@christopherspencer8239]

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!

[@ShanesCows]

Awesome!

[@thekreehaytion]

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

[@ShanesCows]

Glad to help. 😀

[@burning_out]

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

[@ShanesCows]

I like it. 😻

[@mgtd1138]

How would you accomplish that specifically?

[@johnmizell4683]

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!!!

[@ShanesCows]

Cool

[@82foghornleghorn]

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!

[@ShanesCows]

Awesome 😎

[@MrAbueslam]

Can you please show me how you managed filling in lookup records and data table fields in html. I am having issue with that.

[@ludwighallgren2554]

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

[@ShanesCows]

Glad to help. 😻

[@tenisviejos]

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

[@ShanesCows]

Yup 😻

[@peterhowell4502]

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.

[@ShanesCows]

Thank you Peter. 😻

[@StevenNel]

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.

[@ShanesCows]

Yes but that creates a lot of extra “noise” in the html that is really scary to a newbie.

[@chrislambe400]

"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

[@ShanesCows]

Glad it helped and hope you remembered to shower. 😂

[@ghuerren]

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!!!!

[@ShanesCows]

Awesome 😁

[@elierh442]

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

[@ShanesCows]

Thank you. I will. 😀

[@androidgeeking]

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.

[@ShanesCows]

Thanks for sharing!

[@divyanshgupta3760]

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

[@ShanesCows]

Glad to help. 😀

[@frenamakenson9844]

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

[@ShanesCows]

I feel like I should make a new version but nothing has changed so 🤷‍♂️

[@Maynardjones100]

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

[@ShanesCows]

Very kind of you. Hope you have a great weekend 🔥

[@HowToExcelBlog]

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

[@ShanesCows]

I don’t know how to convert excel to pdf programmatically.

[@GrBritton]

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

[@ShanesCows]

Glad to help. 😀

[@Chris-ig5qz]

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

[@ShanesCows]

I made it just for you. 😻

[@bexjuice]

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

[@ShanesCows]

Thanks 😊 glad it helped.

[@LannaSanches]

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

[@ShanesCows]

I don’t 😑

[@ahlan3609]

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!

[@ShanesCows]

Thanks Alan. This video should help speak to how we can get lots and dynamic data into the mix. kzbin.info/www/bejne/mJe7h5J9jciSgK8

[@julmasson6403]

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

[@ShanesCows]

Glad to help. 😀

[@eriks707]

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

[@ShanesCows]

😂

[@matthewprzybylowski5626]

Hey Shane. Thanks for the video. I've been using grids for layout in html. When running the code, the html file looks perfect but when converting to pdf, the file loses all the grids I've defined as well as any content within it. I've had similar issues with styling in general. It seems as though the conversion won't let me put in page numbers or align my image the way I want. Any idea why this might be lost in the conversion or know of anyone that might have the answer?

[@ShanesCows]

Sorry I got nothing Matthew

[@kattikawn]

I’ve just run into this same snag. Did you ever find a solution, Matthew?

[@keldonmoodley7565]

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!

[@ShanesCows]

Cool. Glad it works for you.

[@manuel_antonio_rivera_socarras]

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.

[@ShanesCows]

Glad to help. 😀

[@HowToExcelBlog]

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

[@HowToExcelBlog]

I guess you could use a text field in PA with Concat to create the table, then reference that part of the text in the flow. Interesting possibilities

[@HowToExcelBlog]

Any limit on the amount of text characters you can cram into either a text field in PA or with the Concat function in Flow?

[@ShanesCows]

Not that I know of but maybe. If you find one let me know.

[@amosp.godbyhighschool8054]

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?

[@ShanesCows]

The way I wrote this flow it is looking in the user who is triggering the Flows OneDrive for the file. :( Consider just hard coding the base64 in the flow or app like I talk about here. kzbin.info/www/bejne/mHrRlmZ6eZh7d8k One day I need to revisit these PDF videos. :)

[@MaicaLRM]

This is incredible! I just created a new database and this will be something I add in the next version. Will definitely need to spend some time with this one lol!

[@ShanesCows]

Cool

[@tonyy4471]

2 silly questions: 1 - the OneDrive I am using is assigned to me, and only me. In order for this to work, do I have to give public access to one of the folders within my OneDrive to allow other users to run the flow? 2 - is it possible to execute a 'page break' command on the pdf?

[@ShanesCows]

1 it will save to their OneDrive. 2 page breaks are possible but I haven’t covered it yet. Requires fun with Div tags.

[@latrobe15]

Hi Shane, Does a user need to have a share on the one drive, like they need for SharePoint? And have you tried to launch the PDF when created from PowerApps?

[@ShanesCows]

Flow will use the Flow creators account not the user . I haven’t tried to view the pdf but should work.

[@mrstevennewmanEDU]

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.

[@ShanesCows]

That is awesome. I have toyed with patreon but I don’t know. 😀

[@k1ngydoteth403]

@@ShanesCows You defo should lol

[@kathystubbs5183]

Hi Shane, I'm having problems with the "get file content" bit for the datauri string to convert my image (from SP) to something that can be inputted into my concat function. I have a picture (jpg) in SP library so I use "Get File Contents" action as shown pointing it to my picture. I then initialise "photo" variable and set to string, use expression "dataUri('')" then select the "get file content" from the dynamic list like you suggest. It doesn't paste it in as "body('Get file content'), instead it puts dataUri('outputs('Get_file_content')?['body']'). When I hit "OK", it then says expression isn't valid. Any ideas? I've also tried it with a OneDrive image file as well thinking it might have just been pesky SP, but it misbehaves too. Any ideas?

[@ShanesCows]

Kathy I think you need one more ) at the end of the expression.

[@niebieskiYT]

You are awesome Shane. I love your videos!

[@ShanesCows]

Thanks 😎

[@carolblay]

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

[@ShanesCows]

Thanks Carol and right back at you. 😻

[@latrobe15]

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)

[@ShanesCows]

Yikes. Sorry, I am not great with HTML. I have to imagine it is possible but not sure. Sorry.

[@latrobe15]

Thanks Shane. This may all become moot as the Flow developers have started working on a print solution for powerapps. In relation my problem I had above it was still your video that put me in the right direction as your sample HTML code had the beginning and end that was required to add to the flow HTML code. It is strange as that code is not needed when doing an email in flow. I guess that is what the outlook setting IsHTML does.

[@ShanesCows]

So many nuances. 😑 Makes it interesting. 😻

[@jackrealdrummer]

Thanks Shane, nice! I created a file that I saved to Sharepoint and I couldn't figure out what kind of ID the convert to PDF wanted; the path and the ID didn't work for either version. I ended up using the Adobe converter instead but I'd love to know if I just got something wrong using the Onedrive version.

[@ousselg1509]

Hi Shane, thanks for the video. I have a slightly different scenario and am wondering how to get it to work. If a mail is send, I extract the html body and save it to onedrive. That part works. I then convert it to pdf and the images won't show up. Any idea how I can fix it? As I don't save the images separately each time an email arrives.

[@ShanesCows]

You are going to have to get the images in base64 format. So downloading the file and such. Not super easy, possible but not easy. Other thing you might check if the 3rd party PDF tools support URLs for images. I don't know if they do or dont.

[@2hamsi]

Its all working fine but although i have a little problem. Unfortunately the pdf converter ignores the height an weight settings from my image within the image tag. Is there a way to fix this?

[@ShanesCows]

I feel like I have done the size stuff. Maybe try it as a style instead of inline.

[@georgiescicluna8405]

Shane. Thanks for the video. I have follwed it through but for some reason the html version shows as required but when it converts to PDF it drops off the section which is a Concat table to get items from a sharepoint list. Any idea what l could be doing wrong? Thanks in advance.

[@ShanesCows]

It is an html typo. Most likely you forget to close a or

[@NOR3MSTI]

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?

[@ShanesCows]

Basically the conversion process just wants text, it doesn't care how you get there. So if you can create logic to only send part of the HTML you want then you should be fine. There is a newer version of this video that may help kzbin.info/www/bejne/pnfPqIyvbc6dn6M

[@davej9787]

Hi Shane, I saw that you use Get file content so if I have 3 logos or images in my pdf do I need to repeat 3 times that action?

[@ShanesCows]

Yes, that would work. Remember you ahve about a 1.5 MB limit total for the HTML file, so don't get too many pictures.

[@davej9787]

@@ShanesCows Oh I will get an issue than. You know the MS Inspection app which one you can do an inspection with some steps (in my case I have 8 steps) and in each step I could have 2-3 pictures. So do you have a video explaining how to create a pdf report displaying over 5 pictures in my report like this? My pictures are in Dataverse database.

[@luismmpgoncalves]

Hi Shane Help please, I can't get around this. I created the flow in the power automate and when I do the test, everything runs fine, save the html in the onedrive folder and create the pdf file in the sharepoint folder as it is supposed to. When I put the instruction on the button in OnSelect "htmlToPDF.Run (htmltext1.HtmlText), it stays underlined in red with the error message" Invalid number of arguments; 1 received, 0 expected ". For now I am using the simple html "Table with border" without changing anything. What am I doing wrong? Thank you very much.

[@ShanesCows]

You forgot to Ask in Power Apps inside of you flow.

[@lilfrog5]

I have scanned documents in PDF format, is it possible to get them signed using automate? What about converting PDF to some other format where that might be possible, such as Word (even if it is an image without OCR)?

[@ShanesCows]

There are actions in Flow to populate a word template

[@SiesMan1]

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.

[@ShanesCows]

You can ask in PowerApps as many times as you want.

[@olrac158k]

@@ShanesCows Can i please know how i can do this in flow? Thanks!

[@thurstanp]

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

[@ShanesCows]

So I could use the value pulled from Power Apps. Making things more dynamic.

[@thurstanp]

@@ShanesCows thx. No what I meant by that Q is what if you have multiple text inputs from the user, so how would write/use different expressions to handle the multiple data going into the html rows to create the pdf? Rgds

[@frodesellevoll]

How do I get landscape format on PDF file? Is there any programming in Powerapps? Has an html in powerapps with many columns. It creates PDF standing, and then not all columns appear.

[@ShanesCows]

Have to use a 3rd party converter to get landscape

[@techieeetechnologyleague]

Hey Shane, I followed the steps up to creating the file in One drive, but when I click on the file in onedrive it downloads as a flat file with no extension. Is there some type of configuration I need to do to get it to open up immediately like in your video?

[@ShanesCows]

Maybe you didn’t set the file extension to .pdf? Should be be anything special.

[@PolishTaekwondo]

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.

[@ShanesCows]

Should be possible. What have you tried?

[@VibeOfCeylon]

I have created an IT request application, and it's now working with files being saved on OneDrive. However, I need to send the requested PDF to the user. How can I do that?

[@ShanesCows]

In your flow you have the file from the Convert action. YOu can put that output in the Attachment field of an Outlook email. This week's video on images in flow will help kzbin.info/www/bejne/Z3-agXV6n7mMZ7c

[@carloseduardoperez5432]

Hi Shane, I just tried to follow this example for the same purpose but I had some trouble with the png because I'm trying to make this but instead of png stored in my OneDrive I would like to this with barcodes html code. Do you have any idea of how to achieve this? The pdf and the rest of the content in the file is working ok

[@ShanesCows]

This video will help kzbin.info/www/bejne/mHrRlmZ6eZh7d8k

[@johnmizell4683]

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?

[@ShanesCows]

You have to experiment. I have made one that looks pretty nice. Just took elbow grease and experimenting.

[@MichaelLocke-wj1qs]

I might have just missed something, but when I am creating the first file from HTML, it isn't coming through as a PNG file, and the converter is saying it wont convert. It is having me open it in notepad

[@ShanesCows]

Yeah, that shouldn't happen. I would run through the steps again or this video kzbin.info/www/bejne/pnfPqIyvbc6dn6M is a newer version of the same stuff. Might be helpful to hear me say it again, differently.

[@ShivPataPutraPawan]

Hello Shane, You used triggerbody () ['Createfile_FileName'] for one dynamic content, how can I make multiple dynamic fields? Or what arguments do I need to pass in html for multiple dynamic fields... Please suggest...

[@ShanesCows]

Click Ask in Power Apps again and that will generate more fields

[@ShivPataPutraPawan]

@@ShanesCows Great, concept is clear and it's working fine, Thanks...

[@strikermanten]

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!

[@ShanesCows]

Hmm. Not sure i will have to revisit and see if they broke something

[@androidgeeking]

You mentioned you can do it with SharePoint? I didn't a see a convert to pdf for sp document libraries.

[@ShanesCows]

The HTML file and the conversion process has to happen on OneDrive. But the Create File step can create the file into SharePoint. Sorry for any confusion.

[@pkp044]

This is beautiful!!! Thank you so much for sharing this Shane!!

[@ShanesCows]

My pleasure!!

[@chrisbartman5125]

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.

[@ShanesCows]

Interesting. Thanks for sharing. I haven’t ran into that yet but when I dig in on this project I will see what happens.

[@Youffy23]

Thank you so much Shane! I see no way to have it landscape, but is there one way to make it fit the PDF size maybe?

[@ShanesCows]

I have had no luck with the free options to control the sizing like that. Maybe one of the paid options would work.

[@Youffy23]

​@@ShanesCows Thank you again. I shall share my "corporate "celebrity"" with you somehow! I simply redesigned the entire layout. However, one more question and a quick comment: - In this video, we can eventually add information about the fact that we can have "ask in PowerApps" in PowerAutomate, and get a full HTML document made in PowerApps. Much easier than adding too many fields/requests from various queries. - But then, the downsize of this = I lost the picture / the variable. So my HTML in PowerApps = I have the picture. I send email, the picture is still here. I create the pdf, and pschiit, is gone. Any idea? I cannot use your workflow, I have like 40+ information to add. Thank you again, find me a way to share my celebrity :) (I already listed you in various PowerPoints about "where I learned")

[@junbecks]

Hi Shane , I had a blast following along and generating pdfs. But I cannot get any tables I create via html, to fit the exact width of the pdf. I know how to resize tables, but the words in the cells just fall off the final pdf. Any tips?

[@ShanesCows]

Did you try width = 100% for your table?

[@junbecks]

@@ShanesCows no still doesnt work. I even tried to get the sentences in a cell to "go to next line", but then it condenses the sentences all the way to the left of the cell it just looks weird. For what I need to do, I may have to just use a word template and convert that to a pdf and save the html for other purposes.

[@541576]

Hi Shane Young! Since we are using our own one drive as part of the flow, how to allow other user use the Powerapps PDF?

[@rafaelesquivel8966]

Hi Shane, is it possible to create the PDF in a horizontal orientation? I even tried rotating the HTML but when converting to PDF it keeps showing on portrait.

[@ShanesCows]

Not with the free tool. You would have to use one of the paid options. 😐

[@Viipiin]

I'm using this with Power Apps but every time it store pdf to user's one drive account. Any work around for centralized location for pdf?

[@ShanesCows]

The html file has to be users OneDrive. The pdf file you can create anywhere, like SharePoint

[@katherinewright4137]

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?

[@ShanesCows]

You need to send the data to flow and use the create item action. Should work fine

[@RRRin1.160]

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!

[@ShanesCows]

Ask in PowerApps works the same way. Not sure why you aren’t seeing it. 😑

[@RRRin1.160]

@@ShanesCows Hi Shane, I was able to find it. I think I chose the wrong Power Apps connector. Now I a working on gettibg the fields from my form into HTML so I can generate the PDF. Thanks!!

[@waynel9645]

Ok, I am new to PowerApps and have been trying to solve a problem with no results. I am trying to convert html to pdf, but with dynamic pictures. I have everything running and the flow works, but it doesn't show the pictures and is a red X where the pictures are supposed to be. The flow use one drive to export the html file to one drive as you show here, but a dynamic picture doesn't work in my case as I need dynamic. I haven't found one person yet that has addressed this issue. Obviously it has something to do with datauri, but how do you solve this?

[@ShanesCows]

The key is you have to use the base64 of the image in the img tag. Details here kzbin.info/www/bejne/mHrRlmZ6eZh7d8k

[@CliveMMorgan]

Hi Shane, if I want to create the whole HTML in a Rich Text control with Poerapps and then post the contents of 'Button->Createfile'.Run(RichTextEditor1.HtmlText) into flow, is this possible, and how do I set the concat statement as Concat('triggerBody()['Createfile_FileName']') does not work.

[@ShanesCows]

Rich text control will work for the body but you still need the header and footer html.

[@BrgeHolse]

Great video.. thanks for the kick in the right direction.. The conversion tool is still in preview and has more output.. But unfortunately also an error.. When I use the path variable it fails so I have to point directly to the file.. Do you know where I can report that error?

[@ShanesCows]

The forums are the best place for error reporting

[@ericbauwens1642]

Awesome, that is exactly what I need for one of my projects! Thanks Shane!

[@guyinazo]

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.

[@ShanesCows]

Glad it helped. :)

[@stormybanjo]

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

[@ShanesCows]

You're very welcome!

[@MsGeoffers]

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?

[@ShanesCows]

Maybe try what I show in this video around base64? kzbin.info/www/bejne/mHrRlmZ6eZh7d8k

[@MsGeoffers]

@@ShanesCows I really appreciate the help, thanks. I've been greedy and posted a follow-up question on that linked video :)

[@nsiicmkmons]

Hi Shane The html file is generated but when the pdf is created its blank. Is there limitations on the html tags you can use or am I missing something?

[@ShanesCows]

So the html file is valid? You open it and it looks right? In that case I would look at Flow and see if your logic after that is correct.

[@mtamitolanga]

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

[@ShanesCows]

Yes. You just need to make the html. 😀

[@mtamitolanga]

@@ShanesCows I've created the html file and it does pull the information from both the master and details however the information is not related meaning the printed information for my master doesn't not speak to the details. e.g invoice 007 header and invoice 0010 details

[@ShanesCows]

you control the HTML. So it is up to you to relate them within the PDF. PowerApps provides all of the info now you need to write HTML to display records in a related manner.

[@RamReddy-cq1lf]

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,

[@ShanesCows]

Maybe... not sure. Sounds complex but not sure if it would work or not.

[@aaqifshaikh7863]

Hi there, I'm having issues with the conversion of HTML file to PDF. I used the same flow structure still when the PDF file is created one of the column gets cropped with all the contents. I even raised a ticket, had a call with tech support even he seems to have the same issue. Any idea what I must be doing wrong?

[@ShanesCows]

NOt sure. I would start with simpler HTML and see where things break. If you table is too wide for the page it does just get cut off.

[@aaqifshaikh7863]

I did and now I'm getting strange results like table gets vanished only the text under can be seen in PDF. When I removed some rows it worked so I guess the whole content is exceeding page limit. Is it possible to make some content move to next page when converted to PDF.

[@aminahamilton1790]

Hi Shane.. question for you. I have a Standard PDF form that my clients use to initiate requests. Currently they're digitally signing the form and sending a copy via email. Does powerapps allow users to digitally sign a PDF document? Thanks in advance!

[@ShanesCows]

Amina look at one of the premium connectors in Power Automate like Docusign or Adobe Sign. :) Should be just what you want.

[@aarounge]

Hello Shane, I'm trying to generate PDF from a SharePoint List but i have a few columns in the list which r in RICH TEXT format, any idea how I can get this into the PDF?

[@ShanesCows]

Responded to your other comment.

[@fadiahdab]

Hi shane, i know that i committing on old video but i have one question how can i point the pdf creation to each user one drive who runs the flow?

[@ShanesCows]

That is how it works by default.

[@fadiahdab]

@@ShanesCows Thank you so much

[@has3219]

Hi shane what happens when you have multiple textboxes. How do you integrate trigger body in that situation. My submit button does not allow me to reference multiple textboxes

[@has3219]

Never mind I figured it out

[@jlh2119]

Hello Shane! Another great video for Generating a PDF! Question ... I noticed that none of the files created had an extension in the filename (.html .pdf) ... When I ran thru the steps, while the files were created, unless I placed an extension on them they would not open / were not recognized for their type. Had I missed something in the video or has Flow changed ?

[@jlh2119]

Apologies ... I went back to the video .. PDF filename did have a .PDF extension in the config step ... The create html file step looked not to have the .html

[@ShanesCows]

Glad you got it working.

[@BeckyGribble]

Hey Shane. This is a great video and let me do what I have been trying to do for a while! The only thing I'm finding is that I want to put more than 1 record into a table. How do I create a table and ask it to do a 'for each' kind of statement? I can't get it working without using a premium connector, which my organisation doesn't pay for. I have tried creating the HTML text in Powerapps itself and can get a table looking how I want it to, but when I put that through flow and into a word document, it looks really fuzzy... Can't work out how to make it less fuzzy.

[@ShanesCows]

Look for my Concat video. Shows exactly this. 😀

[@ScottRosenbloom]

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)?

[@ShanesCows]

This video shows you how to send a whole collection over to Automate - kzbin.info/www/bejne/n57Lqaxph6qajsU

[@georgewinters2066]

Bravo! Fantastic! Clear, concise, and cogent!

[@ShanesCows]

Thanks George!

[@gamarschner]

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!

[@ShanesCows]

Covered in this video. kzbin.info/www/bejne/aKPJcoSbZtB-bq8

[@stephenhuckaba7450]

Is there a way to have this work with inline styles? I added an h1 tag with just a border, centered text and background color and the pdf skips the line completly.

[@ShanesCows]

I don’t think inline styles work. I had to them in the head.

[@stephenhuckaba7450]

Thanks. I'll give that a shot. The HTML.text doesn't seem to accept alot of styling. Hopefully Ms addresses this

[@djams1845]

Shane, buen día. Realmente nos aportas mucha ayuda con tus videos de ejemplos y soluciones. Gracias!

[@timellis2041]

This works great for me but when users other than me try to use it they get an error saying "connection not configured for this service" . Any pointers would be great.

[@ShanesCows]

Do they maybe not have OneDrive accounts?

[@aaronalbers7280]

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?

[@ShanesCows]

I got nothing for embedding Word or PDF. Maybe look at the 3rd party PDF tools to see if they make it an option? Not sure.

[@aaronalbers7280]

@@ShanesCows I decided to convert all the docs into pngs whenever they are uploaded to the doc library. In your flow however you are utilizing OneDrive for Business (Get file content). I am utilizing the SharePoint (Get file content) when we set that equal to a variable and embed that intot our HTML should be expect those abilities to function the same?

[@troybarrett235]

Hey Shane, I am looking to edit more than one table field inside the html file. So where you have only edited Chewy's Tuesday food I would like to edit Monday and Tuesday on the same PowerApp session. Any advice?

[@ShanesCows]

I am about to do this for a customer. I think what I am going to do is build all the html in PowerApps then pass it to flow. That way I can do all the concatenation where it is easy for me.

[@Stonna1990]

@@ShanesCows Hey Shane, sorry but did you end up being able to do this?

[@ShanesCows]

kzbin.info/www/bejne/mJe7h5J9jciSgK8 That video should help. :)

[@AhmedNaseem]

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?

[@ShanesCows]

Yes in Flow there is a respond to Powerapps. This video shows exactly that kzbin.info/www/bejne/paeveqqkn5uEoLc

[@ShadowCubes]

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

[@ShanesCows]

It is the same concept. What is in the variables?

[@ShadowCubes]

Thanks for your reply unfortunately I scrapped that idea. Thanks again for your videos great quality and professionalism!

[@umeshkunvar4439]

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.

[@ShanesCows]

Sorry I am slow. You will need to ask in Power Apps, inside your flow, multiple times.

[@maximilianomartinez925]

Is there any known issue with exporting paragraphs from power apps to pdf and using sharepoint as the collection source?

[@ShanesCows]

Not that I can think of.