...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!!
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!
@@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 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 @@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.
@@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
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 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
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, 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!
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?
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! 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.
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. ruclips.net/video/kLGglidmPxg/видео.html choices wouldn’t be inside the filter. You would be filter(datasource, choicecolumnname.value = “red”)
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 !
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.
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?
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
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, 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, 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?
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, 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, 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.
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?
@@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!!
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, 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 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 ruclips.net/video/AnERfGIE8gw/видео.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.
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!
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?
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, 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, 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!
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?
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?
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.
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.
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)
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?
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, 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, 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.
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 ruclips.net/video/bIne3DD3HAg/видео.html This might help with your OneDrive question. ruclips.net/video/2rfAQe1kK8M/видео.html
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
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.
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 :(
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!
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.
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?
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! :-)
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 :-)
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
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 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 - Great Videos ! I followed your first PDF vid and now this one. I'm 98% there , but cant seem to get the logo to work, using the process on this Vid. Like I did in the first. I've added the "get file Content" and variable but still logo doesn't appear , also read the other related comments. any help - thanks!
I'm in the same boat. I can't find a way to "inject" the variable data into the html. If I manually write in the variables from the powerapps side it thinks it is not valid html and refuses to pass the data along to flow. I get "The method 'Run' has an invalid value for parameter 'CreateHTMLFile_FileContent'". Handling the html inside of flow is the method from the last video on this subject and is difficult to get dynamic data pulled into. It feels like we've only got partial functionality using either method. =/
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, 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)
I can't seem to find the "HTML File" Flow Step in my list of Flows. I was able to find the other two, but not that one - Is part of the standard Flows?
@@allanservillon7440 Follow Shane's instructions, but instead of using OneDrive HTML File use OneDrive Create File, folder path, file name, and content steps are the same
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.
...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
Fast forward 2020.someone giggles knowing even the great shane young gets a debugging moment during RUclips 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!
YOU ARE THE KING SHANE, AND POWERAPPS IS THE SKY
😎
it's 2020 and shane young's video is still the "go-to" video for people with powerapp issue
Thanks 😻
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, Thank you for this amazing video. You have saved me !!
Happy to help!
Great tutorial! Thank you Shane.
My pleasure!
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?
Amazing Video... thank you
You are welcome!
As usual amazing Shane!
Thanks 😊
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! Thank you very much.
You are welcome!
Great video and delivery! Thank you!
Thanks Don! 😍
You are the best! Thank you so much for making all these videos!
Happy to help
Thanks Shane! its much awaited one for me!, worked superb in different apps, thanks again!
Cool
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
Thank you so much you are a life saver ❤
Glad it helped.
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.
Your videos and solutions are superb. Thank you kindly.
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
Man, that's gonna save me a whole lot of time. Thanks Shane!
You are welcome.
Fantastic video Shane
Thank you 😎
Learning low code to avoid this kind of coding. But we have to come back sometimes. Hope PowerApps can give us a easy to use HTML editor.
Yeah sometimes we have to do a bit more code than we want. 😎
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
Your videos are awesome... Kudos
Thanks
Great Video. One question, it is possible to add footer with page number and total page number? Without premium or paid connectors
Thanks a lot for the video. How can I show this generated pdf in power app pdf control?
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 ruclips.net/video/juSuX2eOh5Y/видео.html I show returning a link to PowerApps from Flow.
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
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.
and thank you so much ! you are great !
Happy to help!
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.
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.
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 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
I love your content. Please make a video on using the Pi charts etc if possible.
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.
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. ruclips.net/video/kLGglidmPxg/видео.html choices wouldn’t be inside the filter. You would be filter(datasource, choicecolumnname.value = “red”)
I got the same issue!!
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,
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 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.
ruclips.net/video/bIne3DD3HAg/видео.html
Excellent video !!
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 ruclips.net/video/RFZfvTuDmP0/видео.html and there you will learn about the base64 you need.
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
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. ruclips.net/video/bIne3DD3HAg/видео.html
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. 😀 ruclips.net/video/8eoaSsXnh6Q/видео.html
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. 😎
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: ruclips.net/video/YkSNg7B_rps/видео.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,
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, 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.
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. 😀
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?
as you can export the same table but with the image of the signature made by the pen input.
Look at my json video. I cover this for you. 😀
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!!
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 ruclips.net/video/pjs0ZsnJZXo/видео.html
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? ruclips.net/video/2rfAQe1kK8M/видео.html but yes is the answer
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 ruclips.net/video/AnERfGIE8gw/видео.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.
Thanks ! Thanks ! and Thanks again !
:) Have a great weekend.
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
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.
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, 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 ruclips.net/video/ovLIwnj6QjU/видео.html
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, can we show tooltip in PDF generated through PowerApps?
I don’t believe so. You might try looking into 3rd party tools
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?
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!
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
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.
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.
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. ruclips.net/video/bIne3DD3HAg/видео.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 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. 😕
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, 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, 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
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 ruclips.net/video/bIne3DD3HAg/видео.html This might help with your OneDrive question. ruclips.net/video/2rfAQe1kK8M/видео.html
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.
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
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 :(
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!!!!
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 ruclips.net/video/AnERfGIE8gw/видео.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!
You are the man!
Thanks 😎
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.
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! 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.
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. 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!!
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
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, you are using sharepoint data, but is-it possible to use sql database?
Yes, works 100% the same with SQL.
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 - Great Videos ! I followed your first PDF vid and now this one. I'm 98% there , but cant seem to get the logo to work, using the process on this Vid. Like I did in the first. I've added the "get file Content" and variable but still logo doesn't appear , also read the other related comments. any help - thanks!
I'm in the same boat. I can't find a way to "inject" the variable data into the html. If I manually write in the variables from the powerapps side it thinks it is not valid html and refuses to pass the data along to flow. I get "The method 'Run' has an invalid value for parameter 'CreateHTMLFile_FileContent'". Handling the html inside of flow is the method from the last video on this subject and is difficult to get dynamic data pulled into. It feels like we've only got partial functionality using either method. =/
convert your logo and Use in Flow "Respond to a PowerApp" and insert that VAR in your html code ' " &VAR& " '
@@brandonbarnes7169 convert your logo and Use in Flow "Respond to a PowerApp" and insert that VAR in your html code ' " &VAR& " '
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, 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.
I can't seem to find the "HTML File" Flow Step in my list of Flows. I was able to find the other two, but not that one - Is part of the standard Flows?
Dave, you can just use "Create File" and select the HTML text as your content, not need to use the HTML File flow part anymore.
Thanks for the assist
@@seangucken9082 Hi Sean, newbie here. If you don't mind, do you have any tutorial or steps that can share? Thanks in advance!
@@ShanesCows Thanks for all your videos! I really appreciate it and it helps a lot! :)
@@allanservillon7440 Follow Shane's instructions, but instead of using OneDrive HTML File use OneDrive Create File, folder path, file name, and content steps are the same
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.