Stop apologising about the video length, I am always happy to see the enthusiasm and passion of your learnings. The more, the merrier! Awesome video again, Shane, great job!
I know im asking the wrong place but does anyone know of a tool to log back into an Instagram account?? I was stupid forgot the login password. I love any assistance you can give me!
@Davian Brayan thanks for your reply. I got to the site thru google and Im trying it out now. Takes a while so I will get back to you later when my account password hopefully is recovered.
I have watched countless hours of CS and coding tutorials during my education and career, yours are by far my favorite. These PowerApps tutorials are an absolute lifesaver. Thank you!
Shane! Just by watching your videos I was able to program a power app to track absence times of our students. All teachers can now work together in that app and it saves them a whole bunch of time (AND PAPER!!). Thank you so much, rock!!
Good video, it really helped for my first application. A few things I learned along the way: - I used the "Compose" step to make the HTML more readable instead of directly entering it in the "Create File" step. - If you can store the data you want to print in a Sharepoint list it makes it a lot easier to include dynamic variables in your HTML
Another great informative video. Top tip for avoiding having to do all that hard work with the concat expression in the single line editor... if you initialise another variable of type string and put all your HTML text in that, it is way easier to maintain and you don't need to concat any of it. Then you just drop the variable into the FileContent of your OneDrive Create File action :D
Shane, thank you so much for this and all the great videos that have made Power Apps truly accessible to me in my job. I was able to use a "Get Row by ID" function in the flow, add its output to my HTML, and get dynamic values from Dataverse (even LookUps) to populate in my PDF. Now I can export a PDF with all the Dataverse record's fields. So cool, and useful. Cheers!
Hi Shane, just wanted to thank you for posting this video. I used your method for inserting a picture, except I tokenized the hmtl and then used replace() to add all of the pictures and elements. You're the best!!!
my superstars to follow used to be Roger Federer, Guns N Roses, Tool, Megadeth, now the rockstars for me are Shane Young and Reza Dorani. Thanks, that´s just what I needed
Great video. I know I was struggling but I've learn a few things about a few limitation to take note of when desiging your html files for pdf conversion. 1. No flexbox or grid support. 2. Overflow doesn't work. 3. Body width has a max I've found 600px to be the sweet spot.
Awesome video Shane. Really does open up a lot of possibilities. One thing to add though, you can convert a word document to HTML which comes in handy when designing your document and then only needing to tweak a few things rather than having to write it all from scratch.
Hi Shane, Fantastic Video as usual. The length was necessary to convey each step with enough detail. I especially appreciated the Button to test the Flow. Looking forward to the next Video! Thanks.
Anyone looking for a low tech work around can try this 1)On your powerapps screen select the gear icon and choose fit to screen 2) right click and choose print 3) choose save as PDF, then edit the layout 4) click the more Settings and choose the paper size and scale that will best fit your screen 5) uncheck headers and footers ( to disable all the annoying text and dates that will appear on your page from web printing) 6)check background graphics ( to show all your logos and images) Then just save the file and you now have a perfect PDF replica of your screen. Hopefully this saves someone the endless hours of frustration that I had to endure trying to print to PDF
Hey Shane. Thanks for the video. I've been using grids for layout in html. When running the code, the html file looks perfect but when converting to pdf, the file loses all the grids I've defined as well as any content within it. I've had similar issues with styling in general. It seems as though the conversion won't let me put in page numbers or align my image the way I want. Any idea why this might be lost in the conversion or know of anyone that might have the answer?
Hey Shane, This was the missing link in a solution I am building for my schools (I help look after a whole district). You sir are awesome!!! You should set up a Patreon Page. I for one would support you.
I love your enthusiasm! So in the end, you were able to insert only one input (the 9 cups of food) how would we make it to submit dozens of inputs in a table or form that I am making? Almost like an application to enter a program? Thank you appreciate any feedback!
Yo the trick to get the expression value got me out my chair like no waaaaaaaaaaay! nice one Shane! I was always a hover and type kind of guy! Not anymore!
Awesome video Shane, thanks. FYI I needed to look at the HTML a different way as I need data from sharepoint. All is good until I do the PDF. I use Compose -Select and Compose-Create HTML to setup the file. When I run I get no errors, the HTML output opens up to show I have the table OK, but the PDF output simply shows all the code as text not as a table as desired. I found I had to add concat('',outputs('Compose'),'') in order to achieve the proper output. All I need now is to set the PDF to Landscape as my table is too large (any ideas)
Thanks Shane. This may all become moot as the Flow developers have started working on a print solution for powerapps. In relation my problem I had above it was still your video that put me in the right direction as your sample HTML code had the beginning and end that was required to add to the flow HTML code. It is strange as that code is not needed when doing an email in flow. I guess that is what the outlook setting IsHTML does.
Thank you for the video. Everything works like a charm when I am logged in as the user that created the flow. The base files (logo, HTML, pdf) are all saved in the Share with Everyone OneDrive for Business folder. When I run the app/flow using a different account the flow fails on the getting the image file for the logo - says the resource cannot be found. That would be a permission thing right? But the file is in the Shared with Everyone folder and appears to open to all. Heck, I think they can even edit it. So, what am I missing?
The way I wrote this flow it is looking in the user who is triggering the Flows OneDrive for the file. :( Consider just hard coding the base64 in the flow or app like I talk about here. ua-cam.com/video/bIne3DD3HAg/v-deo.html One day I need to revisit these PDF videos. :)
2 silly questions: 1 - the OneDrive I am using is assigned to me, and only me. In order for this to work, do I have to give public access to one of the folders within my OneDrive to allow other users to run the flow? 2 - is it possible to execute a 'page break' command on the pdf?
nice one, powerapps field is text value expected in flowname.run(). Please how to add other type of field?? (date field, drop list value...) . thanks a lot!
For example. To pass something from a Dropdown you would use: dropdown1.selected.value and that would do it. If Flow is expecting a date then it will except a date.
I have created an IT request application, and it's now working with files being saved on OneDrive. However, I need to send the requested PDF to the user. How can I do that?
In your flow you have the file from the Convert action. YOu can put that output in the Attachment field of an Outlook email. This week's video on images in flow will help ua-cam.com/video/1N7PBDjTY1U/v-deo.html
Thank you for your video. Your videos helped me alot to generate pdf from sharepoint list data. But image part is not working for me. I have stored my image file in one drive and used get content action to get image content , stored those to string variable and then added that to my string variable with html text as variable('Logo') .. steps you explained in this video, but it not showing me image on html as well as on pdf file. can you please guide me what can be wrong?
Thanks you! Nice video for starters!! In the example we are sending only one field value from PowerApps to flow. What if we want to send multiple field values from PowerApps to flow, how do we refer to those different values in the HTML.
This is incredible! I just created a new database and this will be something I add in the next version. Will definitely need to spend some time with this one lol!
How do I get landscape format on PDF file? Is there any programming in Powerapps? Has an html in powerapps with many columns. It creates PDF standing, and then not all columns appear.
This video was super helpful! I used to to in an approval flow, so the approval could quickly view a collection (based on a shopping cart). I would like to take the approval flow a step further and, if approved, create a SharePoint list entry with columns for Item Name, Quantity, Campus, Cost. I have all of this info in a collection, and in an HTML control that I used to create the PDF. Is there a way to use that information to generate a SharePoint list row?
The HTML file and the conversion process has to happen on OneDrive. But the Create File step can create the file into SharePoint. Sorry for any confusion.
I have scanned documents in PDF format, is it possible to get them signed using automate? What about converting PDF to some other format where that might be possible, such as Word (even if it is an image without OCR)?
For some odd reason my pdf is blank but my html file looks correct. For the OneDrive convert file action. When I use the ID for the file in the Convert to pdf action. It create an empty file. When I use the path it says the id of the file is not valid. *Edit: I figured out my issue. You can't use flexbox or css grid. Have to use tables :(
Hi Shane, I'm having problems with the "get file content" bit for the datauri string to convert my image (from SP) to something that can be inputted into my concat function. I have a picture (jpg) in SP library so I use "Get File Contents" action as shown pointing it to my picture. I then initialise "photo" variable and set to string, use expression "dataUri('')" then select the "get file content" from the dynamic list like you suggest. It doesn't paste it in as "body('Get file content'), instead it puts dataUri('outputs('Get_file_content')?['body']'). When I hit "OK", it then says expression isn't valid. Any ideas? I've also tried it with a OneDrive image file as well thinking it might have just been pesky SP, but it misbehaves too. Any ideas?
hi Shane, that's a great knowledge. What if I want to only add all choosed buttons or entered text WHEN send button is clicked? For example I have 4 buttons where person can choose and option and two text fields where he can enter some details.
Hi Shane Help please, I can't get around this. I created the flow in the power automate and when I do the test, everything runs fine, save the html in the onedrive folder and create the pdf file in the sharepoint folder as it is supposed to. When I put the instruction on the button in OnSelect "htmlToPDF.Run (htmltext1.HtmlText), it stays underlined in red with the error message" Invalid number of arguments; 1 received, 0 expected ". For now I am using the simple html "Table with border" without changing anything.
Shane & Others, when creating the HTML to generate the pdf, I am struggling with the format for a multi-select box. So I have a box that the user can select 1-7 options. When I write the HTML as follows, I only get 1 value back. How do I write it to get all of them? "&ArtifactV.Selected.Value&" Thanks
I might have just missed something, but when I am creating the first file from HTML, it isn't coming through as a PNG file, and the converter is saying it wont convert. It is having me open it in notepad
Yeah, that shouldn't happen. I would run through the steps again or this video ua-cam.com/video/pFlwYy8ijiA/v-deo.html is a newer version of the same stuff. Might be helpful to hear me say it again, differently.
Great video.. thanks for the kick in the right direction.. The conversion tool is still in preview and has more output.. But unfortunately also an error.. When I use the path variable it fails so I have to point directly to the file.. Do you know where I can report that error?
@@ShanesCows Thank you again. I shall share my "corporate "celebrity"" with you somehow! I simply redesigned the entire layout. However, one more question and a quick comment: - In this video, we can eventually add information about the fact that we can have "ask in PowerApps" in PowerAutomate, and get a full HTML document made in PowerApps. Much easier than adding too many fields/requests from various queries. - But then, the downsize of this = I lost the picture / the variable. So my HTML in PowerApps = I have the picture. I send email, the picture is still here. I create the pdf, and pschiit, is gone. Any idea? I cannot use your workflow, I have like 40+ information to add. Thank you again, find me a way to share my celebrity :) (I already listed you in various PowerPoints about "where I learned")
Hi Shane, your videos have enabled me to produce a few apps and flows and my work colleagues think i'm amazing! The problem I have is with the image process in this tutorial in that I do not have the option to add dynamic content and then the option to add a function (fx). Instead I get blue (OD) and Purple (flow) icons with text. These are similar because if I hover the OD icon/text I can see it refers to "body('Get_file_content')". I suspect i'm using a different Sharepoint version, but would I still need to input dataUri( before the blue OD icon/text? I've tried with and without but cannot get the image to show. Thanks in advance!
Thanks Shane, nice! I created a file that I saved to Sharepoint and I couldn't figure out what kind of ID the convert to PDF wanted; the path and the ID didn't work for either version. I ended up using the Adobe converter instead but I'd love to know if I just got something wrong using the Onedrive version.
Another great useful topic...there are many times I need to create a dynamic filename (like with the date) and I am sure I could use Variable to create a string formatted the way I need and then Concat() to the rest of the filename.
How can I detect the error within that concat(' '). In your case, it seems easy that powerapps does have issue with apostroph 's. I don't have any chewey's and the HTML code is complex and Flow says only that the expression is invalid. Ok. But where and how should I best find where the error is?
awesome, it works, any chance i could get certain parts of the html to pdf to print out instead of the entire portion based on drop down selections inside the app? or is that too much?
Basically the conversion process just wants text, it doesn't care how you get there. So if you can create logic to only send part of the HTML you want then you should be fine. There is a newer version of this video that may help ua-cam.com/video/pFlwYy8ijiA/v-deo.html
Hi Shane, Does a user need to have a share on the one drive, like they need for SharePoint? And have you tried to launch the PDF when created from PowerApps?
I'm having an error at the Convert file using path part. There's a warning that says 1 retries occurred. When I click View, it says "Status: BadGateway". I think the error started only yesterday. Thank you in advance!
Hey Shane. This is a great video and let me do what I have been trying to do for a while! The only thing I'm finding is that I want to put more than 1 record into a table. How do I create a table and ask it to do a 'for each' kind of statement? I can't get it working without using a premium connector, which my organisation doesn't pay for. I have tried creating the HTML text in Powerapps itself and can get a table looking how I want it to, but when I put that through flow and into a word document, it looks really fuzzy... Can't work out how to make it less fuzzy.
Really helpful vid, thanks. I've used the trick of creating string variables to pass DataURI(file content) to HTML using Concat, which I'm then using in the body of an email to show a fancy logo. The final email renders beautifully in Outlook and in my personal webmail client, but not in Gmail. Would you have any idea why that might be?
Its all working fine but although i have a little problem. Unfortunately the pdf converter ignores the height an weight settings from my image within the image tag. Is there a way to fix this?
Hi Shane, do you have any videos on how to merge PDF files into one PDF file? For example from a Powerapps form to be able to collect all the attached PDF files and call a Power Automate workflow to merge the PDF files into one file and then drop it into a SharePoint document library folder. Thanks
Hi Shane thank for the video. I've tested this in our environment and it works very well. Is it possible to print 2 related SharePoint lists in one PDF, on one I want to pull the master data and on the other one I want to pull the details. Thank you
@@ShanesCows I've created the html file and it does pull the information from both the master and details however the information is not related meaning the printed information for my master doesn't not speak to the details. e.g invoice 007 header and invoice 0010 details
you control the HTML. So it is up to you to relate them within the PDF. PowerApps provides all of the info now you need to write HTML to display records in a related manner.
@@ShanesCows I agree with that, that's what i've done in my application and it works! thanks so much Shane! now i'm working on getting this PDF emailed to people as well. I'll see how that works
Hello Shane, I'm trying to generate PDF from a SharePoint List but i have a few columns in the list which r in RICH TEXT format, any idea how I can get this into the PDF?
Good video Shane. 1 question regarding the HTML code using the TriggerBody expression: why did u use the 'CreateFile Filename' syntax in the td cell?thx
@@ShanesCows thx. No what I meant by that Q is what if you have multiple text inputs from the user, so how would write/use different expressions to handle the multiple data going into the html rows to create the pdf? Rgds
Hello Shane, You used triggerbody () ['Createfile_FileName'] for one dynamic content, how can I make multiple dynamic fields? Or what arguments do I need to pass in html for multiple dynamic fields... Please suggest...
Ok, I am new to PowerApps and have been trying to solve a problem with no results. I am trying to convert html to pdf, but with dynamic pictures. I have everything running and the flow works, but it doesn't show the pictures and is a red X where the pictures are supposed to be. The flow use one drive to export the html file to one drive as you show here, but a dynamic picture doesn't work in my case as I need dynamic. I haven't found one person yet that has addressed this issue. Obviously it has something to do with datauri, but how do you solve this?
Great video to get started, I've got two questions I hope you or someone can help. How can I create a different pdf, every time the bottom is pressed? Thanks so much agai
Hi Shane, thanks for the video. I have a slightly different scenario and am wondering how to get it to work. If a mail is send, I extract the html body and save it to onedrive. That part works. I then convert it to pdf and the images won't show up. Any idea how I can fix it? As I don't save the images separately each time an email arrives.
You are going to have to get the images in base64 format. So downloading the file and such. Not super easy, possible but not easy. Other thing you might check if the 3rd party PDF tools support URLs for images. I don't know if they do or dont.
Hi shane what happens when you have multiple textboxes. How do you integrate trigger body in that situation. My submit button does not allow me to reference multiple textboxes
Hi Shane, if I want to create the whole HTML in a Rich Text control with Poerapps and then post the contents of 'Button->Createfile'.Run(RichTextEditor1.HtmlText) into flow, is this possible, and how do I set the concat statement as Concat('triggerBody()['Createfile_FileName']') does not work.
This works great for me but when users other than me try to use it they get an error saying "connection not configured for this service" . Any pointers would be great.
hi Shane I have a editable pdf form or fillable pdf form. how can i use power apps so that when users click on the link they will be see the fillable form and when they fillup the details & submit a new pdf will be saved leaving the original pdf untouched.Can you help me with this please. Thanks
Hi Shane, First off thanks for the videos they've helped out tremendously. However, any suggestions on how to pull an image into the dynamic content flow in the above video? Appreciate the help!
Shane. Thanks for the video. I have follwed it through but for some reason the html version shows as required but when it converts to PDF it drops off the section which is a Concat table to get items from a sharepoint list. Any idea what l could be doing wrong? Thanks in advance.
Hi Shane , I have created flow that is perfectly working to convert html to pdf , html is landscape view ,but after conversion of pdf is portrait ,how do i make view of pdf file in landscape
Hi there, I'm having issues with the conversion of HTML file to PDF. I used the same flow structure still when the PDF file is created one of the column gets cropped with all the contents. I even raised a ticket, had a call with tech support even he seems to have the same issue. Any idea what I must be doing wrong?
I did and now I'm getting strange results like table gets vanished only the text under can be seen in PDF. When I removed some rows it worked so I guess the whole content is exceeding page limit. Is it possible to make some content move to next page when converted to PDF.
Hey Shane. Great video! Do you have a video (or other resource) on sending more than one value from PowerApps to Automate, to be able to then insert them into separate cells in the table (for eventual conversion to PDF)?
Hey Shane, Great video. I wanted to know if there is any option to write more fields to PDF SharePoint? Currently you have one field in PowerApp as an example and my requirement is for 26 fields. Any tip would be helpful.
@@ShanesCows awesome video as usual. I was able to follow everything. Now I have about 20 fields from powerapp which I built in HTML but the value for each field is different. Can we use the expression ', triggerBody()['Createfile_FileName'] ,'to include multiple data/fields from powerapps content in to flow? Video timeline 21:13 you showed how to update a field in HTML in Flow. I tried duplicating this to another field and HTML and PDF output just copied the first value.... or does the coding need to happen from OnSelect like VideoMakePDF.Run(TextInput1.Text)? How do we include multiple data here so we can reflect in Flow?
Hi Shane, Thanks so much for the great video. I had one question Is it possible to download a bunch of monthly bills in pdf from a legacy system in bulk, split them and send the same as attachments to the respective customer on the bill. Regards,
Stop apologising about the video length, I am always happy to see the enthusiasm and passion of your learnings. The more, the merrier!
Awesome video again, Shane, great job!
Thank yoU!
i think i'm gonna dial 911
I know im asking the wrong place but does anyone know of a tool to log back into an Instagram account??
I was stupid forgot the login password. I love any assistance you can give me!
@Tyson Leonidas instablaster =)
@Davian Brayan thanks for your reply. I got to the site thru google and Im trying it out now.
Takes a while so I will get back to you later when my account password hopefully is recovered.
I have watched countless hours of CS and coding tutorials during my education and career, yours are by far my favorite. These PowerApps tutorials are an absolute lifesaver. Thank you!
You are very kind. 🐶
Shane! Just by watching your videos I was able to program a power app to track absence times of our students. All teachers can now work together in that app and it saves them a whole bunch of time (AND PAPER!!). Thank you so much, rock!!
That is awesome! Good job to you Snork!
Just started working with Powerapps and Flow. Thanks to your videos I achieved a great progress.
Good video, it really helped for my first application.
A few things I learned along the way:
- I used the "Compose" step to make the HTML more readable instead of directly entering it in the "Create File" step.
- If you can store the data you want to print in a Sharepoint list it makes it a lot easier to include dynamic variables in your HTML
Cool
I wish I could like this video twice. I was jumping and down with you when I got my company logo and my own custom power apps data out there!
Awesome!
Another great informative video.
Top tip for avoiding having to do all that hard work with the concat expression in the single line editor... if you initialise another variable of type string and put all your HTML text in that, it is way easier to maintain and you don't need to concat any of it. Then you just drop the variable into the FileContent of your OneDrive Create File action :D
I like it. 😻
How would you accomplish that specifically?
Shanne you are awsome, you just can't imagine how much time you made us save. Please keep posting videos!
Glad to help. 😀
Shane, thank you so much for this and all the great videos that have made Power Apps truly accessible to me in my job. I was able to use a "Get Row by ID" function in the flow, add its output to my HTML, and get dynamic values from Dataverse (even LookUps) to populate in my PDF. Now I can export a PDF with all the Dataverse record's fields. So cool, and useful. Cheers!
Awesome 😎
Can you please show me how you managed filling in lookup records and data table fields in html. I am having issue with that.
Hi Shane, just wanted to thank you for posting this video. I used your method for inserting a picture, except I tokenized the hmtl and then used replace() to add all of the pictures and elements. You're the best!!!
Cool
my superstars to follow used to be Roger Federer, Guns N Roses, Tool, Megadeth, now the rockstars for me are Shane Young and Reza Dorani. Thanks, that´s just what I needed
Very kind of you. Hope you have a great weekend 🔥
"That took me...[Briefly reflects what day is it /damn I need to shower and sleep] I don't wanna talk about it." Nice work dude
Glad it helped and hope you remembered to shower. 😂
I thought my enthusiasm for learning powerapps was weird. I feel you, bro. GREAT job, as usual. Thank you for your effort!
Yup 😻
Great video. I know I was struggling but I've learn a few things about a few limitation to take note of when desiging your html files for pdf conversion.
1. No flexbox or grid support.
2. Overflow doesn't work.
3. Body width has a max I've found 600px to be the sweet spot.
Thanks for sharing!
Awesome video Shane. Really does open up a lot of possibilities. One thing to add though, you can convert a word document to HTML which comes in handy when designing your document and then only needing to tweak a few things rather than having to write it all from scratch.
Yes but that creates a lot of extra “noise” in the html that is really scary to a newbie.
Thanks Shane. Had a customer the other day that wanted this and u solved it for me so easy. Thanks
Glad to help. 😻
"You can choose any option you want, as long as it's PDF...Because that's the only option you have" :'D
😂
Hi Shane, Fantastic Video as usual. The length was necessary to convey each step with enough detail. I especially appreciated the Button to test the Flow. Looking forward to the next Video! Thanks.
Thank you Peter. 😻
Once more, great video! I also must say that ive just started using Powerapp and your videos have been great as I dont know coding... Thanks a lot!!!!
Awesome 😁
thinking you were making this video in 2018... Awsome , thank you a lot for the sharing
I feel like I should make a new version but nothing has changed so 🤷♂️
Can you skip the HTML and send your collection into a table in an Excel template, then convert that Excel file to PDF?
I don’t know how to convert excel to pdf programmatically.
OMG you're a hero !!! And this Concat function is just perfect
Thanks 😊 glad it helped.
Great tutorial, thanks! Would you know how to turn left the pdf page?
I don’t 😑
It’s like you knew that I needed this video in my life :-)
I made it just for you. 😻
Dude you are the best! You make the learning process easier and enjoyable. keep the hard work!!
Thank you. I will. 😀
THANK YOU!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!
I was just trying to figure this out myself. You just saved me a TON of time!
Glad to help. 😀
Brooo... Thank you so much for making our lives easier! This is very helpful!
Glad to help. 😀
Anyone looking for a low tech work around can try this
1)On your powerapps screen select the gear icon and choose fit to screen
2) right click and choose print
3) choose save as PDF, then edit the layout
4) click the more Settings and choose the paper size and scale that will best fit your screen
5) uncheck headers and footers ( to disable all the annoying text and dates that will appear on your page from web printing)
6)check background graphics ( to show all your logos and images)
Then just save the file and you now have a perfect PDF replica of your screen.
Hopefully this saves someone the endless hours of frustration that I had to endure trying to print to PDF
Thanks
A.M.A.Z.I.N.G !! saved me hours of endless training, forever grateful ;)
Glad to help. 😀
Hey Shane. Thanks for the video. I've been using grids for layout in html. When running the code, the html file looks perfect but when converting to pdf, the file loses all the grids I've defined as well as any content within it. I've had similar issues with styling in general. It seems as though the conversion won't let me put in page numbers or align my image the way I want. Any idea why this might be lost in the conversion or know of anyone that might have the answer?
Sorry I got nothing Matthew
I’ve just run into this same snag. Did you ever find a solution, Matthew?
Hey Shane,
This was the missing link in a solution I am building for my schools (I help look after a whole district). You sir are awesome!!! You should set up a Patreon Page. I for one would support you.
That is awesome. I have toyed with patreon but I don’t know. 😀
@@ShanesCows You defo should lol
I love your enthusiasm! So in the end, you were able to insert only one input (the 9 cups of food) how would we make it to submit dozens of inputs in a table or form that I am making? Almost like an application to enter a program? Thank you appreciate any feedback!
Thanks Alan. This video should help speak to how we can get lots and dynamic data into the mix. ua-cam.com/video/bfXV_GXc_JM/v-deo.html
Yo the trick to get the expression value got me out my chair like no waaaaaaaaaaay! nice one Shane! I was always a hover and type kind of guy! Not anymore!
Cool. Glad it works for you.
You are awesome Shane. I love your videos!
Thanks 😎
Hi Shane, I love it your video ...still my flow is not working but I could do it. Thanks for share yours knowledge. Thanks a lot.
Glad to help. 😀
Are you serious!? I was just chatting with you how I had done this with Sharepoint..." HA! Here you are with the video! Nice!
Interesting! I did this a bit different: PowerApps to Sharepoint to Word Template to PDF. Love how flexible these tools are!
Yeah I chuckled the other day. 😀
@@seadude do you have a tutorial on your method?
Awesome video Shane, thanks. FYI I needed to look at the HTML a different way as I need data from sharepoint. All is good until I do the PDF. I use Compose -Select and Compose-Create HTML to setup the file. When I run I get no errors, the HTML output opens up to show I have the table OK, but the PDF output simply shows all the code as text not as a table as desired. I found I had to add concat('',outputs('Compose'),'') in order to achieve the proper output. All I need now is to set the PDF to Landscape as my table is too large (any ideas)
Yikes. Sorry, I am not great with HTML. I have to imagine it is possible but not sure. Sorry.
Thanks Shane. This may all become moot as the Flow developers have started working on a print solution for powerapps. In relation my problem I had above it was still your video that put me in the right direction as your sample HTML code had the beginning and end that was required to add to the flow HTML code. It is strange as that code is not needed when doing an email in flow. I guess that is what the outlook setting IsHTML does.
So many nuances. 😑 Makes it interesting. 😻
Thank you for the video. Everything works like a charm when I am logged in as the user that created the flow. The base files (logo, HTML, pdf) are all saved in the Share with Everyone OneDrive for Business folder. When I run the app/flow using a different account the flow fails on the getting the image file for the logo - says the resource cannot be found. That would be a permission thing right? But the file is in the Shared with Everyone folder and appears to open to all. Heck, I think they can even edit it. So, what am I missing?
The way I wrote this flow it is looking in the user who is triggering the Flows OneDrive for the file. :( Consider just hard coding the base64 in the flow or app like I talk about here. ua-cam.com/video/bIne3DD3HAg/v-deo.html One day I need to revisit these PDF videos. :)
2 silly questions:
1 - the OneDrive I am using is assigned to me, and only me. In order for this to work, do I have to give public access to one of the folders within my OneDrive to allow other users to run the flow?
2 - is it possible to execute a 'page break' command on the pdf?
1 it will save to their OneDrive. 2 page breaks are possible but I haven’t covered it yet. Requires fun with Div tags.
Thank you Shane, this is really helpful and easy to follow.
You're very welcome!
nice one, powerapps field is text value expected in flowname.run(). Please how to add other type of field?? (date field, drop list value...) . thanks a lot!
For example. To pass something from a Dropdown you would use:
dropdown1.selected.value and that would do it.
If Flow is expecting a date then it will except a date.
Thanks mate
I have created an IT request application, and it's now working with files being saved on OneDrive. However, I need to send the requested PDF to the user. How can I do that?
In your flow you have the file from the Convert action. YOu can put that output in the Attachment field of an Outlook email.
This week's video on images in flow will help ua-cam.com/video/1N7PBDjTY1U/v-deo.html
Thank you for your video. Your videos helped me alot to generate pdf from sharepoint list data. But image part is not working for me. I have stored my image file in one drive and used get content action to get image content , stored those to string variable and then added that to my string variable with html text as variable('Logo') .. steps you explained in this video, but it not showing me image on html as well as on pdf file. can you please guide me what can be wrong?
You must have a bug in your html. Try to simplify and try again.
Thanks you! Nice video for starters!! In the example we are sending only one field value from PowerApps to flow. What if we want to send multiple field values from PowerApps to flow, how do we refer to those different values in the HTML.
Sorry I am slow. You will need to ask in Power Apps, inside your flow, multiple times.
Shane, you are a saviour! Happy new year :)
Thanks Carol and right back at you. 😻
This is incredible! I just created a new database and this will be something I add in the next version. Will definitely need to spend some time with this one lol!
Cool
How do I get landscape format on PDF file? Is there any programming in Powerapps? Has an html in powerapps with many columns. It creates PDF standing, and then not all columns appear.
Have to use a 3rd party converter to get landscape
This video was super helpful! I used to to in an approval flow, so the approval could quickly view a collection (based on a shopping cart).
I would like to take the approval flow a step further and, if approved, create a SharePoint list entry with columns for Item Name, Quantity, Campus, Cost. I have all of this info in a collection, and in an HTML control that I used to create the PDF. Is there a way to use that information to generate a SharePoint list row?
You need to send the data to flow and use the create item action. Should work fine
Good Day Shane,
How to do this in a sharepoint list? Can you give me the details or just a logic in Microsoft flow.
Thank you very much!!
Try this ua-cam.com/video/bfXV_GXc_JM/v-deo.html
You mentioned you can do it with SharePoint? I didn't a see a convert to pdf for sp document libraries.
The HTML file and the conversion process has to happen on OneDrive. But the Create File step can create the file into SharePoint. Sorry for any confusion.
@Shane Young, two years later ago you posted this video and I'm learning it now! :)
Awesome!
I have scanned documents in PDF format, is it possible to get them signed using automate? What about converting PDF to some other format where that might be possible, such as Word (even if it is an image without OCR)?
There are actions in Flow to populate a word template
For some odd reason my pdf is blank but my html file looks correct.
For the OneDrive convert file action. When I use the ID for the file in the Convert to pdf action. It create an empty file. When I use the path it says the id of the file is not valid.
*Edit:
I figured out my issue. You can't use flexbox or css grid. Have to use tables :(
Glad you got it. You are right the html is very picky what it will convert.
Hi Shane, I'm having problems with the "get file content" bit for the datauri string to convert my image (from SP) to something that can be inputted into my concat function.
I have a picture (jpg) in SP library so I use "Get File Contents" action as shown pointing it to my picture. I then initialise "photo" variable and set to string, use expression "dataUri('')" then select the "get file content" from the dynamic list like you suggest. It doesn't paste it in as "body('Get file content'), instead it puts dataUri('outputs('Get_file_content')?['body']'). When I hit "OK", it then says expression isn't valid. Any ideas?
I've also tried it with a OneDrive image file as well thinking it might have just been pesky SP, but it misbehaves too.
Any ideas?
Kathy I think you need one more ) at the end of the expression.
hi Shane, that's a great knowledge. What if I want to only add all choosed buttons or entered text WHEN send button is clicked? For example I have 4 buttons where person can choose and option and two text fields where he can enter some details.
Should be possible. What have you tried?
Just stopped this to add a comment. Letter ‘x’ brilliant!!!!
Yeah the first time I saw it I wasn’t sufficiently impressed. Took a while to understand how good that trick was. Vivek showed me. 😻
I'm using this with Power Apps but every time it store pdf to user's one drive account.
Any work around for centralized location for pdf?
The html file has to be users OneDrive. The pdf file you can create anywhere, like SharePoint
Hi Shane
Help please, I can't get around this. I created the flow in the power automate and when I do the test, everything runs fine, save the html in the onedrive folder and create the pdf file in the sharepoint folder as it is supposed to.
When I put the instruction on the button in OnSelect "htmlToPDF.Run (htmltext1.HtmlText), it stays underlined in red with the error message" Invalid number of arguments; 1 received, 0 expected ".
For now I am using the simple html "Table with border" without changing anything.
What am I doing wrong?
Thank you very much.
You forgot to Ask in Power Apps inside of you flow.
Shane & Others, when creating the HTML to generate the pdf, I am struggling with the format for a multi-select box. So I have a box that the user can select 1-7 options. When I write the HTML as follows, I only get 1 value back. How do I write it to get all of them?
"&ArtifactV.Selected.Value&"
Thanks
.SelectedItems is the key. Check my other pdf video where this is covered.
I might have just missed something, but when I am creating the first file from HTML, it isn't coming through as a PNG file, and the converter is saying it wont convert. It is having me open it in notepad
Yeah, that shouldn't happen. I would run through the steps again or this video ua-cam.com/video/pFlwYy8ijiA/v-deo.html is a newer version of the same stuff. Might be helpful to hear me say it again, differently.
Great video.. thanks for the kick in the right direction.. The conversion tool is still in preview and has more output.. But unfortunately also an error.. When I use the path variable it fails so I have to point directly to the file.. Do you know where I can report that error?
The forums are the best place for error reporting
Thank you so much Shane!
I see no way to have it landscape, but is there one way to make it fit the PDF size maybe?
I have had no luck with the free options to control the sizing like that. Maybe one of the paid options would work.
@@ShanesCows Thank you again. I shall share my "corporate "celebrity"" with you somehow!
I simply redesigned the entire layout.
However, one more question and a quick comment:
- In this video, we can eventually add information about the fact that we can have "ask in PowerApps" in PowerAutomate, and get a full HTML document made in PowerApps. Much easier than adding too many fields/requests from various queries.
- But then, the downsize of this = I lost the picture / the variable. So my HTML in PowerApps = I have the picture. I send email, the picture is still here. I create the pdf, and pschiit, is gone. Any idea? I cannot use your workflow, I have like 40+ information to add.
Thank you again, find me a way to share my celebrity :) (I already listed you in various PowerPoints about "where I learned")
Excellent tutorial... Any ideas on how to rotate the PDF orientation? (defaults to Portrait, need landscape).
I don’t think you can. 😔
Hi Shane, your videos have enabled me to produce a few apps and flows and my work colleagues think i'm amazing! The problem I have is with the image process in this tutorial in that I do not have the option to add dynamic content and then the option to add a function (fx). Instead I get blue (OD) and Purple (flow) icons with text. These are similar because if I hover the OD icon/text I can see it refers to "body('Get_file_content')". I suspect i'm using a different Sharepoint version, but would I still need to input dataUri( before the blue OD icon/text? I've tried with and without but cannot get the image to show. Thanks in advance!
Hmm. Not sure i will have to revisit and see if they broke something
Thanks Shane, nice! I created a file that I saved to Sharepoint and I couldn't figure out what kind of ID the convert to PDF wanted; the path and the ID didn't work for either version. I ended up using the Adobe converter instead but I'd love to know if I just got something wrong using the Onedrive version.
Another great useful topic...there are many times I need to create a dynamic filename (like with the date) and I am sure I could use Variable to create a string formatted the way I need and then Concat() to the rest of the filename.
Glad it helped. :)
How can I detect the error within that concat(' '). In your case, it seems easy that powerapps does have issue with apostroph 's.
I don't have any chewey's and the HTML code is complex and Flow says only that the expression is invalid. Ok. But where and how should I best find where the error is?
I don’t have any short cuts for finding your issue. Sorry
Thanks, it helps me on one night crash course on power apps.
Cool
when I switch from manuel trigger to Power apps(v2) I don't get the option to ask power apps. What am I doing wrong?
This video explains it. Sorry they changed things ua-cam.com/video/vpjf5mD-COs/v-deo.html
awesome, it works, any chance i could get certain parts of the html to pdf to print out instead of the entire portion based on drop down selections inside the app? or is that too much?
Basically the conversion process just wants text, it doesn't care how you get there. So if you can create logic to only send part of the HTML you want then you should be fine. There is a newer version of this video that may help ua-cam.com/video/pFlwYy8ijiA/v-deo.html
Hi Shane, Does a user need to have a share on the one drive, like they need for SharePoint? And have you tried to launch the PDF when created from PowerApps?
Flow will use the Flow creators account not the user . I haven’t tried to view the pdf but should work.
I'm having an error at the Convert file using path part. There's a warning that says 1 retries occurred. When I click View, it says "Status: BadGateway". I think the error started only yesterday. Thank you in advance!
Sorry I am slow. Hopefully the bad gateway worked itself out.
Hey Shane. This is a great video and let me do what I have been trying to do for a while! The only thing I'm finding is that I want to put more than 1 record into a table. How do I create a table and ask it to do a 'for each' kind of statement? I can't get it working without using a premium connector, which my organisation doesn't pay for. I have tried creating the HTML text in Powerapps itself and can get a table looking how I want it to, but when I put that through flow and into a word document, it looks really fuzzy... Can't work out how to make it less fuzzy.
Look for my Concat video. Shows exactly this. 😀
Really helpful vid, thanks.
I've used the trick of creating string variables to pass DataURI(file content) to HTML using Concat, which I'm then using in the body of an email to show a fancy logo.
The final email renders beautifully in Outlook and in my personal webmail client, but not in Gmail. Would you have any idea why that might be?
Maybe try what I show in this video around base64? ua-cam.com/video/bIne3DD3HAg/v-deo.html
@@ShanesCows I really appreciate the help, thanks. I've been greedy and posted a follow-up question on that linked video :)
Awesome! Can you loop through a collection or gallery to display into an HTML table?
I guess you could use a text field in PA with Concat to create the table, then reference that part of the text in the flow. Interesting possibilities
Any limit on the amount of text characters you can cram into either a text field in PA or with the Concat function in Flow?
Not that I know of but maybe. If you find one let me know.
Its all working fine but although i have a little problem. Unfortunately the pdf converter ignores the height an weight settings from my image within the image tag. Is there a way to fix this?
I feel like I have done the size stuff. Maybe try it as a style instead of inline.
Hi Shane, do you have any videos on how to merge PDF files into one PDF file? For example from a Powerapps form to be able to collect all the attached PDF files and call a Power Automate workflow to merge the PDF files into one file and then drop it into a SharePoint document library folder. Thanks
I don’t have a video but I have done it. It requires a 3rd party tool in flow. Go to flow and type in merge pdf and you will see the current players.
Ok thank you
This channel is so helpful!! Thank you.
You're very welcome!
Hi Shane thank for the video. I've tested this in our environment and it works very well. Is it possible to print 2 related SharePoint lists in one PDF, on one I want to pull the master data and on the other one I want to pull the details. Thank you
Yes. You just need to make the html. 😀
@@ShanesCows I've created the html file and it does pull the information from both the master and details however the information is not related meaning the printed information for my master doesn't not speak to the details. e.g invoice 007 header and invoice 0010 details
you control the HTML. So it is up to you to relate them within the PDF. PowerApps provides all of the info now you need to write HTML to display records in a related manner.
Have you made any videos on sending information from flow back to powerapps?
Yes. This one. 😀 PowerApps Flow Intro Upload an image to SharePoint using Flow ua-cam.com/video/ovLIwnj6QjU/v-deo.html
anyway of doing this but using multiple field in power apps ? for example char(10) doesnt work to make a line feed for the next set of data
I have thought about this a bit. I think I would make all of the html in PowerApps then send the chunk all at once to Flow.
@@ShanesCows I agree with that, that's what i've done in my application and it works! thanks so much Shane!
now i'm working on getting this PDF emailed to people as well. I'll see how that works
Hello Shane,
I'm trying to generate PDF from a SharePoint List but i have a few columns in the list which r in RICH TEXT format, any idea how I can get this into the PDF?
Responded to your other comment.
Good video Shane. 1 question regarding the HTML code using the TriggerBody expression: why did u use the 'CreateFile Filename' syntax in the td cell?thx
So I could use the value pulled from Power Apps. Making things more dynamic.
@@ShanesCows thx. No what I meant by that Q is what if you have multiple text inputs from the user, so how would write/use different expressions to handle the multiple data going into the html rows to create the pdf? Rgds
Hello Shane,
You used triggerbody () ['Createfile_FileName'] for one dynamic content, how can I make multiple dynamic fields?
Or what arguments do I need to pass in html for multiple dynamic fields...
Please suggest...
Click Ask in Power Apps again and that will generate more fields
@@ShanesCows Great, concept is clear and it's working fine, Thanks...
thank you so much!!!! all your videos are very helpful .. but my questions is if exist a way to create a PDF file in landscape view??.
Not that I know of.
Ok, I am new to PowerApps and have been trying to solve a problem with no results. I am trying to convert html to pdf, but with dynamic pictures. I have everything running and the flow works, but it doesn't show the pictures and is a red X where the pictures are supposed to be. The flow use one drive to export the html file to one drive as you show here, but a dynamic picture doesn't work in my case as I need dynamic. I haven't found one person yet that has addressed this issue. Obviously it has something to do with datauri, but how do you solve this?
The key is you have to use the base64 of the image in the img tag. Details here ua-cam.com/video/bIne3DD3HAg/v-deo.html
Great video to get started, I've got two questions I hope you or someone can help. How can I create a different pdf, every time the bottom is pressed?
Thanks so much agai
Look at my other pdf video for more ideas
Hi Shane, thanks for the video. I have a slightly different scenario and am wondering how to get it to work. If a mail is send, I extract the html body and save it to onedrive. That part works. I then convert it to pdf and the images won't show up. Any idea how I can fix it? As I don't save the images separately each time an email arrives.
You are going to have to get the images in base64 format. So downloading the file and such. Not super easy, possible but not easy. Other thing you might check if the 3rd party PDF tools support URLs for images. I don't know if they do or dont.
Hi shane what happens when you have multiple textboxes. How do you integrate trigger body in that situation. My submit button does not allow me to reference multiple textboxes
Never mind I figured it out
Hi Shane, if I want to create the whole HTML in a Rich Text control with Poerapps and then post the contents of 'Button->Createfile'.Run(RichTextEditor1.HtmlText) into flow, is this possible, and how do I set the concat statement as Concat('triggerBody()['Createfile_FileName']') does not work.
Rich text control will work for the body but you still need the header and footer html.
This works great for me but when users other than me try to use it they get an error saying "connection not configured for this service" . Any pointers would be great.
Do they maybe not have OneDrive accounts?
hi Shane
I have a editable pdf form or fillable pdf form. how can i use power apps so that when users click on the link they will be see the fillable form and when they fillup the details & submit a new pdf will be saved leaving the original pdf untouched.Can you help me with this please. Thanks
I haven’t done that before. Sorry
Hi Shane, First off thanks for the videos they've helped out tremendously. However, any suggestions on how to pull an image into the dynamic content flow in the above video?
Appreciate the help!
Covered in this video. ua-cam.com/video/2rfAQe1kK8M/v-deo.html
Shane. Thanks for the video. I have follwed it through but for some reason the html version shows as required but when it converts to PDF it drops off the section which is a Concat table to get items from a sharepoint list. Any idea what l could be doing wrong? Thanks in advance.
It is an html typo. Most likely you forget to close a or
Hi Shane , I have created flow that is perfectly working to convert html to pdf , html is landscape view ,but after conversion of pdf is portrait ,how do i make view of pdf file in landscape
I don't think it is possible.
Hi there, I'm having issues with the conversion of HTML file to PDF.
I used the same flow structure still when the PDF file is created one of the column gets cropped with all the contents.
I even raised a ticket, had a call with tech support even he seems to have the same issue.
Any idea what I must be doing wrong?
NOt sure. I would start with simpler HTML and see where things break. If you table is too wide for the page it does just get cut off.
I did and now I'm getting strange results like table gets vanished only the text under can be seen in PDF.
When I removed some rows it worked so I guess the whole content is exceeding page limit.
Is it possible to make some content move to next page when converted to PDF.
Hey Shane. Great video! Do you have a video (or other resource) on sending more than one value from PowerApps to Automate, to be able to then insert them into separate cells in the table (for eventual conversion to PDF)?
This video shows you how to send a whole collection over to Automate - ua-cam.com/video/imhxy3REgXc/v-deo.html
Any chance we are able to see how you can create a PDF using Microsoft Forms or Plumsail Forms to convert the data into a PDF?
I typically don’t cover paid connectors but if I get a chance I wouldn’t mind
Hey Shane, Great video. I wanted to know if there is any option to write more fields to PDF SharePoint? Currently you have one field in PowerApp as an example and my requirement is for 26 fields. Any tip would be helpful.
Build all the html in your app then just send it. Lots of ways to do this.
@@ShanesCows awesome video as usual. I was able to follow everything. Now I have about 20 fields from powerapp which I built in HTML but the value for each field is different. Can we use the expression ', triggerBody()['Createfile_FileName'] ,'to include multiple data/fields from powerapps content in to flow? Video timeline 21:13 you showed how to update a field in HTML in Flow. I tried duplicating this to another field and HTML and PDF output just copied the first value.... or does the coding need to happen from OnSelect like VideoMakePDF.Run(TextInput1.Text)? How do we include multiple data here so we can reflect in Flow?
Hi Shane,
Thanks so much for the great video.
I had one question Is it possible to download a bunch of monthly bills in pdf from a legacy system in bulk, split them and send the same as attachments to the respective customer on the bill. Regards,
Maybe... not sure. Sounds complex but not sure if it would work or not.