PowerApps PDF from table data

[@wendymeyer1250]

You saved me - again!😁 I spent hours watching one tutorial after another, and was about to give up hope of finding a simple solution that used non-Premium connectors.... And then I just googled your name and you had all the answers I needed. I should have known to search through your Channel first.😉 Thank you Shane!

[@ShanesCows]

Awesome, glad that it helped Wendy. Have a great day.

[@hjnathan]

...and 36 hours later, I finally stick it!! Just spent the last 4 days creating my first PowerApp app. Probably a quarter of that time trying to print a pdf. It's ugly as sin but, it works!! I can't thank you enough for the video series. I couldn't have done it without you!! Thanks again, man!!

[@ShanesCows]

Congratulations! I promise the next one is easier. 😀

[@aaron6516]

Wow.... this is an incredibly simple way to do this... I was seriously doing this the hard way!!! You are a life saver!! If I ever get the chance I will not just buy you a drink... it would be like a case!! Dang!!! Thank you!!

[@ShanesCows]

Thanks Aaron! Have a great weekend

[@j.c8183]

Hello There just to clarify, you can add the border for your html @17:00 by writing : (the border conditions needs to be seperated from other style conditions like : < style = quote conditions quote ; border = quote 1 quote > ) Thanks for all your videos, it really helps !!!

[@ShanesCows]

Thanks. Yeah, finally a year ago I finally figured out Inline Styles were the answer. 😎

[@peanut-d-cat]

Fast forward 2020.someone giggles knowing even the great shane young gets a debugging moment during KZbin video.. thank you bro

[@ShanesCows]

Glad to keep you entertained. I know that is all cats want from us humans. 😹

[@sofiejensen3804]

Thank you! I especially like that you also are honest and show your mistakes!

[@ShanesCows]

You are so welcome!

[@abdulsamadv]

Thanks a lot for the video. How can I show this generated pdf in power app pdf control?

[@santiagoapel8905]

YOU ARE THE KING SHANE, AND POWERAPPS IS THE SKY

[@ShanesCows]

😎

[@santyytovaraguilar]

Hello Shane, I have a problem following the steps of your video, when I generate the file at minute 27:00 I do not get the structure of the table I get the html tags, I was configuring the flow as you have but I realized that you had as second step in the minute 10:00 - "HTML File", when doing the search of this step I try to add the same step that you have in your FLOW, but I only get "Create File" in OneDrive and OneDrive For business. Could you help me! You would help me a lot if you could show me how to do the second step of the flow that you have at 10:00

[@ShanesCows]

Create file is the step. I just renamed mine.

[@santyytovaraguilar]

@@ShanesCows Thanks you Shane !!

[@mobil88reporting47]

it's 2020 and shane young's video is still the "go-to" video for people with powerapp issue

[@ShanesCows]

Thanks 😻

[@Fatemeh-n2s6i]

I have a problem. I have a long table and when I print the PDF, the table is splited into 2 pages. I want to have the headers in the second page as well. Is it even possible?

[@ShanesCows]

Yes, but you would have to build the logic to split it into 2 tables and use page breaks. I talk about it in this video. We have done it for customers. It isn't fun. kzbin.info/www/bejne/j5y2f5ptd8SlptU

[@AbigaylePaulson-r5l]

Hello, Would you have any idea why my PDF prints the header and column names but none of the table information? My power app HTML shows the information in each table row but none of the rows extract to the PDF.

[@ShanesCows]

Your Table has a missing tag somewhere. Maybe put your HTML into ChatGPT and ask it if it can help you spot the issue. Tables have to be precise or they don't work with the conversion. Sorry

[@AbigaylePaulson-r5l]

Thank you I found an extra and that solved the issue! I appreciate your help and videos!@@ShanesCows

[@despotter71]

Hi Shane I have a problem. I have followed your film and it works fine only when i have a empty field then it is not working, how can i fix it becuse i have some times a empty field ?

[@ShanesCows]

You would have to write if logic to account for the blank

[@peterbishop2111]

Hey Shane, I am trying to do this project but want to be able to use multiple filtering fields on the same gallery collection. I am getting errors with the Choices function which is causing problems on the next screen when I am trying to filter accurately. Have you had any issues similar to this?

[@ShanesCows]

Give this a look for ideas. kzbin.info/www/bejne/oX2qmJ-fmdKDrsk choices wouldn’t be inside the filter. You would be filter(datasource, choicecolumnname.value = “red”)

[@stonesupermaster]

I got the same issue!!

[@gelovelasco7983]

Hi Shane. Just wanna know the syntax without the dropdown choices but directly what shawn on the screen.

[@ShanesCows]

You can send the HTMLTextControl.HTMLText to flow and whatever is in there will be converted. There is no way to send the whole screen. It has to be formatted HTML

[@paulmelrose-wyatt7620]

Hi Shane, I have an htlm text input in PowerApps that is passed over to Flow. I have the same 4 steps in my Flow as you have in this demo. When I trigger the Flow from PowerApps all works fine, no errors in the Flow. The pdf file is created on One-Drive. When I open the PDF file it is Blank. When I open the html file it shows as expected. Any ideas what is wrong? As a test, I put my same html code into Flow instead of pulling from PowerApps and did a manual trigger. The pdf file is generated and it displays properly. I'm at a loss as to what is wrong.

[@ShanesCows]

