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 !!!
...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!!
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!!
Hello shane. Since I started venturing into the world of powerapps you have been my sensei lol. I love your videos, thanks for sharing the knowledge. Shane, the Collect function you use at the beginning of the video, works also with excel spreadsheet or will I have to migrate my data to sharepoint? Thanks
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
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.
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 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!
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?
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
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 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 !
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
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?
Give this a look for ideas. ua-cam.com/video/kLGglidmPxg/v-deo.html choices wouldn’t be inside the filter. You would be filter(datasource, choicecolumnname.value = “red”)
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!
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?
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?
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
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 ua-cam.com/video/AnERfGIE8gw/v-deo.html
@@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.
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?
Hi Shane, I have a combo box on my app, and it has to be one for multiple choices, and I can't seem to get it to work. Even when I used SelectedText.Value any idea what the problem is?
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 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.
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? :)
Awesome video thank you so much!! I found another video where I did this but the person making the video did not explain how the dynamic HTML worked. YOU DID!!! Yay, I actually understand what I did today. Now I just have to add a barcode to the dynamic table. I’m using the barcode column in Sharepoint and I want to create a record in PowerApps, send it to Sharepoint to create the barcode, show the barcode in PowerApps and then click Make PDF button. I have everything working except the barcode doesn’t render on the PDF. I found another of your videos where you used the image text from an attachment to copy the image to another attachment box (I think that’s what you did)....I was thinking of trying that for the barcode image. Any thoughts? Also, what if I want my table to grow across and not down? Is that just an HTML thing? I’m PowerApps, not an HTML person. Thanks so much for all you do and share!!! Rockin the PowerApps you are.
I have never tried the barcode that way but I am sure the answer is you have to get the base64 version of the barcode image to get it to work in html. 😐
@@ShanesCows Hi Shane! I was able to get the barcode to render in HTML based on a URL....but when I try to convert it to PDF in PowerAutomate it does not work. I don't know how to get the base64 version of a URL image. Any advice?
Hi Shane, You make learning Power Apps so much easier! Is it possible to create a PDF for a single SharePoint list item and not the entire list? Thank you, thank you!
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.
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.
@@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!
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.
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
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?
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?
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.
@@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
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!
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?
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?
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 ?
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?
Hey Shane. First, your videos have helped me a ton, so thank you. Second, I'm having an issue with this one and I'm wondering if you've come across it. I have the flow set up the same as you do, but when I run it, I just get a blank PDF. When I open the HTML file it shows my data and styling perfectly, so I'm not quite sure why my PDF is blank. Is there something specific you might know of on the file conversion that might not be working?
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.
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.
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
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. :(
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 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!
@@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
Shane, thank you for these videos!! I have watched quite a few and they are very helpful!!. I do have a question though. I am trying to use HTML to create a PDF from Powerapps like you did in this video. However, i am trying to have some of my rows expand across multiple columns in my table. I used the HTML website you recommended and I could get the HTML code to work. But, Powerapps does not seem happy with the code to the point I don't have an error, but my table does not show up on the pdf. Do you have any suggestions?
does work. I would recheck your other tags in the table and make sure you have 3 columns to span. It works, just have to find the character that is out of place.
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 :-)
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 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)
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?
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
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.
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?
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.
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.
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?
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 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!
Hi Shane, your video are Always very helpful. I would like to ask you a question: is there a way to save this HtmlText as a pdf file to OneDrive? Thanks in advance for your help!
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.
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.
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?
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!
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
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
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.
Shane, if were not for you, I do not think I would consider PowerApps. Thanks for the great videos. Is there a way that I can pass the PDF filename to flow?
Great videos, Shane! Many thanks for creating this. I have one problem though, it looks my table / data has Chinese language, and it failed to convert to PDF. It is succeed to create the HTML files but failed on the said steps. Any food of thought ? Thanks again
Thank you so much for this Shane. Absolutely loved it. I was able to convert my share point forms into pdf with this. I had a small question, is there a way to create custom names for pdf instead of them overwriting the previous file. I want to create a new pdf every time a pdf button is clicked. Best regards
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) ?
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.
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)
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
Hi Shane, thanks for sharing such useful knowledge, your videos are very helpful. Could you please explain in a video how to send to a printer a form? For example, it could be nice in a checkin app, to print in a physical label the data inserted in the registration form (like a temporary badge for guests). I know that currently there's no such service in powerapps and I ask you if this is possible indirectly, or if there's a way to overcome this gap. Thanks in advance.
Hi Shane, Thank you for sharing this video. It's really helpful. How can I get 'HTML File' in One drive because I couldn't find it under One drive? Another one I'd like to know is how can I add a signature to PDF dynamically from powerapps. I could save the file to jpg but when I open the file it says file format is not supported.
This will help with this signature ua-cam.com/video/bIne3DD3HAg/v-deo.html This might help with your OneDrive question. ua-cam.com/video/2rfAQe1kK8M/v-deo.html
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
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.
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.
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?
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!
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.
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 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.
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
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.
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
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
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?
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.
Hi Shane! Thank you sooooo much for this! It has been an amazing guide in helping get my employer's invoicing system automated. Everything has worked up until the HTML textbox. My HTML when tested through the w3schools website only produces one page, and when I paste the static HTML text it also only produces one page in PowerApps. When I start using the "Concat(Gallery1.AllItems..." text, it appears to be creating a new html page for each item as well as adding a row to the table. Any thoughts on how to correct?
@@ShanesCows Thank you for the feedback, Shane! I'll dive deeper into it. Do you happen to know the limit or threshold for HTML text in the Concat? It is a pretty long one.
Hi Shane, thank you for all of your great videos, they have saved me many hours! I am working on a project where we need both text and photos converted to PDF on the same page. I am having a hard time with getting the photos to load in dynamically. Have you had any luck with this? I am stuck with the format, it is currently in a blob format since the data we use is in SQL database. Any hints would be greatly appreciated. Thanks again for the great videos!
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
Shane, absotively wonderful vid. Probably you've covered this before, if so, sorry to repeat the query: How can I send an existing PDF in SharePoint documents via email using Office365.SendMail? I've started pulling my hair out (no more nails left). Can this be done NOT using Flow?
Hi Shane! Lot's of thanks from Spain! As everybody here, I'm a fan of your videos: so useful and easy to follow. But in this specific case, I'm facing one issue with the step "convert file using file". The html file seems to be created in OneDrive without any problem (indeed I opened it in a browser and it shows me the table I created in Html in Powerapps), but when I run the flow it fails in the following step with the message "Conversion of this file to PDF is not supported." For this step, I used "Convert file using path" and specified "Path" (with OneDrive icon) in the field "File Path" and then I chose "pdf" as Target type. What am I doing wrong? Thank you again for all the good work! Hasta luego! :-)
This is an excellent video, and explains the process clearly. I have used this to enhance a fairly complex app which I am building for a Uk Charity. However, I am struggling getting the HTML to output the dates in UK format (DD/MM/YYYY) as opposed to the US (MM/DD/YY). The dates are in UK format within the App, so I am not sure how this has come about.
That is odd. I have an app for a UK company and my dates show in their format. What are you using to format the dates? Text(Today(), "dd/mm/yyyy") should work.
@@ShanesCows broadly that format except I can't use Today () as I am doing an app which is for planning ( past and future meetings etc). I will double check. Organisation is using O365; Browser is chrome or IE, platform W10. All my dates for out ok in forms etc- I am just curious if I am missing a tag to get the HTML to render a different date format.
Shane, this is driving me nuts! Part of my app records the dates of Meetings (AGMs= Annual General Meetings"; field is called "AGMDate". The data is held in a Sharepoint list, and the underlying field is in Date/Time format. When I enter the formula: Text(AGMDate,"DD/MMM/YYYY"), as you suggested, PowerApps changes the formula to Text(AGMDate,"[$-en-US]DD/MMM/YYYY"). I have tried to force it into $-en-UK, but this doesn't work! When checking the underlying data, it is correctly in the DD/MM/YYYY format Any thoughts?
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 !!!
Thanks. Yeah, finally a year ago I finally figured out Inline Styles were the answer. 😎
...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!!
Congratulations! I promise the next one is easier. 😀
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!!
Thanks Aaron! Have a great weekend
Fast forward 2020.someone giggles knowing even the great shane young gets a debugging moment during UA-cam video.. thank you bro
Glad to keep you entertained. I know that is all cats want from us humans. 😹
Thank you! I especially like that you also are honest and show your mistakes!
You are so welcome!
Hello shane. Since I started venturing into the world of powerapps you have been my sensei lol. I love your videos, thanks for sharing the knowledge. Shane, the Collect function you use at the beginning of the video, works also with excel spreadsheet or will I have to migrate my data to sharepoint? Thanks
Should work with Excel
Great Video. One question, it is possible to add footer with page number and total page number? Without premium or paid connectors
it's 2020 and shane young's video is still the "go-to" video for people with powerapp issue
Thanks 😻
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
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.
@@ShanesCows It will be awsome to watch this video! I have the same problem with page break :(
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!
Create file in OneDrive for business is what it is called. 😀
@@ShanesCows May I please email you some screen shots. My poor brain just cannotg keep up with you!
sure shane at powerapps911.com
@@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!
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?
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?
Everything in this video works with the standard (aka free) license. 😎
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
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?
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.
@@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 !
Thanks a lot for the video. How can I show this generated pdf in power app pdf control?
YOU ARE THE KING SHANE, AND POWERAPPS IS THE SKY
😎
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
Yes. You have imperfections in your html. 😑 make sure you are closing your tr and table elements is usually the issue
@@ShanesCows It was imperfect indeed.... thank you sir. The issue was the final were outside of the concat function... doh! You're a legend!
u save my day, thanksss
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?
Give this a look for ideas. ua-cam.com/video/kLGglidmPxg/v-deo.html choices wouldn’t be inside the filter. You would be filter(datasource, choicecolumnname.value = “red”)
I got the same issue!!
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!
I think you are looking for Convert File.
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?
Return a link to the file to powerapps then launch the url. Let me find the video where I show that.
PowerApps Flow Intro Upload an image to SharePoint using Flow ua-cam.com/video/ovLIwnj6QjU/v-deo.html
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?
Try this video ua-cam.com/video/RFZfvTuDmP0/v-deo.html and there you will learn about the base64 you need.
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
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 ua-cam.com/video/AnERfGIE8gw/v-deo.html
@@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.
Shane amazing work as usual, I was hoping for this solution for months! I’ll try this Asap. Cheers from France.
Cool. Glad it helped.
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?
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
Hi Shane, I have a combo box on my app, and it has to be one for multiple choices, and I can't seem to get it to work. Even when I used SelectedText.Value any idea what the problem is?
This video should help ua-cam.com/video/pjs0ZsnJZXo/v-deo.html
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!
Yes you can attach the pdf. Use the Outlook Send email option and then specify the file you created as the attachment.
@@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.
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? :)
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
Awesome video thank you so much!! I found another video where I did this but the person making the video did not explain how the dynamic HTML worked. YOU DID!!! Yay, I actually understand what I did today. Now I just have to add a barcode to the dynamic table. I’m using the barcode column in Sharepoint and I want to create a record in PowerApps, send it to Sharepoint to create the barcode, show the barcode in PowerApps and then click Make PDF button. I have everything working except the barcode doesn’t render on the PDF. I found another of your videos where you used the image text from an attachment to copy the image to another attachment box (I think that’s what you did)....I was thinking of trying that for the barcode image. Any thoughts? Also, what if I want my table to grow across and not down? Is that just an HTML thing? I’m PowerApps, not an HTML person. Thanks so much for all you do and share!!! Rockin the PowerApps you are.
I have never tried the barcode that way but I am sure the answer is you have to get the base64 version of the barcode image to get it to work in html. 😐
@@ShanesCows Hi Shane! I was able to get the barcode to render in HTML based on a URL....but when I try to convert it to PDF in PowerAutomate it does not work. I don't know how to get the base64 version of a URL image. Any advice?
Hi Shane, You make learning Power Apps so much easier! Is it possible to create a PDF for a single SharePoint list item and not the entire list? Thank you, thank you!
Try the other video? ua-cam.com/video/2rfAQe1kK8M/v-deo.html but yes is the answer
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.
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.
@@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!
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.
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.
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
Try this video where I talk about the base64 of the images you need. ua-cam.com/video/bIne3DD3HAg/v-deo.html
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?
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.
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?
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.
@@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
Hi Shane. I have an awesome graph in my powerapp thanks to your help. How I can get the graph in the pdf/email ?
I don’t think you can. 😑
@@ShanesCows that's a shame 😥 might see if I can do something in html canvas
Really Nice video Mr Shane, I would like to ask you I have inserted a Data Table Control from PowerApps, is it possible to print it into PDF?
Not the control but the data only by this method.
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!
YEs, but you would have to write all of the HTML.
@@ShanesCowsMaybe an idea for a video
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?
Double and triple check your html. Typically it is a typo that Browsers support but it he conversion doesn’t.
Shane Young I found out the issue. With a more complex table when I use colspan it was stripping out the whole table.
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?
Not that I know of. 😕
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 ?
You would have to write if logic to account for the blank
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?
You are missing a closing tag or you have some other error in your html. I have done 12 page PDFs before without issue.
Hi Shane, can we chnage the orientation of PDF to landscape?
Not with the free tools. I think the 3rd party paid stuff can.
Hey Shane. First, your videos have helped me a ton, so thank you. Second, I'm having an issue with this one and I'm wondering if you've come across it. I have the flow set up the same as you do, but when I run it, I just get a blank PDF. When I open the HTML file it shows my data and styling perfectly, so I'm not quite sure why my PDF is blank. Is there something specific you might know of on the file conversion that might not be working?
Never mind, I figured it out. OneDrive's convert feature didn't like the style element I put in my header. Strange thing for it to not convert..
Awesome. Yeah conversions are weird and picky.
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.
It will create in each users OneDrive. Or you can create it in OneDrive then move to SharePoint
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.
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
Thank you I found an extra and that solved the issue! I appreciate your help and videos!@@ShanesCows
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. :(
I have heard there are issues with some languages but I haven’t ran into it enough to try to figure it out.
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.
Did you see my video on Page Breaks? This is how I do them: ua-cam.com/video/YkSNg7B_rps/v-deo.html
@@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!
Hi Shane, you can use the html editor to create some pretty nice emails
Agree 😊
@@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
Shane, thank you for these videos!! I have watched quite a few and they are very helpful!!. I do have a question though. I am trying to use HTML to create a PDF from Powerapps like you did in this video. However, i am trying to have some of my rows expand across multiple columns in my table. I used the HTML website you recommended and I could get the HTML code to work. But, Powerapps does not seem happy with the code to the point I don't have an error, but my table does not show up on the pdf. Do you have any suggestions?
does work. I would recheck your other tags in the table and make sure you have 3 columns to span. It works, just have to find the character that is out of place.
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 :-)
Yes. Look for my Video on Patch. This shows adding to SharePoint but is same logic for Excel.
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.
You have to use the base64 not the url when converting. ua-cam.com/video/bIne3DD3HAg/v-deo.html
@@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)
Hi Shane,
Thank you so much for the above video and your replies, i would like to attend the power App training when will be the next training.
You can email me Shane at PowerApps911.com and I will get to more info.
@@ShanesCows Thank you
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?
Check your html. 9 times out of 10 it is a minor typo in html.
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
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.
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?
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.
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.
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.
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?
Try out Microsoft Forms and then use Power Automate to move the responses.
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?
Yes, I cover it in this video ua-cam.com/video/AnERfGIE8gw/v-deo.html
@@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!
Hi Shane, your video are Always very helpful. I would like to ask you a question: is there a way to save this HtmlText as a pdf file to OneDrive? Thanks in advance for your help!
I tried your tutorial, but the pdf generated is blank even if there's come code in it. Could you please give me a hint?
Did you see this video? That is 100% what we cover in part 1. ua-cam.com/video/2rfAQe1kK8M/v-deo.html
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.
ua-cam.com/video/bIne3DD3HAg/v-deo.html
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.
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?
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!
In flow just click Ask In PowerApps for file name, and later from powerapps you can feed the details as you want..
Hita idea should help.
Thanks alot! I'll give this a go when I'm in the office tomorrow 😊
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
I covered this in my latest video where I answer comments and yours was one of them. 😀 ua-cam.com/video/8eoaSsXnh6Q/v-deo.html
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
Not sure. You would need to check OneDrive and confirm the file exists.
Hi Shane, you are using sharepoint data, but is-it possible to use sql database?
Yes, works 100% the same with SQL.
thanks Shane that was great.
I would love to see you make a video on charts in powerapps.
Thanks 😊
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.
Shane, if were not for you, I do not think I would consider PowerApps. Thanks for the great videos. Is there a way that I can pass the PDF filename to flow?
Yes. Make the Filename an “ask in PowerApps” to pass the name across.
Great videos, Shane!
Many thanks for creating this.
I have one problem though, it looks my table / data has Chinese language, and it failed to convert to PDF. It is succeed to create the HTML files but failed on the said steps.
Any food of thought ?
Thanks again
Look for HTML typos. Typically not closing a tag is the culprit. The conversion process is VERY picky.
Thank you so much for this Shane. Absolutely loved it. I was able to convert my share point forms into pdf with this. I had a small question, is there a way to create custom names for pdf instead of them overwriting the previous file. I want to create a new pdf every time a pdf button is clicked.
Best regards
Yes, Ask in Power Apps for the name of the file. :) THat way you could make each name unique
@@ShanesCows thanks a ton :)
Nice video Shane,its very helpful.Thanks a lot.I have one question how to add background image into pdf with power apps or ms flow.
Yikes. I haven’t tried and based on how the conversion process works I doubt it is possible. Let me know if you figure out anything
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) ?
Not sure. I would find a way to add it as a table header or add it to your table data.
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.
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)
Yes you can put the base64 version of the file directly in the html.
Hi Shane, can we show tooltip in PDF generated through PowerApps?
I don’t believe so. You might try looking into 3rd party tools
Hi Shane, Your videos are really helpful. I had a query regarding exporting the values present in a datatable to excel. Will that be possible?
Yes with Flow
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
Hi Shane, thanks for sharing such useful knowledge, your videos are very helpful. Could you please explain in a video how to send to a printer a form? For example, it could be nice in a checkin app, to print in a physical label the data inserted in the registration form (like a temporary badge for guests). I know that currently there's no such service in powerapps and I ask you if this is possible indirectly, or if there's a way to overcome this gap. Thanks in advance.
Not possible today but they are hopefully working on it. :)
Hi Shane, Thank you for sharing this video. It's really helpful. How can I get 'HTML File' in One drive because I couldn't find it under One drive? Another one I'd like to know is how can I add a signature to PDF dynamically from powerapps. I could save the file to jpg but when I open the file it says file format is not supported.
This will help with this signature ua-cam.com/video/bIne3DD3HAg/v-deo.html This might help with your OneDrive question. ua-cam.com/video/2rfAQe1kK8M/v-deo.html
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
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.
Glad you got it Anthony!!!🤩
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.
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?
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!
Glad you got it Lisa 🐶
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.
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?
Not with the free options. YOu will need a 3rd party tool to do horizontal.
@@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.
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
1 - You could use Flow to write to rows in an Excel.
2 - Use the Launch function to open the PDF.
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.
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
Create file is the step. I just renamed mine.
@@ShanesCows Thanks you Shane !!
Hi Shane. Just wanna know the syntax without the dropdown choices but directly what shawn on the screen.
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
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?
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.
@@ShanesCows Thanks for the quick response! Not the one i was hoping for, but good to know it's not just my headache!
Hi shane young- i added print icon in 4 screens, how can combine 4 ( save as PDF files in to 1 )?
Hi Shane!
Thank you sooooo much for this! It has been an amazing guide in helping get my employer's invoicing system automated. Everything has worked up until the HTML textbox. My HTML when tested through the w3schools website only produces one page, and when I paste the static HTML text it also only produces one page in PowerApps. When I start using the "Concat(Gallery1.AllItems..." text, it appears to be creating a new html page for each item as well as adding a row to the table. Any thoughts on how to correct?
I would guess you are missing a closing quote or your Concat has too much in it? Should just be the pieces to make a row.
@@ShanesCows Thank you for the feedback, Shane! I'll dive deeper into it. Do you happen to know the limit or threshold for HTML text in the Concat? It is a pretty long one.
Hi Shane. How do you format number with decimal points in concat function under HTMLTEXT? Appreciate for your advice. Thank you.
Wrap the text in the Text function. "This is a number with decimals " & Text(varialbewithnumber, "###.00") & ". I hope it helps. "
@@ShanesCows Thank you very much..it worked!!
Hi Shane, thank you for all of your great videos, they have saved me many hours! I am working on a project where we need both text and photos converted to PDF on the same page. I am having a hard time with getting the photos to load in dynamically. Have you had any luck with this? I am stuck with the format, it is currently in a blob format since the data we use is in SQL database. Any hints would be greatly appreciated. Thanks again for the great videos!
Hi just use JSON(control.image, JSON.IncludingBinary in your html using the IMG html function
Hi Shane, your video tutorials are very helpful. It help me a lot. May i request if you can add a "Launch workflow to open the pdf file" Thanks
I am pretty sure in this video ua-cam.com/video/juSuX2eOh5Y/v-deo.html I show returning a link to PowerApps from Flow.
Hai Shane, Thanks for this sharing. Its there example way that can also generate image/pictures in PDF?
Yes you can! ua-cam.com/video/bIne3DD3HAg/v-deo.html You have to get the base64 of the image.
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
Usually it is because you are missing a clossing tag. CHeck your tags.
@@ShanesCows It is correct, I had the same problem and it already works, thanks
Hi Shane, Thank you for this amazing video. You have saved me !!
Happy to help!
Shane, absotively wonderful vid. Probably you've covered this before, if so, sorry to repeat the query: How can I send an existing PDF in SharePoint documents via email using Office365.SendMail? I've started pulling my hair out (no more nails left). Can this be done NOT using Flow?
Hi Shane, need help! I don't see HTML File action in OneDrive For Business. What else can be used? Kindly advise. Tenkyu!
If I remember right that is just the Create File action that I renamed.
@@ShanesCows I see! GOT IT! Tenkyu for the fast assistance! Stay saye! 😊
Hi Shane! Lot's of thanks from Spain! As everybody here, I'm a fan of your videos: so useful and easy to follow. But in this specific case, I'm facing one issue with the step "convert file using file". The html file seems to be created in OneDrive without any problem (indeed I opened it in a browser and it shows me the table I created in Html in Powerapps), but when I run the flow it fails in the following step with the message "Conversion of this file to PDF is not supported."
For this step, I used "Convert file using path" and specified "Path" (with OneDrive icon) in the field "File Path" and then I chose "pdf" as Target type. What am I doing wrong? Thank you again for all the good work! Hasta luego! :-)
Not sure. At a high level it seems like you are doing it right. Maybe try again from scratch? Not sure.
This is an excellent video, and explains the process clearly. I have used this to enhance a fairly complex app which I am building for a Uk Charity. However, I am struggling getting the HTML to output the dates in UK format (DD/MM/YYYY) as opposed to the US (MM/DD/YY). The dates are in UK format within the App, so I am not sure how this has come about.
That is odd. I have an app for a UK company and my dates show in their format. What are you using to format the dates? Text(Today(), "dd/mm/yyyy") should work.
@@ShanesCows broadly that format except I can't use Today () as I am doing an app which is for planning ( past and future meetings etc). I will double check. Organisation is using O365; Browser is chrome or IE, platform W10. All my dates for out ok in forms etc- I am just curious if I am missing a tag to get the HTML to render a different date format.
The formula I gave you should work. Just replace Today() with your actual date.
@@ShanesCows I will try -thanks. Keep up the good work!
Shane, this is driving me nuts! Part of my app records the dates of Meetings (AGMs= Annual General Meetings"; field is called "AGMDate". The data is held in a Sharepoint list, and the underlying field is in Date/Time format. When I enter the formula: Text(AGMDate,"DD/MMM/YYYY"), as you suggested, PowerApps changes the formula to Text(AGMDate,"[$-en-US]DD/MMM/YYYY"). I have tried to force it into $-en-UK, but this doesn't work!
When checking the underlying data, it is correctly in the DD/MM/YYYY format
Any thoughts?