...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!!
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 !!!
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, 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
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 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! 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 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.
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, 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. 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
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, 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, 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?
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, 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, 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! 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!
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!
Hi Shane, GReat work youre delivering here (as usual ... or should I say always) with a very good explanation and making it easy to implement this in my own PowerApps. Creating the PDF works great, addes some peninput also (covered in one of your other video's). I do have one issue: I need the PDF in landscape but can't find how to configure this, if this is even possible. Could you look into this? That would be great. Best regards, Bert
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?
@@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
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.
Shane, thank you for the time you take to put out such great informative videos! With regards to this video, is it possible to take an image from pen input and make it part of the PDF file? I am working on a project and the PDF portion seems amazing, I would like to take it one step further. Perhaps you can take your "consent form" and turn it into a PDF complete with the signature?!?! Thanks again for all that you do.
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?
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
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 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 th-cam.com/video/AnERfGIE8gw/w-d-xo.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.
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. :(
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 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!!
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, 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.
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. th-cam.com/video/kLGglidmPxg/w-d-xo.html choices wouldn’t be inside the filter. You would be filter(datasource, choicecolumnname.value = “red”)
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! 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.
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?
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, 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
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
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.
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?
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!
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 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?
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.
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?
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!
Love your videos as always! I do have an issue though, combining with your video of adding image breaks the variables in the tables. Pasting Base64 directly into the HTML IMG tag doesn't seem to make PowerApps happy. Stuck, so I've left it as HTML for now....Just not smart enough to know the way forward :(
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, 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 th-cam.com/video/bIne3DD3HAg/w-d-xo.html This might help with your OneDrive question. th-cam.com/video/2rfAQe1kK8M/w-d-xo.html
Thanks for this and all your other videos. I've learned more than I would have ever been able to figure out on my own. In my version of this, my form is displayed in edit mode and it filters its gallery items based on a Master ID field. So when I generate the html/pdf, I want it to show the items displayed, which are a subset of all items. Everything works fine except the gallery items aren't pulled into the pdf. I've double checked the html for the gallery and can't find any errors. What am I missing?
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! :-)
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.
Great as usual! This will minimize our proof-reading when making reports. :-) If you want to add to your list of video content... What if you were on the receiving end of this pdf-flow? I get like 500 mails per year with pdf-attachment. Instead of printing and passing them around, i was thinking of storing them in SharePoint with a approval-flow-thing. Storing the attachment in SharePoint was quite straight forward but the email header and body has some useful auto-generated information i could use to filter the files with. Is there anyway i could get Flow to extract text from within the email body to put in the list together with the file? Like "copy first 15 characters after the string 'Type of test:' " Or like a anti-concatenate-function. :-)
@@ShanesCows Found it, used it and it worked! Btw, changing the language on the Microsoft products to English instead of Swedish makes tutorials soooo much easier to follow. :-)
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.
Hi Shane - Works perfectly. Thanks for that. Now I am trying to do the same with nested galleries. Is this also possible? I don't get it working. Gallery1 with date and Gallery2 within Gallery1 with all items from this date.
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!
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! your videos are very useful !. I need a hand here... I've created the same table as you show(copy/paste code) but something wrong with my PDF converter. The PDF just show the first row of my data. I've checked for HTML and it looks good, it has all rows of data,
@@ShanesCows " table, th, td { border: 1px solid black; border-collapse: collapse; } th, td { padding: 5px; } Código Mantenimiento : " &maintenanceSelected.Maintenance_Code&" Planta :" &lstmachineSelected.Plant_ID_x003a_Plant_Name.Value&" Creado por : "&varLoggedUser&" Orden de trabajo : "&JobOrderReview&" Numero de Chequeo : "&strreviewIdentify&" Fecha y hora de creación : "&Now()&" A continuacion se presenta los hallazgos encontrados en la revision, el orden en como aparecen los items es el orden de como se ejecutaron Proceso SubProceso Estado Comentario Hora Chequeo " & Concat(collectDataPDF;""& Procedimiento.Value&""& SubProcedimiento&""&Review_Status&""&Review_Comment&""& Review_Create&"") & " "
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)
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 :-)
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, 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.
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!
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?
@@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.
Great video! Thanks! I have also seen the first video. i saw that some people has the same issue if have to. Do you have an idea how to get the img in? is it true that i have to use a second flow flow to convert the img and then pass it as var to power apps? But I don't get the var in the html. Thank You.
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.
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, 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? :)
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!
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.
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.
![[New in PowerApps] The new PDF() function is a gamechanger](http://i.ytimg.com/vi/qylQgT0dS0Y/mqdefault.jpg)
![[UNCUT]“ฅนตื่นธรรม”ปะทะ“หมอปลา-ปู่มหามุนี-อั๋นโอกิ”สะเทือนกระทรวงเวทมนตร์ Iคนดังนั่งเคลียร์I10 ตค.67](http://i.ytimg.com/vi/peMD_SAkwNc/mqdefault.jpg)
...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. 😀
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. 😎
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
Thank you! I especially like that you also are honest and show your mistakes!
You are so welcome!
Fast forward 2020.someone giggles knowing even the great shane young gets a debugging moment during TH-cam video.. thank you bro
Glad to keep you entertained. I know that is all cats want from us humans. 😹
it's 2020 and shane young's video is still the "go-to" video for people with powerapp issue
Thanks 😻
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
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
Thanks a lot for the video. How can I show this generated pdf in power app pdf control?
Great Video. One question, it is possible to add footer with page number and total page number? Without premium or paid connectors
YOU ARE THE KING SHANE, AND POWERAPPS IS THE SKY
😎
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 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! 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 th-cam.com/video/RFZfvTuDmP0/w-d-xo.html and there you will learn about the base64 you need.
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 :(
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,
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. 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
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, 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 th-cam.com/video/ovLIwnj6QjU/w-d-xo.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.
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 !
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
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.
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
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
As usual amazing Shane!
Thanks 😊
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? th-cam.com/video/2rfAQe1kK8M/w-d-xo.html but yes is the answer
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, 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
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: th-cam.com/video/YkSNg7B_rps/w-d-xo.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,
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
Hi Shane, GReat work youre delivering here (as usual ... or should I say always) with a very good explanation and making it easy to implement this in my own PowerApps. Creating the PDF works great, addes some peninput also (covered in one of your other video's).
I do have one issue: I need the PDF in landscape but can't find how to configure this, if this is even possible. Could you look into this? That would be great.
Best regards,
Bert
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, 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
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. :)
Shane, thank you for the time you take to put out such great informative videos! With regards to this video, is it possible to take an image from pen input and make it part of the PDF file?
I am working on a project and the PDF portion seems amazing, I would like to take it one step further. Perhaps you can take your "consent form" and turn it into a PDF complete with the signature?!?!
Thanks again for all that you do.
This would finish off my project nicely too!
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.
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 :)
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 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 th-cam.com/video/AnERfGIE8gw/w-d-xo.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.
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.
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.
Great video!!! Thanks. Is it possible to make the filenaming in power automate dynamic with data from the HTML?
Sure. The filename just has to be a text string you pass. YOu can make it anything you want.
@@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!!
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, 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
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. th-cam.com/video/kLGglidmPxg/w-d-xo.html choices wouldn’t be inside the filter. You would be filter(datasource, choicecolumnname.value = “red”)
I got the same issue!!
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 th-cam.com/video/AnERfGIE8gw/w-d-xo.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!
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.
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.
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, 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. th-cam.com/video/bIne3DD3HAg/w-d-xo.html
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.
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.
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?
Do they have OneDrive accounts is my first guess.
@@ShanesCows, I knew it had to be something as simple as that. Thanks!
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.
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. th-cam.com/video/2rfAQe1kK8M/w-d-xo.html
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. 😕
Another awesome video, thanks so much Shane 👍
Glad you enjoyed it
@@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?
Hi Shane, Thank you for this amazing video. You have saved me !!
Happy to 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.
th-cam.com/video/bIne3DD3HAg/w-d-xo.html
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?
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 🐶
Great tutorial! Thank you Shane.
My pleasure!
Love your videos as always! I do have an issue though, combining with your video of adding image breaks the variables in the tables. Pasting Base64 directly into the HTML IMG tag doesn't seem to make PowerApps happy. Stuck, so I've left it as HTML for now....Just not smart enough to know the way forward :(
Base64 will work. You just have to get all of your ducks in a row. I think you cut out the header info.
@@ShanesCows Hi Shane, so right you were! Thank you!!!!
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. 😀 th-cam.com/video/8eoaSsXnh6Q/w-d-xo.html
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 th-cam.com/video/bIne3DD3HAg/w-d-xo.html This might help with your OneDrive question. th-cam.com/video/2rfAQe1kK8M/w-d-xo.html
Thanks for this and all your other videos. I've learned more than I would have ever been able to figure out on my own. In my version of this, my form is displayed in edit mode and it filters its gallery items based on a Master ID field. So when I generate the html/pdf, I want it to show the items displayed, which are a subset of all items. Everything works fine except the gallery items aren't pulled into the pdf. I've double checked the html for the gallery and can't find any errors. What am I missing?
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.
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.
Great as usual! This will minimize our proof-reading when making reports. :-)
If you want to add to your list of video content...
What if you were on the receiving end of this pdf-flow? I get like 500 mails per year with pdf-attachment. Instead of printing and passing them around, i was thinking of storing them in SharePoint with a approval-flow-thing. Storing the attachment in SharePoint was quite straight forward but the email header and body has some useful auto-generated information i could use to filter the files with.
Is there anyway i could get Flow to extract text from within the email body to put in the list together with the file?
Like "copy first 15 characters after the string 'Type of test:' "
Or like a anti-concatenate-function. :-)
Yes. I have a personal Flow that does that. You have to use the string function expressions. No video on it yet but one of these days.
@@ShanesCows Found it, used it and it worked!
Btw, changing the language on the Microsoft products to English instead of Swedish makes tutorials soooo much easier to follow. :-)
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.
Hi Shane - Works perfectly. Thanks for that. Now I am trying to do the same with nested galleries. Is this also possible? I don't get it working. Gallery1 with date and Gallery2 within Gallery1 with all items from this date.
You should be able to just feed in Gallery2.Allitems and it should work the same.
@@ShanesCows Thanks for your answer. I'll give a try.
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 th-cam.com/video/juSuX2eOh5Y/w-d-xo.html I show returning a link to PowerApps from Flow.
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. 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! your videos are very useful !. I need a hand here... I've created the same table as you show(copy/paste code) but something wrong with my PDF converter. The PDF just show the first row of my data. I've checked for HTML and it looks good, it has all rows of data,
Can you post your html here? Most people it is a missing or extra
@@ShanesCows "
table, th, td {
border: 1px solid black;
border-collapse: collapse;
}
th, td {
padding: 5px;
}
Código Mantenimiento : " &maintenanceSelected.Maintenance_Code&"
Planta :" &lstmachineSelected.Plant_ID_x003a_Plant_Name.Value&"
Creado por : "&varLoggedUser&"
Orden de trabajo : "&JobOrderReview&"
Numero de Chequeo : "&strreviewIdentify&"
Fecha y hora de creación : "&Now()&"
A continuacion se presenta los hallazgos encontrados en la revision, el orden en como aparecen los items es el orden de como se ejecutaron
Proceso
SubProceso
Estado
Comentario
Hora Chequeo
"
&
Concat(collectDataPDF;""& Procedimiento.Value&""& SubProcedimiento&""&Review_Status&""&Review_Comment&""& Review_Create&"")
&
"
"
@@ShanesCows Here are files generated 1drv.ms/f/s!AtUWbFxZ0Lx3iY50wKy8YnIWpn0nbA
In the Concat you are missing after the last
@@ShanesCows That is all, It's working now!. You are the best!!! Thanks for all!
Hi Shane, your awesome. Can I dynamically name my pdf file in that scenario?
Yes. For the filename “ask in Power Apps” then pass it from Power Apps
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. th-cam.com/video/bIne3DD3HAg/w-d-xo.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)
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.
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
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.
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!
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?
@@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.
Thanks Shane! its much awaited one for me!, worked superb in different apps, thanks again!
Cool
Hey Shane! Would be super helpful if you could put the FileContent expression code for flow in the description :)
Ross I am on vacation but if you will email me next Monday this is a great idea. 😀
Great video! Thanks!
I have also seen the first video.
i saw that some people has the same issue if have to.
Do you have an idea how to get the img in?
is it true that i have to use a second flow flow to convert the img and then pass it as var to power apps?
But I don't get the var in the html.
Thank You.
YES that works, convert your logo and Use in Flow "Respond to a PowerApp" and insert that VAR in your html code ' " &VAR& " '
Glad you found a solution. My latest video on pen input might inspire some other ideas. Different topic but similar concept
Hi Shane, can we chnage the orientation of PDF to landscape?
Not with the free tools. I think the 3rd party paid stuff can.
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!!!🤩
Hai Shane, Thanks for this sharing. Its there example way that can also generate image/pictures in PDF?
Yes you can! th-cam.com/video/bIne3DD3HAg/w-d-xo.html You have to get the base64 of the image.
Greate video! Thanks! Are we able to convert the HTML to PDF in landscape layout? Thanks.
Unfortunately not. I wish. Maybe the 3rd party providers have the ability but with the free connector.
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 th-cam.com/video/pjs0ZsnJZXo/w-d-xo.html
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
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!
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.
Hi Shane, you are using sharepoint data, but is-it possible to use sql database?
Yes, works 100% the same with SQL.
Amazing Video... thank you
You are welcome!
You are the best! Thank you so much for making all these videos!
Happy to help
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, can we show tooltip in PDF generated through PowerApps?
I don’t believe so. You might try looking into 3rd party tools
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.