It is an HTML typo somewhere. :( Sorry but I would start over with the HTML you are sending from PowerApps and make it super simple. See if you can get it working and then go from there.

[@paulmelrose-wyatt7620]

@@ShanesCows Thanks for the reply, you are a master. That is exactly what was wrong. I just found the typo about an hour ago. I missed a in the code. Keep rockin the videos, I have learnt so much from you!

[@latrobe15]

Hi Shane, I get all this wrk except I have an issue fitting the table on the PDF age. It exceeds the right boundary. No matter what I do with width % px etc it stays the same. Any ideas?

[@ShanesCows]

I haven't ran into that. Everytime i troubleshoot one of these issues it is the HTML. One character, tag, or such out of whack and the conversion goes bad.

[@latrobe15]

​@@ShanesCows Thanks Shane, I know you wreck your brain for the answer as you seem that you are like me, always wanting to help. It wasn't an issue with a tag or character as the HMTL worked. I note that when it is a tag or character, the PDF has nothing in it. Like most things you got me on the right track just had to get more outside the square. I resolved my issue by creating the table using a HTML editor by CoffeCup. It was free to download and trial. I will buy it as it works really well, cost effective and all I needed do is copy and paste the code. Presto problem went away. I then manipulated to add the variables plus a collection and end even the image at the top. the source code is large but if you want an example, I can send it

[@punitharajan]

Hi Shane, i would like to run the flow with condition of whatever the rows created in sharepoint that equal to yesterday in stead of all the rows. could you please advise me

[@ShanesCows]

Write a condition as the first action to check.

[@punitharajan]

@@ShanesCows Thank you

[@mcommarie1]

Great job!! thanks a lot. however, my PDF file doesn't contain my gallery lines. It works pretty well when I click on the button from the development environment but, on the published version, I can only see the static info. Any idea?

[@ShanesCows]

Check your html. 9 times out of 10 it is a minor typo in html.

[@johannespurchase3185]

Hi Shane, Thanks for this, i used this method and combined it with the MS word Connector to be able to create dynamic Documents for my HR tool, how ever is there a way that i can link the created documents to the employees profiles, i use a CDS data source for the employees information, and want to be able to view the documents in Poerapps using the PDF viewer control, but i cannot link the created documents to the CDS, it is all saved to Onedrive

[@ShanesCows]

I covered this in my latest video where I answer comments and yours was one of them. 😀 kzbin.info/www/bejne/bpbSkoapjdObbLM

[@Hitesh222-c7n]

Hi shane young- i added print icon in 4 screens, how can combine 4 ( save as PDF files in to 1 )?

[@robertwilson6683]

Shane, after fixing my HTML, I have created a few labels which while linked to the EMail from a person field, then pulls in a picture of the persons signature into another field (The label actually makes a URL, and pull the data from a SharePoint Library). It works perfectly in HTML, but will not show at all in the pdf? So I created a few calculated columns to actually generate a dynamic url for each specific file I need, and have these hidden but pulled into my html code where I need the picture. All works OK, until I try and convert to pdf. I suspect that the html doesn't have the actual binary data for the image, just the link and thats the problem. So long story short, how do I dynamically get the urldata in a string from powerapps, into my flow to use in the html? I think this is hte only way I can get the pdf to show the picture of what I need.

[@ShanesCows]

You have to use the base64 not the url when converting. kzbin.info/www/bejne/mHrRlmZ6eZh7d8k

[@robertwilson6683]

@@ShanesCows Awesome, I took you're idea and then added ALL the base64 from images of signature pictures of everyone who could possibly interact with the APP, into a sharepoint list (Multiple line field, with 500 lines) and then used the Person field in the app to match E-Mail with a text field value in the base64 list using the Lookup to pull the specific base 64 into a field in my app to make the images dynamic. So whoever "signs" the step will have their signature appear in the pdf. However if anyone is looking to do this in their app - remember not to use a single line of text field for your base64 (I did and it took me about 4 hours to work out I had only captured a portion of the html though as I used a single line of text field initially)

[@akmalakmal7]

I have a very long HTML table, using this method, the PDF files that I got is only half of the HTML. in other word, only half of the tables is converted to PDF. Any tips?

[@ShanesCows]

You are missing a closing tag or you have some other error in your html. I have done 12 page PDFs before without issue.

[@avinoamrothenberg1244]

I followed your excellent (as usual) explanation, but I'm stuck with encoding issue. I have a demand to produce a PDF from PA app and the document has in it Hebrew (RTL). If I add even one letter of Hebrew - I get an error "Conversion of this file to PDF is not supported." when the flow is converting the HTML to PDF in Onedrive. :(

[@ShanesCows]

I have heard there are issues with some languages but I haven’t ran into it enough to try to figure it out.

[@prakashmaithani1248]

Hi Shane, can we chnage the orientation of PDF to landscape?

[@ShanesCows]

Not with the free tools. I think the 3rd party paid stuff can.

[@davemoravek]

I can't seem to find the "HTML File" Flow Step in my list of Flows. I was able to find the other two, but not that one - Is part of the standard Flows?

[@seangucken9082]

Dave, you can just use "Create File" and select the HTML text as your content, not need to use the HTML File flow part anymore.

[@ShanesCows]

Thanks for the assist

[@allanservillon7440]

​@@seangucken9082 Hi Sean, newbie here. If you don't mind, do you have any tutorial or steps that can share? Thanks in advance!

[@allanservillon7440]

@@ShanesCows Thanks for all your videos! I really appreciate it and it helps a lot! :)

[@bobakasean6940]

@@allanservillon7440 Follow Shane's instructions, but instead of using OneDrive HTML File use OneDrive Create File, folder path, file name, and content steps are the same

