PowerApps PDF from table data

[@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. 😀

[@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.

[@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. 😎

[@sofiejensen3804]

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

[@ShanesCows]

You are so welcome!

[@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

[@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. 😹

[@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]

😎

[@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?

[@mobil88reporting47]

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

[@ShanesCows]

Thanks 😻

[@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.

[@haisamrazzak9691]

As usual amazing Shane!

[@ShanesCows]

Thanks 😊

[@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?

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

[@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.

[@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.

[@JoaoSantos-vd2cn]

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

[@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.

[@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

[@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

[@rullianrosa2076]

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

[@ShanesCows]

Happy to help!

[@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

[@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

[@jalalsemaan8129]

Great tutorial! Thank you Shane.

[@ShanesCows]

My pleasure!

[@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

[@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

[@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

[@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

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

[@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

[@flogan2000]

Hi Shane, have learnt a fair old amount from your videos so thank you. Quick q have you found a way to get round if there's more rows than fit on a page. It cuts a row in half at the bottom of page 1?

[@ShanesCows]

That problem is the worst. I have things I do but nothing I am ready to share yet. Hopefully soon because it makes me angry.

[@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

[@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

[@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

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

[@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

[@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)

[@adrianaliyuddin4555]

Hi Shane! Love your videos. I'm working on a project which I believe combines what you have here and the video on the JSON function. I'm at a stumbling block. Basically, I have a collection with three items, Name (text), ID (text), and Signature (pen input). I am trying to build an HTML table with the data. Can I fit the JSON function in the Concat function to build the table? Or do I have to use the Concat function for the text and a separate table data for the JSON function for the image?

[@ShanesCows]

Try this video kzbin.info/www/bejne/iHe9l6mKqqmghpI and there you will learn about the base64 you need.

[@ambujaable]

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

[@ShanesCows]

Cool

[@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.

[@kalenkito8886]

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

[@ShanesCows]

Happy to help

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

[@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

[@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.

[@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.

[@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 🐶

[@rnavarrette2010]

Was working on this from your fist video and we ran into an issue with the conversion to .PDF as the HTML that generates is landscape as you show also and wanted the .PDF to show in portrait like you show but the PDF with tables seem to come out very wrong looking with the table all out of order. So nothing lined up correctly. Shane did you run into this at all also? Also ran into the same issue with the table border not showing in .PDF and did not get corrected from flow. Maybe doing the HTML in PowerApps will solve? We are planning on on using just the HTML as the deliverable for now.

[@larsvanginkel3438]

Hi Shane, Once again, great solution, thanks. Before I start implementing, will a Powerapps Per App (p1) license suffice for a user to run the flow or is additional flow licensing required?

[@ShanesCows]

Everything in this video works with the standard (aka free) license. 😎

[@julienf1162]

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

[@ShanesCows]

Yes, works 100% the same with SQL.

[@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.

[@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.

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

[@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.

[@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

[@Hitesh222-c7n]

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

[@spencercooper4546]

Your videos and solutions are superb. Thank you kindly.

[@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.

[@jhonatanorabadillo]

Hi Shane! Thank you very much for share knowledge. Your tutorials have helped me a lot. I would like to make two inquiries, please. could you help me with both? The first is to know if I can attach the PDF file that I generate in the OneDrive and send it by mail to our clients. On the other hand, is there a way that PowerApps can filter through a login screen to customers and thereby view their information? Beforehand thank you very much. A hug!

[@ShanesCows]

Yes you can attach the pdf. Use the Outlook Send email option and then specify the file you created as the attachment.

[@jhonatanorabadillo]

@@ShanesCows thanks for your answer. Could you tell me how I should do it, please, because until now I can only capture as an attachment the photos we take with the app, but the PDF always comes out with the same name and this should also change depending on the work being attended to.

[@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

[@sdbr8998]

Very helpful, Shane. I've been able to get this to work for everything except a nested gallery. Do you know if it's possible to export a nested gallery to PDF?

[@ShanesCows]

Yes, I cover it in this video kzbin.info/www/bejne/d5-og5l9fqprndk

[@sdbr8998]

@@ShanesCows That did the trick, Shane! However, I noticed that the nested gallery (the one inside the main gallery) doesn't seem to refresh the HTML object when you change selections. The gallery itself displays properly in PowerApps, but the HTML object and, subsequently, the PDF does not. I tried using the Reset function, but that only works for the top-level gallery. The workaround I've found is to refresh the browser after printing each time, which takes the user back to the app home page, but obviously that's inconvenient and they have to remember to do it. Is there any way to reset both levels of a nested gallery? Thanks again for your invaluable videos and assistance!

[@dondoyle6200]

Great video and delivery! Thank you!

[@ShanesCows]

Thanks Don! 😍

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

[@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.

[@olivaadak]

Thank you so much you are a life saver ❤

[@ShanesCows]

Glad it helped.

[@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

[@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.

[@franklinjunaylemus6397]

Hi Shane, thank you so much for your videos! Will other users be able to use the application since there is a connection to my personal OneDrive? I have been trying different ways to go from the HTML file straight to PDF in SharePoint but have had no success.

[@ShanesCows]

It will create in each users OneDrive. Or you can create it in OneDrive then move to SharePoint

[@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?

[@BrendonBrooks]

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

[@ShanesCows]

You are welcome.

[@hudongwang7550]

Great! Thank you very much.

[@ShanesCows]

You are welcome!

[@csrfear]

Hi Shane, thank you for all these great PowerApps (Power Apps) videos. Is there a way of opening the file automatically after clicking on "Create PDF"? In other words does Flow or Power Automate have a launch type feature that allows the web browser to decide how to open the file automatically?

[@ShanesCows]

Return a link to the file to powerapps then launch the url. Let me find the video where I show that.

[@ShanesCows]

PowerApps Flow Intro Upload an image to SharePoint using Flow kzbin.info/www/bejne/paeveqqkn5uEoLc

[@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! 😊

[@pedrohenriquefontesleitao9750]

Is it possible to add an image from sharepoint list?

[@ShanesCows]

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

[@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.

[@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.

[@chairutsirirut5787]

Hi Shane Excellent Video! I currently watched this video and follow all the steps and I got the PDF file which I created. But the problem is the flow does not understand my language which is Thai. Is there any way to cope with this issue?

[@ShanesCows]

Not that I know of. 😕

[@chadstone345]

Hi Shane, thank you for this was very helpful video. quick question regarding this, I was looking for similar solution at my work but the twist is when saving pdf to sharepoint list it needs to save like user ID and bunch of extra data so user can view pdf in power apps for that particular record. So can we use sharepoint list to save pdf and view back that pdf for a particular record. Also not sure if sharepoint list can handle 9k pdf in total.

[@ShanesCows]

Short answer is Yes. Try changing your file name to be dynamic content in flow, then create the dynamic content that matches the pattern you want.

[@frenamakenson9844]

Amazing Video... thank you

[@ShanesCows]

You are welcome!

[@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

[@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.

[@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.

[@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

[@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.

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

[@myipkiss]

Hi Shane, Great video. I have followed the step exactly as above. However, when I updated the file in power apps, the pdf file created in the share point was not updated. Any possible reason why? Appreciate your feedback. Thanks

[@ShanesCows]

No. I use this technique a lot and don't have that problem. Maybe change the filename you create in Flow to see if creating a different file has issues.

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

[@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

[@WanabY85]

Hi Shane, Great video. It worked for me. I do have one question. I have a table of two pages long. Is it possible to generate a page break in power apps or power automate? Thanks in advance

[@ShanesCows]

Yes you can but it is complicated. I need to cover it in a video one day. You have to define your pages with divs and then get the content in the div. It is so tricky I have only taught it in my advanced class so far.

[@pipelox]

@@ShanesCows It will be awsome to watch this video! I have the same problem with page break :(

[@dennisbersuch1464]

Thank you for this perfect video. I have an issue because the table is too large, so there is a 2nd site in the PDF file. Do you have an idea how to put sitenumbers on each site in the PDF file (for example site 1 of 2, site 2 of 2) ?

[@ShanesCows]

Not sure. I would find a way to add it as a table header or add it to your table data.

[@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.

[@azeradinsin6873]

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

[@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.

[@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.

[@jestinwegert9926]

hey shane! great video. question, Is it possible to convert an gallery with text and images to a pdf,? That would be amazing. looking forward to ur next video!

[@ShanesCows]

YEs, but you would have to write all of the HTML.

[@jestinwegert9926]

@@ShanesCowsMaybe an idea for a video

[@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. 😀

[@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!!!🤩

[@jackiieriivero8999]

Hola Shane tus videos siempre me ayudan muchisimoo pero esta vez no pude encontrar la opcion en Automate de HTML File tendrás alguna otra opcion que la reemplace

[@ShanesCows]

OneDrive for Business - Create file action is what you are looking for.

[@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

[@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.

[@henrikanker4598]

Great video!!! Thanks. Is it possible to make the filenaming in power automate dynamic with data from the HTML?

[@ShanesCows]

Sure. The filename just has to be a text string you pass. YOu can make it anything you want.

[@ethanwang9178]

@@ShanesCows Hi Shane, that is really nice video!! Here I got the same question, how do i dynamic the pdf file name by my dropdownbox in Flow? Thanks!!