[@seannickell5444]

Is there anyway I can do exactly what you did in this video, but use the same method to put the picture in the top, like you did in your previous video?

[@ShanesCows]

Yes, I do it all the time. Take the first video and get it working. Then add this to the body. You got it.

[@seannickell5444]

I can add those PowerApps variable references in my html body in flow?

[@cholopa]

@@ShanesCows Done it, but still can't figure how to make it work.... Thanks for your videos, they are really helpfull!!!!. A lot of us are having problems to display the image, because we don't know how to follow the procedure you describe in kzbin.info/www/bejne/aKPJcoSbZtB-bq8 combine with the method in this video. In the first video (first method), where you insert the image, you create the html code inside Microsoft Flow. And add a variable for each value you want to pass to HTML from powerapps. In the second video (second method) you create the html code in Powerapps, and pass the full code via Flow using only one variable. For easy of use, it seems is more simple to follow the second method, ( as you don't have to create a variable for each value you want to pass to html), but for a lot of us (as I can see in the comments of both videos), it is not clear how to include in the second method an image. Can you please give us a hand?

[@cholopa]

Solved!!! In flow, Inside create file-file content, you have to add two arguments, first one like in the first method (a formula with the correct html expression, and the second one a powerapp argument like in the second method.

[@cholopa]

Just one little issue, I've been unable to center the image, even using the method suggested in w3schools... :-(

[@christopherspencer8239]

Shane, the "HTML File" PowerAutomate connector for OD4B appears to be gone... is this a change from MS? I followed to the letter and the Concat() & is a fantastic way to get something done! I'm missing that last step from flow though because that connector seems to be missing. Could you weigh in please? Thank you!

[@ShanesCows]

I think you are looking for Convert File.

[@MrBijusammathew]

Great Shane! I am working on a project where one of the columns contains pictures. How do I get it through the Flow and generate file (Word or PDF). Your current flow can be used but where and how do I convert the image to base64. Do help.

[@ShanesCows]

kzbin.info/www/bejne/mHrRlmZ6eZh7d8k

[@lathasaladi2233]

Shane, I have trouble converting the html file(dynamically pulling data from gallery) to pdf file. Only top row of gallery shows in pdf file. Please help asap.

[@Jneto52]

Hello, I would like to put an image that is taken through the camera and place it in the HtmlText and convert it into PDF through your method. But I would like to know if in the image html tags I must place or the name of the image or create a collection and place the item.

[@ShanesCows]

You need to get the file to a place Flow can see it. I have a video on powerapps Flow SharePoint that I think will help you do that then you can use this video to grab the file. 😀

[@hanchyuantan3108]

Hi Shane. How do you format number with decimal points in concat function under HTMLTEXT? Appreciate for your advice. Thank you.

[@ShanesCows]

Wrap the text in the Text function. "This is a number with decimals " & Text(varialbewithnumber, "###.00") & ". I hope it helps. "

[@hanchyuantan3108]

@@ShanesCows Thank you very much..it worked!!

[@lwhite3225]

Shane, I need this functionality SO much, thank you! Now here is my whine-du-jour. When I tried to build the flow, I don't have the "HTML File" OneDrive action (not in OneDrive nor in OneDrive for Business). Nothing comes up on a search. Mercifully, my VP just told me they put $$ in next year's budget for Professional Services!

[@ShanesCows]

Create file in OneDrive for business is what it is called. 😀

[@lwhite3225]

@@ShanesCows May I please email you some screen shots. My poor brain just cannotg keep up with you!

[@ShanesCows]

sure shane at powerapps911.com

[@lwhite3225]

@@ShanesCows Before I throw in the towel, I'm going to start at the beginning of this video - including constructing a SharePoint list to match yours. If that fails, I'll send you screen shots. If that works, I'll send you many, many, many thanks!

[@gilsongoncalves731]

Hi L. White Do you solved the problem? I have the same problema today and I`m trying to solve it. Could you help me with that?

[@videobewerker111]

Hello Shane, do you have a workflow to collect information (fill in pdf, embeded powerapp page, ...) about external users on a webpage and capture it in a SP365 list or library as searchable/viewable metadata?Forms is in our firm not yet rolled out. Word works but wordsendbuttons create security problems ('fill in-pdf' would be perfect and everywhere printable but i have to buy/'get approved' a pdf/SP365 converter). Are there easy sollutions?

[@ShanesCows]

Try out Microsoft Forms and then use Power Automate to move the responses.

[@michaelpucciarelli5025]

Hello Shane, How do you start file let's say with a header once, and then with the following add the rest of the data fields. I want this final output to be in html format. I know there is append file etc.

[@haisamrazzak9691]

As usual amazing Shane!

[@ShanesCows]

Thanks 😊

[@carloscampicchio8548]

Hi Shane, thank you a lot for your excellent videos, there must be a reason for you to have over 100.000 subscribers (a real pop star!!!). Most of what I know is thanks to you! I have a suggestion to complement the very nice serie about PDF generation: I learned for you how to generate PDF from HTML, but it should be possible using MS Word to create the PDF. I have been doing it from Dynamics 365 since a few years. I read it should be possible from Power Apps as well and I really appreciate if you could make a video on it because using Word is much simpler (at least from Dynamics). Thank you a lot again !!! Carlo Scampicchio

[@franmills2740]

Hi Shane, I've used your HTML to get the dynamic data into a table, all worked fine. But when I tried to use to include a signature at the end, as soon as I put that in ends in an error message and the table doesn't show, any ideas what I'm doing wrong? :)

[@ShanesCows]

Json function doesn’t work in that context. You will need to do the json and put it to a variable and then reference the variable

[@victorladriere2093]

Shane amazing work as usual, I was hoping for this solution for months! I’ll try this Asap. Cheers from France.

[@ShanesCows]

Cool. Glad it helped.

[@keimomon822]

Hi Shane, need help! I don't see HTML File action in OneDrive For Business. What else can be used? Kindly advise. Tenkyu!

[@ShanesCows]

If I remember right that is just the Create File action that I renamed.

[@keimomon822]

@@ShanesCows I see! GOT IT! Tenkyu for the fast assistance! Stay saye! 😊

[@rafaelcortes5290]

Hi Shane!, i am trying to send a pdf to an email, i have done everything right until the HTML, i saw the HTML file generated properly(it maintains the table color, and information), but when i check the PDF generated out of it, it does not bring the data that comes from a collection...neither maintains the colors what could be happening

[@ShanesCows]

Usually a minor typo in the html. The browser is more forgiving than the conversion process. Sorry

[@rafaelcortes5290]

Shane Young i gave up I review several times my html code and rewrote it, so after all I tried and use plumsail inside the flow et voilà!!! It worked! I don’t know why! But wanted to share this with you

[@Poetswar]

Hi Shane. I have an awesome graph in my powerapp thanks to your help. How I can get the graph in the pdf/email ?

[@ShanesCows]

I don’t think you can. 😑

[@Poetswar]

@@ShanesCows that's a shame 😥 might see if I can do something in html canvas

[@rullianrosa2076]

Hi Shane, Thank you for this amazing video. You have saved me !!

[@ShanesCows]

Happy to help!

[@joelgeorgeejoseph]

Shane, any help on page break while converting to PDF? Tables keep getting cut in between?

[@ShanesCows]

It is possible but I haven’t made a video yet. Sorry. It is a tough concept

[@joelgeorgeejoseph]

Thanks @@ShanesCows . Would be great if you could. I have found a workaround for this though, using fixed heights for the divisions, not ideal for all cases but kinda worked fine for mine. Thanks

[@darshanbagrecha7128]

HI Shane , I am able to generate HTML not pdf error saying , The file id '/PowerappsFlowDemo/SharePointNewTest.HTML' is not valid. Please Help Thank you

[@ShanesCows]

Not sure. You would need to check OneDrive and confirm the file exists.

[@murthyariga4689]

Hi Shane, thanks a lot for all your videos. I have a question ? How to add image while using the "New PDF" button ? I tried by following the other video and I was successfully and not successful while using this "New PDF" button approach. Can you please help

[@ShanesCows]

Try this video where I talk about the base64 of the images you need. kzbin.info/www/bejne/mHrRlmZ6eZh7d8k

[@marlonchristie]

Hey Shane, I got the HTML file created but when it converts to PDF the PDF is blank for some reason

[@ShanesCows]

You have a typo in your html. It is probably something really small. 😑

[@marlonchristie]

thanks @@ShanesCows had to remove the col span's in the HTML for same reason

[@lisathornton7337]

Thanks for the video. This works great...Until someone puts double quotes in one of the fields, then my HTML statement breaks. Is there an easy way to strip double quotes from a field? or replace them with a single quote?

[@lisathornton7337]

Okay, you work on it long enough, you figure it out. When I reference that entry, I just embedded it in a substitute function: Substitute(OpenDCA.Selected.CCBApprovalResponse, """", "'"). What I'm not sure I understand is why he needs 4 quotes, but it works. Thanks again for the video - this is exactly what I needed!

[@ShanesCows]

Glad you got it Lisa 🐶

[@madhum9005]

Hi Shane, when i create in mobile, PDF is not opening . when i open attachment it just shows html text but when i create in desktop no issues i can open PDF attachment. can you please help me with this.

[@ShanesCows]

This sounds like a problem with your device, not the PDF, if the PDF opens normally on your PC.

[@madhum9005]

@@ShanesCows but this happens in all mobile devices both iOS and android. I tried in 4 different mobile phones and iPad facing same issue but not in desktop or laptop

[@OneBrighDay]

Shane I am having an issue with the pdf showing as blank. The html file comes through as expected and looks fine but not the pdf. Have you run into any similar issues?

[@ShanesCows]

Double and triple check your html. Typically it is a typo that Browsers support but it he conversion doesn’t.

[@OneBrighDay]

Shane Young I found out the issue. With a more complex table when I use colspan it was stripping out the whole table.

[@rossbroadley6787]

Hi Shane! Excellent video. Got a question about the file name shown at 11:15. Is there a way that I would be able to have a dynamic file name? Such as Todays date, concatenated against 'Audit Report'. I.e, '27/-6/2019 Audit Report' Almost done with an incredibly challenging project in work, and your videos have really enabled me to get the job done. Thanks a million!

[@hitasajil3869]

In flow just click Ask In PowerApps for file name, and later from powerapps you can feed the details as you want..

[@ShanesCows]

Hita idea should help.

[@rossbroadley6787]

Thanks alot! I'll give this a go when I'm in the office tomorrow 😊

[@juanoros1209]

In flow, my html went fine, but when converted to pdf, it just showed up the first row of my table, at the same time that in html showed all of then

[@ShanesCows]

Juan the most likely reason is your html is missing a closing tag somewhere. Browsers are more forgiving that the conversion process. Check that html again.

[@ambujaable]

Thanks Shane! its much awaited one for me!, worked superb in different apps, thanks again!

[@ShanesCows]

Cool

[@pedrohenriquefontesleitao9750]

Is it possible to add an image from sharepoint list?

[@ShanesCows]

Yes, very similar approach using Get file from SharePoint action.

[@limitlessboy6423]

Hi Shane, for some reason my pdf file wont generate whereas the html file will load up with no problem. I store them in OneDrive. Sometimes the pdf file got generated but since then it doesnt work. I dont know it it‘s because of the Html Style?

[@wendymason3263]

Another awesome video, thanks so much Shane 👍

[@ShanesCows]

Glad you enjoyed it

[@wendymason3263]

@@ShanesCows Is it possible to dynamically change the filename that is created in Sharepoint? I need to create a file that is unique, for example by first name and date submitted?

[@Riddelsh]

Hey Shane, thanks for this! My table data is longer than one page and the page breaks are splitting some rows in half. Do you know of a compatible CSS statement to avoid this issue with the onedrive converter?

[@ShanesCows]

Nothing easy or that I have published. Long story short you need to figure out how many rows you have per page and split your tables. Then you need to use Div tags to declare page size. It is complicated but possible. We do it for customers quite a bit, just been to hard to share so far.

[@Riddelsh]

@@ShanesCows Thanks for the quick response! Not the one i was hoping for, but good to know it's not just my headache!

[@AndrewBradford20]

Shane - We have built an app to take pictures of a work site and document the progress of tasks. We have had the following error when too many pictures are added: "The html content length cannot be greater than 2 MB " Any idea of a work around? We have limited the amount of pictures per line item to just two photos and but have notice we still get this error at times.

[@ShanesCows]

I have a client with this issue also. :( I think we are going to use azure.microsoft.com/en-us/pricing/details/cognitive-services/ The Vision API will shrink the file to a smaller size I am pretty sure.

[@AndrewBradford20]

@@ShanesCows Any chance you can/will be creating a video about this?

[@AndrewBradford20]

@@ShanesCows Thanks for the tip. I was able to figure this out using the Vision API!

[@ShanesCows]

Cool. I still haven't gotten to play with it much.

[@GAURAVSINGH-cp4dx]

Hi Shane, can we show tooltip in PDF generated through PowerApps?

[@ShanesCows]

I don’t believe so. You might try looking into 3rd party tools

[@DemonCreest]

as you can export the same table but with the image of the signature made by the pen input.

[@ShanesCows]

Look at my json video. I cover this for you. 😀

[@jestinwegert9926]

hey shane is it possible to add a logo to the pdf. it is possible if the other video on pdf's but i cant figure it out with the dynamic pdf

[@jestinwegert9926]

Solved!

[@ShanesCows]

Nice job! Glad you got it.

[@nickchapman7562]

how did you achieve this?

[@jestinwegert9926]

@@nickchapman7562,Take a look to the other video from Shane about PDF's, So i used "Get File Content" = the Logo. Then i put dataUri(body('Get_file_content'))into "Initialize Variable" it is a string and i called it "Standaard Foto" The next step was also a "Initialize Variable" with the name: HTML en type: String. the value is: concat('') then i put this variable in Create file in onedrive infront of Createfile_CreateFileContent from powerapps. If u dont get it Watch the other video an just do the same. but put the HTML variable in Create file in onedrive infront of Createfile_CreateFileContent from powerapps.

[@frodesellevoll]

Have a question regarding saving data from powerapps to an excel form. I want to register things in powerapps, and that it is added to a new line in an excel form, and next time i register new line in excel. Is this possible? Do you have any video of this? Hope you understand what I mean :-)

[@ShanesCows]

Yes. Look for my Video on Patch. This shows adding to SharePoint but is same logic for Excel.

[@mlong1958]

I have flows that are creating to PDF, similar to this from an MS Form. The issue is that the data gets saved to my OneDrive and the user has to have permissions to that folder. My work around is using two flows, one to email the HTML file to myself and then a second flow to do the PDF conversion and then emailing it to HR. The reason is, saving to my onedrive in a folder that everyone has permissions to is unacceptable, security wise. Even though I can guarantee the HTML file would only be there for 5 seconds or so, this personal data is outside of my control. My question is, does the method you are using require the user have permissions to my OneDrive sub-folder where the file is stored? It is very frustrating that Flow runs as the user rather than as the flow owner.

[@ShanesCows]

THe HTML file will be created in the user's OneDrive. If you want to save the end PDF in a more accessible place save the PDF to SHarePoint instead.

[@huynhdatlong9846]

Thanks for sharing Shane, the html file is normal, but why the pdf file that I create, it's so small, so it just shows few columns , do you have any advises to fix that? thanks so much

[@craigwright6335]

Shane, your videos are extremely helpful. I am having an issue with the PDF created not recognizing page breaks. I’ve tried EVERYTHING I’ve found online but still no luck. I can’t even get it to work using a simple table or div code. Any suggestions.

[@ShanesCows]

Did you see my video on Page Breaks? This is how I do them: kzbin.info/www/bejne/j5y2f5ptd8SlptU

[@craigwright6335]

@@ShanesCows YOU ARE AWESOME!!!! Thank you so much. You have no idea how many hours I've spend messing with this. I wasted an entire day. I should've thought of contacting you sooner. Keep up the good work!

[@robertopolo3073]

Thank you very much for the video, it has been very helpful. I only have one query, the PDF that is generated has a vertical orientation, in my case I want a PDF with horizontal orientation to be generated, is there an option?

[@ShanesCows]

Not with the free options. YOu will need a 3rd party tool to do horizontal.

[@robertopolo3073]

@@ShanesCows Thank you very much for your answer. Yesterday I found that encodian offers the same. They offer a free account that allows you to perform 50 actions per month.

[@madhum9005]

hi shane.. The PDF doesn't show the rows of my data. I've checked for HTML and it looks good, it has all rows of data,. Can you help me with that. I checked

[@ShanesCows]

Paste your html here and I will see if I can help.

[@madhum9005]

@@ShanesCows thank you so much for immediate response. tomorrow i have demo.. i was so happy aft seeing your reply.

[@madhum9005]

@@ShanesCows " PACKING SLIP body{ font-family: sans-serif !important; padding:50px; } table{ border-collapse:collapse; } header:after { content: ''; display: table; clear: both; } .div{ padding-bottom:25px !important; padding-left:25px !important; } div{ padding-bottom:2px; } .tbl{ text-align:center; font-size: 12px !important; width:100%; } p{ text-align:center; font-weight:500; margin-top:0px; } .pad{ padding-bottom:2px; } .row{ width:65%; } .tblHeading{ font-weight:bold; } table td,table th { height: 28px !important; width: 100px !important; padding: 2px !important; } td,input,textarea{ background-color:#e4f2fb; } input,textarea{ border:none; } td:focus,input:focus,textarea:focus{ background-color:white; outline:none; } td,th{ border:1px solid ; } .tblStyle td{ border:1px solid black !important; } .tblStyle td{ border-bottom-color:white !important; } label{ vertical-align:top; font-weight:bold; font-size:13px; } .shipWidth { width:17% !important; } .customerWidth{ width:24% !important; } .rght{ float:right !important; } .left{ float:left !important; } .clear{ clear:both !important; } .qtyWidth { width:8% !important; } h2{ font-weight:550; } PACKING LIST Date: Page: "&Text( Today(), "[$-en-US]mm/dd/yyyy" ) &" 1 Sales Rep Order Number: "&UserName&" Bill To: Ship To: Ordered by: Customer PO Carrier Frt Terms Ship Date Item ID Item Description Request Quantity "&Concat(Cart,""& Item_ID &""& Item_Description &""& Requested_Qty &"") &" MTR’'S WITH SHIPMENT "

[@ShanesCows]

I wonder if you pull out the TH in the 3rd row and just make it a TD does that work better?

[@madhum9005]

@@ShanesCows no it doesn't work 🤔

[@matthewv4170]

Hi Shane, you can use the html editor to create some pretty nice emails

[@ShanesCows]

Agree 😊

[@matthewv4170]

@@ShanesCows also Shane, I found out today it's quite simple to add images using JSON to binary. You can stick it in your code and use the rest of the method you don't need to do it on powerautomate

[@kalenkito8886]

You are the best! Thank you so much for making all these videos!

[@ShanesCows]

Happy to help

[@ahmadmajdoube9742]

Hi Shane, thanks a lot for the video, I am trying to make the first step in flow, which is “ html file”, however this option doesn’t come, how should I solve this problem ?

[@ShanesCows]

I responded to your email.

[@StevenNel]

Hi Shane. Great tutorial once again. I have a small issue though. In PowerApps, the HTML table is displaying correctly, the HTML file generated looks as I would expect and displays all the information needed, but the converted PDF file only has the first row of data in the table. I thought this may be an issue with the PDF conversion in the flow so I recreated this step, however the issue is still there. Have you seen this before? Cheers, Steven

[@ShanesCows]

Yes. You have imperfections in your html. 😑 make sure you are closing your tr and table elements is usually the issue

[@StevenNel]

@@ShanesCows It was imperfect indeed.... thank you sir. The issue was the final were outside of the concat function... doh! You're a legend!

[@juanoros1209]

u save my day, thanksss

[@nehatajruli]

Hi Shane, I saw in the similar video you have added picture. How would add picture in this case and convert it to PDF. Thanks

[@ShanesCows]

Click on the first pdf video. It show the image part. Use that for the top half. 😀

[@jhl7610]

Hi @@ShanesCows how would you do it if you wanted to put dynamic picture content into the rows? I watched the first PDF video you referred to and it helps alot, BUT it only shows the use of one static picture. In my use case I have a sign in sheet, where people sign in their names and consent by generating a PenInput-Image. Both PenInput-Image and the credentials are store in a SP-library. I now want to generate a PDF filtered in a manner you display in this second PDF video, but I want to also include the signatures in the table row. Do you have an idea how to solve this?

[@galalabouelella9572]

thanks Shane that was great. I would love to see you make a video on charts in powerapps.

[@ShanesCows]

Thanks 😊

[@galalabouelella9572]

Hey @@ShanesCows the FLOW didn`t work at the convert file step it gave me this error "Conversion of this file to PDF is not supported." although the HTML file was created and worked fine.

[@anfu7965]

thanks a lot! is there a way to change the size of the pdf that is generated in the end?

[@ShanesCows]

With this free action not that I know of.

[@gjoelson]

Shane - Great Videos ! I followed your first PDF vid and now this one. I'm 98% there , but cant seem to get the logo to work, using the process on this Vid. Like I did in the first. I've added the "get file Content" and variable but still logo doesn't appear , also read the other related comments. any help - thanks!

[@brandonbarnes7169]

I'm in the same boat. I can't find a way to "inject" the variable data into the html. If I manually write in the variables from the powerapps side it thinks it is not valid html and refuses to pass the data along to flow. I get "The method 'Run' has an invalid value for parameter 'CreateHTMLFile_FileContent'". Handling the html inside of flow is the method from the last video on this subject and is difficult to get dynamic data pulled into. It feels like we've only got partial functionality using either method. =/

[@callfusion2012]

convert your logo and Use in Flow "Respond to a PowerApp" and insert that VAR in your html code ' " &VAR& " '

[@callfusion2012]

@@brandonbarnes7169 convert your logo and Use in Flow "Respond to a PowerApp" and insert that VAR in your html code ' " &VAR& " '

[@hecorat4755]

Hi Shane i do exactly and all works good except embedded image my HTML code look like this First App > when the PDF generates display the title but the image dont instead apear a cross in to a rectangle. also i try to conbine like the first video and doesnt work, so i really need a good advice Best regards

[@ShanesCows]

What if you open the HTML file. Does it display correctly? That is where I would start the troubleshooting.

[@hecorat4755]

@@ShanesCows only display the image if i use double quotes buy inthe pdf dosent display

[@naveenkumar6241]

@@ShanesCows I am facing the same issue, In my HTML file image looks perfect. But in PDF file image is missing.

[@llrconstructionllc640]

Great video!! I combined what I learned on this video with your video on barcode scanning and collections to allow for employees to scan a barcode add it to a collection and then update the collection with quantities then send the PDF to OneDrive with flow (resulting in an email being sent to me with the pdf attached due to another flow). My only problem is it only works when I perform the action. Whenever anyone else tries to use this powerapp the PDF doesn't create (the HTML in the folder doesn't even update). Do special user permissions need to be created outside sharing a folder that I'm missing?

[@ShanesCows]

Do they have OneDrive accounts is my first guess.

[@llrconstructionllc640]

@@ShanesCows, I knew it had to be something as simple as that. Thanks!

[@Thorkyn]

Hi Shane, you are using sharepoint data, but is-it possible to use sql database?

[@ShanesCows]

Yes, works 100% the same with SQL.

[@kyle1449]

Hi Shane, is there a way to use an in the pdf? i tried using the logic in your other PDF video but i cant use the concat function to add the html into the flow because the html has variables from powerapps in it (about 30 of them, thats way too much to bring into flow)

[@ShanesCows]

Yes you can put the base64 version of the file directly in the html.

[@KhushbuKumari-je9dm]

How to generate pdf where the PowerApps user doesn't have permission to the SharePoint list where pdf is getting saved?

[@ShanesCows]

You would need to create another flow that gets triggered to move the file to the secure location. If user doesn’t have permission nothing you can do

[@CarbonFlight]

Shane, can you explain how to go about converting an image to base 64 then adding it to the html?

[@ShanesCows]

If it is just a single image one time use a website like this to do www.base64encoder.io/image-to-base64-converter/ if not the JSON function can do it in PowerApps

[@dimitrijanssens9637]

Hey Shane - Quick question on the video. Would you have any idea why on the first time I try to pass the content. Flow doesn't capture it. Although when I strike the button the second time all get passed correctly. In detail the html layout gets captured but the data from the repeating table doesn't and on the second run all works perfectly.

[@hecorat4755]

Hi Shane i need to add and image to the PDF, should i add the image like the first video or i can add the code on the HTML code directly? best regards

[@ShanesCows]

Either way will work. I would probably do it like the first video if it was me.

[@hecorat4755]

@@ShanesCows its me again Shane i have a bad news it doesn't work the image appear with a cross :( May I please email you my flow & HTML code.

[@alonyaakobi3975]

Hey Shane! I'm trying to get data from PDF table to collection in power app , can you please help me?

[@ShanesCows]

Not possible that I know of. Sorry :(

[@brianl3632]

Great instructions, Shane. Question: Rather than having the user press a button in the app to generate the html/PDF, I'd like for Flow to do that automatically when (let's say) the document's status equals Approved. So how would I tell Flow to do a GET of the HTML control's content and then do the file creation? Similar in your first video where we do a GET of that logo. How would we do a GET of that control's HTML that's in the app?

[@ShanesCows]

You can’t. If you want Flow to do all of the work you will have to get all of the html into the Flow. It is possible

[@BrendonBrooks]

Man, that's gonna save me a whole lot of time. Thanks Shane!

[@ShanesCows]

You are welcome.

[@muhammednaseefmuttoon2905]

Shane. how I can add image here in pdf?????????? plz help me

[@ShanesCows]

Look at the other pdf video. That is covered there.

[@michaelrjrobinson]

Hi Shane, Thank you for your video, this has helped me out no end. I am having a little issue where the converted PDF is not showing all of the data. I have HTML that shows a table of data from a gallery, when this is opened as the HTML file all is fine. When I open the PDF it only shows the headers for the table and the first row of data from the gallery. Do you know what could be causing this? Thank you

[@ShanesCows]

Usually it is because you are missing a clossing tag. CHeck your tags.

[@Javierzorromorales]

@@ShanesCows It is correct, I had the same problem and it already works, thanks

[@antonygio716]

Hi Shane, As always, great Video. I seem to be doing something wrong or have missed something in the details. I have an almost identical project as your demo, I need to print a delivery note. All works well into FLOW right up to creating PDF. All Headers and Rows appear in the HTML file however only Headers and first row convert to PDF. When creating the HTML file in my Onedrive , I ask power apps and only the “Create_FileContent” is presented and not the “HTMLFile_FileContent” as showen in the Video. However, the HTML file is still created correctly. I am creating the PDF in the same Onedrive directory as the HTML file however as I mentioned earlier, I only get the headers and one row. Any Ideas on what I messed up on.? Thanks Shane

[@antonygio716]

Hi Shane, all sorted. I took another look at my HTML syntax. Was using incorrect code to end row instead of . Hence only one row being migrated to PDF. Strange that the code did not hilight as an error in the HTMLtext.

[@ShanesCows]

Glad you got it Anthony!!!🤩

[@JoaoSantos-vd2cn]

Great Video. One question, it is possible to add footer with page number and total page number? Without premium or paid connectors

[@yannickhirt4902]

Hi Shane, I wanted to ask if it is also possible to create several pages/sheets based on a Sharepoint list and create a PDF from them. And to automatically create new sheets/pages when a table overflows.

[@Gravelrash]

Hi Shane Ok, daft question coming up. I create the app and want my colleagues to use it, do I need to give them access to the folder within my OneDrive or is there a way that it will use the users own OneDrive for converting the file to PDF. As per your video the file needs to end up in SharePoint. Thanks

[@ShanesCows]

It will create on their OneDrive so you should be good.

[@84costanza]

@@ShanesCows What if they don't have OneDrive? Is that a requirement for this to work?

[@JoseRamirez-uh6ck]

can these be landscape?? not portrait?

[@ShanesCows]

Not that I know of. 😑

[@JoseRamirez-uh6ck]

@@ShanesCows thanks! I believe i found a solution for this. instead of using html i used a fillable word file, converted to pdf and that did the trick. Thank you for your response.

[@MichielEngelberts]

Hi Shane, thanks very much for your video's, all of them. I got things working out. Only thing is, I want to combine the functionality of this video and the previous one. Meaning I have a gallery with SP Online attachment images and I want all the images per list item in a PDF. I get everything done only the images are not showing. (little red annoying crosses) I have to use the steps like you described in your previous video only with an apply to each combination. Is that in any way possible? Thanks in advance!

[@ShanesCows]

I haven't done it but should be possible. I would start simpler. Can you use an image from SharePoint as an image in PDF? If it doesn't show up in the PDF does it work in the HTML file?

[@MichielEngelberts]

@@ShanesCows Hi, Yes. I did manage to create a simple flow which gets an attachment (image) from a SP Online list item, puts it in a HTML file and convert it to a PDF. That's brilliant, thanks for that. Then I put a few extra steps in the flow, the apply to each. The situation is described here: bit.ly/2RP9cef I just cannot get through the apply to each steps. A single image is no problem.

[@nipun399]

Can we add multiple images in the table and then convert to PDF?

[@ShanesCows]

Yes up to a 2 MB total html size limit.

[@mjr7991]

Two questions: 1) Since you can create tabular data, is it possible to create an excel file instead of pdf? 2) Is there a way to have the newly created pdf file automatically open once created? thanks

[@ShanesCows]

1 - You could use Flow to write to rows in an Excel. 2 - Use the Launch function to open the PDF.

[@spuds518]

Hey - thanks for all of the great content. Wondering if you could answer a question or point me in right direction. My requirement is to be able to attach the PDF to an email so it can be sent to users outside our organization. I used Get File Content, then the File Content in the attachment control of my email and it comes through in unreadable format. I can select to open it using Adobe on my desktop, but it's a no go on mobile device. Any ideas?

[@ShanesCows]

Check out my Concat video or my pen input videos. I think both talk more about this. Not sure why it wouldn’t work on a mobile. Have you tried a known good pdf of the same mobile.

[@azeradinsin6873]

Hello, would you mind sharing the FileContent expression code for flow in the description? :)

[@ScottRosenbloom]

These two videos have been EXTREMELY helpful. What I wanted to ask about was creating a multipage PDF and being able to specify where the page break occurs. It looks like the standard HTML command for page break is NOT honored in Power Automate. I tried the idea of creating multiple PDFs, but there's no Action in flow to combine multiple PDFs into a single PDF, that you don't have to pay for. Any thoughts on either of these approaches?

[@ShanesCows]

Hey Scott. Page breaks in PDFs is a pain. It is possible but you have to make a giant DIV. I will put this back on my list of videos to make.

[@levin3722]

@@ShanesCows Hi Shane I have the same question.. Have you a idea how i can do that ? I habe a gallary with 200 Items and i want create a bill over multiple sites with the same header. Is this possible with html or pdf ? Thanks !

[@davidemercadante2406]

Hi Sean, Sorry to bother you again. First of all thanks again for all your great work. I am having an issue trying to create a pdf report. To explain, I have a collection where I have all my projects/status/ details/etc. and another collection where I have all items for each project linked to the first collection via project ID. In my report I have been able to create an HTML tablelands for the projects and then I would like to have one table for each project including all the items/each. I have been able to create multiple tables using nested concat, but unfortunately all tables present only items of the first project. Any thoughts how to solve this? Thanks, Davide

[@ShanesCows]

You would need to review your COncat. Somehow you aren't getting the data you think. Try to fix one Concat before nesting. Maybe this vdieo helps kzbin.info/www/bejne/d5-og5l9fqprndk

[@davidemercadante2406]

@@ShanesCows That’s why you’re one among the greatest and I am one of the beginners. Thanks for the suggestion. I saw your video and I had I had a breakthrough. I’d like to use the Concat before the declaration so that the code should create a table for all different project IDs. I have to test it, but I don’t see why it shouldn’t work.