PowerApps PDF Generator using Microsoft Flow PDF Converter
ฝัง
- เผยแพร่เมื่อ 13 ต.ค. 2024
- In this video, you will learn how to create a PDF using the power of PowerApps, Flow, and OneDrive. We walk through everything from generating the HTML, to filling in the variables, adding Flow actions, and finally sending content from PowerApps to the PDF. Very cool.
John Liu's original blog post on PDFs johnliu.net/blo...
W3 School's HTML guide www.w3schools....
PowerApps and Flow consulting www.PowerApps9...
![โรงเรียนดัดสันดาน นักเรียนเถื่อน..!! [โรงเรียนไดเม่]](http://i.ytimg.com/vi/vRKPeXn4Fl4/mqdefault.jpg)
![[New in PowerApps] The new PDF() function is a gamechanger](/img/n.gif)
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. 🐶
Just started working with Powerapps and Flow. Thanks to your videos I achieved a great progress.
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!
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
"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 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!
"You can choose any option you want, as long as it's PDF...Because that's the only option you have" :'D
😂
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 🔥
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!
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.
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?
I thought my enthusiasm for learning powerapps was weird. I feel you, bro. GREAT job, as usual. Thank you for your effort!
Yup 😻
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
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. 😻
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.
Shanne you are awsome, you just can't imagine how much time you made us save. Please keep posting videos!
Glad to help. 😀
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. th-cam.com/video/bfXV_GXc_JM/w-d-xo.html
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
Thanks Shane. Had a customer the other day that wanted this and u solved it for me so easy. Thanks
Glad to help. 😻
OMG you're a hero !!! And this Concat function is just perfect
Thanks 😊 glad it helped.
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 🤷♂️
This is a great video thank you, Someone mentioned you had a way to also convert to Word? I need to create a dynamic template document based on Power Apps data/SharePoint. So looking to build a complete formatted word document in html with dynamic tables and then convert to Word. It seems easy enough in theory, but why is there no html to Word option - this seems more useful then pdf. Appreciate you thanks.
We haven't done it much here at PowerApps911 but when we have we have used the flow action Populate a Microsoft Word template and filled in the blanks. I have never went from HTML to Word. Maybe one of the 3rd parties like Encodian or Cloudmersive can do it? Not sure.
Great tutorial, thanks! Would you know how to turn left the pdf page?
I don’t 😑
You are awesome Shane. I love your videos!
Thanks 😎
Great video once again Shane! I have a use case for this exact process; however, I need to embed the possibility of word, pdf, and jpgs. Any advice for this process with word or pdf docs?
I got nothing for embedding Word or PDF. Maybe look at the 3rd party PDF tools to see if they make it an option? Not sure.
@@ShanesCows I decided to convert all the docs into pngs whenever they are uploaded to the doc library. In your flow however you are utilizing OneDrive for Business (Get file content). I am utilizing the SharePoint (Get file content) when we set that equal to a variable and embed that intot our HTML should be expect those abilities to function the same?
Hey Shane,
Great work as always.
Did you find a way to right justify last column (numbers) ???
Yes. In your html you need to specify the text-align to be right.
Brooo... Thank you so much for making our lives easier! This is very helpful!
Glad to help. 😀
That is a great tip Shane, thanks for sharing! Just a little question, how would you handle multiple variables?
It is the same concept. What is in the variables?
Thanks for your reply unfortunately I scrapped that idea. Thanks again for your videos great quality and professionalism!
Hi Shane
My name is Marco and I'm writing from you from Sydney Australia. Firstly I want to thank you for these videos! I watched them all over and over again and I learnt powerapps. I use your techniques in my apps that I am creating. I watched this video many many times and the way that it converts a HTML to PDF using flow. My big dilemma is that my html is Landscape and Onedrive does not convert the landscape HTML to PDF. Would you know what I have to do ?
Anyway Shane I appreciate everything you have done for me and thank you so much. Ciao Marco!
Hi Marco. Best I know there is no way to set landscape. 😑
Shane thank you so much to have answered me. Looking forward to other Powerapp videos. God Bless ! Marco
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 th-cam.com/video/pFlwYy8ijiA/w-d-xo.html
Thank you Shane, this is really helpful and easy to follow.
You're very welcome!
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 😁
Hi! All of your tutorials have been so helpful! Your presentation style is also the best I have seen and makes it much easier to understand than some of the other PowerApps videos on TH-cam. I have a question -- I'm using CSS in my HTML (not a lot, just adding some color to the tables mostly). When I use Flow(Power Automate) to convert to HTML, the HTML file looks right. But when it converts the HTML file over to PDF, the PDF no longer has the CSS formatting in the tables. Any ideas?
The conversion process is super picky about how you do styling. If it doesn’t work one way try another. Usually there is one that works. If you don’t get it email me and I can sit out the code I use to do colors.
@@ShanesCows same issue with me. the result of PDF is no-color even the html has color. please advise
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
Perfect timing. I was trying to figure out how to do just this. Thank you so much!
Is there a way to save the PDF to a different name, based on an entry? What about a print button to print the created PDF right from the App itself?
You could send the filename as a variable from PowerApps. No problem. Printing? WHat if you launch the PDF in the browser? Not sure about that one.
Hey Shane, awesome tutorial as always! Hope you don't mind me asking how would I be able to send the data I made in your repeating tables (gallery items and collection) into this PDF file? I'm kind of stumped how to do that, I feel like it's a get item from that library where the master ID = ID of that form, and I'll need to do a loop (for each) but I don't know how to put all of that in to the HTML you did.
Any ideas?
ForAll works for looping through a collection. But yeah working out the html will be a pain.
THANK YOU!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!
I was just trying to figure this out myself. You just saved me a TON of time!
Glad to help. 😀
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.
Shane you are awesome! I've learned so much watching your videos. I'm currently working on this PDF conversion and have everything working, except figuring out alignment. My html included center aligned headers and tables, but everything gets left aligned in power apps. Any thoughts? Thanks!
Post a new comment with what you are using to center with.
@@ShanesCows here is an example:
h2 style=‘text-align: center;’>Pricing Proposal
It’s like you knew that I needed this video in my life :-)
I made it just for you. 😻
Thanks so much- great video as usual Shane! Is it possible to use Rich Text fields without getting square characters at strange places in the pdf (mostly at the beginning of a line)? There's actually one in the middle of a word which I can't figure out. I don't see it even when looking at the native html via a label.
Also do you know of a good explanation (video) of how to Email a file (pdf) as an attachment from a SharePoint library? (The second step of the operation)
Best Regards,
Paul
Hey Paul - I haven't seen the square boxes before. :(
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. th-cam.com/video/2rfAQe1kK8M/w-d-xo.html
Hi Shane! this video was so helpful. I am able to create the HTML but when I convert to PDF and open the file I get a message that it doesn't have a preview and similar message when I download it to view. THANK YOU SO MUCH!
You have a typo in your html most likely. Thaw conversion is very grumpy
Hello Shane - Great video! Thank you so much for all the videos you put up, helps a lot!!! I have a question, I have a rich text box which our end users want to add image along with the text (not always and not the names number of images). What can I do in this situation?
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 - th-cam.com/video/imhxy3REgXc/w-d-xo.html
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. 😻
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. 😀
Shane your videos are AWESOME! They have helped so much. I have successfully gotten this to work - the picture since there is the bug. The one snag that I am running into is that I am creating a button in powerapps to start the flow (like the video) and then a popup in powerapps that provides a web-link to the file. It works fine for me but when someone else uses it the flow creates the file in their personal one drive folder and not the shared one drive folder that the link opens. Do you have any ideas how to get this to work?
You just need to look at your create file action. You control the connection.
Hey Shane, Great video's I'm a big fan. Quick question how would I get multiple text inputs into the PDF. Example you've done it for chewys cup amounts for Tuesday but how about Wednesday Thursday and Friday.
Hi Shane, Great stuff I really get a lot out of your videos! Is there a limit to the amount of HTML you can put into the concat function in a flow? I have a one page doc worth of HTML and it looks to be fine but flow will not take it.
I think the limit is around 1 MB of HTML content in Flow
Great Video Shane!
One question though, how would you send multiple feeds back to flow for the HTML from PowerApps. In your case, you had one field you sent through, what if you want to dynamically add another line to that grid for the next day with all 3 it's values coming from PowerApps input.
Thanks.
You can ask in PowerApps as many times as you want.
@@ShanesCows Can i please know how i can do this in flow? 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.
Hi Shane, I have been following your videos and are very helpful. Just a quick question, have you figured out a way to send a link back to power apps so we can download the created pdf from the App?
Yes in Flow there is a respond to Powerapps. This video shows exactly that th-cam.com/video/ovLIwnj6QjU/w-d-xo.html
Dude you are the best! You make the learning process easier and enjoyable. keep the hard work!!
Thank you. I will. 😀
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
Amazing video super helpful! One quick Q - after creating the PDF, is there anyway to have it automatically open for the end user?
Get the link in your app and use the Launch function. 😀
@@ShanesCows What if this link cannot be shared with anonymous users. Because of restricted access of one drive.
Hey Shane, your videos are a real life-saver, thank you! I built a Flow just like in your video, but the PDF part of the OneDrive connector is still in Preview state (and probably will be forever) and my IT department wont let me put this into production. I looked into 3rd Party connectors, but we cannot use them because they're mostly American companies who dont comply with GDPR (PDF will contain sensitive company data). I'm now building an Azure Function which does just the same, what a hassle!
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?
A.M.A.Z.I.N.G !! saved me hours of endless training, forever grateful ;)
Glad to help. 😀
Great Video! Got a new subscriber. I'm running into an issue tho. Lets say two different logos need to be displayed in your demo depending on a Boolean. How would I go about doing this?
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
Hey Shane,
This video is very helpful.My question is this can we also generate power point slide when a new item is created?
Not sure. I have never tried to make a ppt slide
Hi Shane,
Thanks for the awesome video. It's very informative. However I'm struggling with the convert pdf function. I'm using a grid format for my HTML code. Everything shows up properly when looking at the .HTML file that is generated through power automate but the PDF looks wonky. It would seem that it doesn't recognize the CSS? I've tinkered around quite a bit with this and it seems that tables are the only that that formats well. Does the PDF converter not work well with CSS? Thanks again, your tutorials are the best.
Hi Hunter - It depends. 😑 The conversion process is so grumpy. With HTML there is 10 ways to do most things so i just keep trying different ways till i find one it likes. It is not fun but I usually can find the answer.
great video! thanks so much for explaining every step! Great job!
You're very welcome!
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
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,
A lot of really good stuff!!!
I have a question:
I really need to have a word document in a SharePoint document library converted to PDF. Can you build out such a video or describe what if at doable must be done for that?
Thanks in advance!
Have your Flow move the file to OneDrive, then you can convert it using the same method. Then you can delete it from OneDrive.
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.
Hi Shane,
Great video! I have followed your steps to make multiple different solutions for my company. I have noticed that there are many html style options that work when using the W3 Tryit Editor, but do not work once the HTML is put into the Flow. Do you know why this is? Does flow use it's own HTML compiler that has a different library of actions? Thank you.
The PDF converstion Action is very picky about HTML. Sorry, just one of those things you have to fight your way through.
Hi Shane. Great videos! What is the best way to merge two pdf files using flow and or power apps?
Hey Matt. Sadly you have to use a 3rd party tool to merge PDFs. I have done it with Plumsail but there are several vendors.
@@ShanesCows thanks. We are trying out enchodian. Just about got it working today. Had a few issues with adding the file content dynamic content in the array variable. When I removed and readded (no other change) it eventually worked. Seemed to work and not work at random times
Hey Shane, Great video with lots of solid information! I had a quick question about the flow. I am using this for a rec form, so the form saves to onedrive of the user who is submitting the request, what would be the best way to move this pdf to the SharePoint team site I need it to be located in? I have been researching and cannot find a definitive answer or solution. Any help will be greatly appreciated!
You should be able to use the create file in SharePoint action. What have you tried that isn’t working?
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.
Hello, Shane. Thank you very much for all of your videos. They are awesome! I am constantly telling colleagues interested in PowerApps to check out your page. Question for you, I am following along with your video and the flow expression is working just fine until I paste in the PowerApps trigger syntax, then I get a "The expression is invalid." error. I even checked the expression with the ' , ' as you do in the video. The syntax is copied and pasted directly from Flow (as you do with everything after the "x"). Any idea what can be causing this?
Hard to say. Make a new comment with your formula and I can try to help.
@@ShanesCows Thank you for taking the time, Shane. I get the error when pasting the field under "Requested Date":
concat('
table, th, td {
border: 1px solid black;
border-collapse: collapse;
}
th, td {
padding: 15px;
text-align: left;
}
table#t01 {
width: 100%;
background-color: #f1f1c1;
}
Needs Assessment
Scope of work:
Testing
Cost:
Testing
Knowns:
Testing
Tool used (y/n):
Testing
Turn Around time (weeks):
Testing
Information:
Testing
Number:
Testing
Category:
Testing
Sample:
Testing
Test / No Test:
Testing
Requested Date:
’, triggerBody()['Createfile_FileContent'],‘
Items:
Testing
')
THANK YOUU AGAIN! I've been having such trouble trying to combine powerapps and flow. Nothing is ever too simple - is it? :')
You are welcome. :)
Thanks for your wonderful video, I got a lot of knowledge from your video. And for this topic, I have two question . Could I create file in SharePoint at first step when I create HTML context file？ But I founded that there is no method to convert file to PDF from SharePoint directly, So if an apps need some people besides me to edit and generate a PDF file in SharePoint, where need to create html file at first? One drive only for personal I think, other people couldn't get access to edit. Could you give me some suggestion? The other problem is when I make a declaration for html file language is Chinese, but after file generated to PDF is mess code. So whether "html text "couldn't support Chinese language in Power Apps?
Thanks a lot.
OneDrive works. It will create the first file in each user’s own OnesDrive. No issue
@@ShanesCows So I don't need to share my one drive to others? I have tried to shared with my one drive give someone, she could generated a pdf documents but no detailed information only showed" Show HTML text....." .But if I click "export pdf" will be success! So I'm doubt about whether there is something wrong with one drive access.
Thanks for your kindly help.
Great video, I'm learning a lot from them.
My question is if I can generate the PDF in landscape mode? Do you have any idea that the htmltext of powerapps does not accept css?
I don’t think you can. 😔
By any chance, unless you found out, do you know a way to "make it fit" the page then?
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.
Thanks shane this was just what we needed and was really easy to consume. Just out of my ignorance, how to handle if we want all the records in a gallery like repeating table to be printed? I have tried by passing the variables to run the flow and it is only printing the last record in the gallery. can you please shed some light?
Try this video th-cam.com/video/bfXV_GXc_JM/w-d-xo.html 😎
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. th-cam.com/video/bIne3DD3HAg/w-d-xo.html One day I need to revisit these PDF videos. :)
Hello Shane! It's awesome all the work you're doing for us, thank you!! I wanted to ask how the procedure would change if I have different inputs for the pdf, for example a pdf about a cart from a marketplace. In my project I'm trying to generate reports for every business that's associated with any of the items in the shop cart and filtering the products for each report as needed, thing is as difficult as it hears o not that much?? Thanks in advance!!
Shouldn't matter the input. Create the HTML you want and send all of it to flow. Use conditionals aka If. :)
@@ShanesCows absolute legend ❤ thanks a lot, I'll try it tomorrow 🤝
Hi Shane,
Very nice videos I watch them all. Was wondering if you knew of a way to have the powerapps image pass through to flow and render properly on the pdf? I have several powerapps and flows generating reports but I cannot get the image to pass through. It shows in the HTML text box in my powerapps but not on the converted PDF. Any insights would be most appreciated.
Thanks again for all of the great videos
If the image is not working it is usually the Flow expression step in the video that isn't correct.
Did you find a way to make this work? If so, could you explain? I’m having the same issue.. Thanks in advance!!
My issue is in the single a double quotations. If I replace the double quotations from the HTML to single quotations in the powerapps HTML text, what do I do with the single quotations that surrounded the variable that I created in Flow to store the image from Onedrive?
This channel is so helpful!! Thank you.
You're very welcome!
Hi Shane, I am really loviong this series on PowerApps and Flow(Power Automate). However, I am seeing a lot of differences between your version, produced in 2018 and the PowerApps version out now (in 2020). One thing I cannot find regarding the PDF flow video, is what is the new name for the "Ask in PowerApps area and I also could not find the CreafFile_FileName variable either. Was it removed? Thanks!
Ask in PowerApps works the same way. Not sure why you aren’t seeing it. 😑
@@ShanesCows Hi Shane, I was able to find it. I think I chose the wrong Power Apps connector. Now I a working on gettibg the fields from my form into HTML so I can generate the PDF. Thanks!!
Excellent tutorial... Any ideas on how to rotate the PDF orientation? (defaults to Portrait, need landscape).
I don’t think you can. 😔
Shane, thank you so much! One question and it may sound silly, is there anyway to include a CSS with this? Or any sort of styling rather than HTML?
You have to experiment. I have made one that looks pretty nice. Just took elbow grease and experimenting.
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.
Shane, you are a saviour! Happy new year :)
Thanks Carol and right back at you. 😻
Hi Shane
As per-usual a great informative video helping people like me :)
Just a quick question i use a HTML template with {holdertag}s utilising individual Compose functions and Replace expressions.
How do you add an image utilising this method?
Sorry never done that. 😔
@@ShanesCows ah well looks like i will have to find another way :(
That was worth watching, very helpful....
Glad to hear it!
Hi Shane, great work as always and great video, but I have a question, how can I send the generated PDF to an email? Thank you.
In Flow there is an action for send an email that allows you to attach files.
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.
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? th-cam.com/video/bIne3DD3HAg/w-d-xo.html
@@ShanesCows I really appreciate the help, thanks. I've been greedy and posted a follow-up question on that linked video :)
Great video very useful. Just one question, am I able to convert SPO list to PDF. Thank you.
You could. Just have to work your way through the content and pass it to the HTML.
Hey Shane, another awesome tutorial - have you found a way to use a web hosted image asset within the output PDF? It displays fine in the HTML generated but then errors in the PDF.
I think I messed with that but now I am drawing a blank. Hmmm I don’t remember. Can you download the file first with Flow?
Shane Young yeah, I managed to do that using flow, unfortunately I wanted to dynamically include a bunch of images. Annoying as they display in the generated HTML file. Thanks though.
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. :)
Excellent video content, easy to follow, great concept. I did, however, find what I believe to be a character limit on the expression field. I don't know the exact number, but my initial html code was too long to be valid. I did, eventually, get it to work after tinkering & removing several lines of code. Looking forward to more videos on PowerApps.
Interesting. Thanks for sharing. I haven’t ran into that yet but when I dig in on this project I will see what happens.
HI Mr Young, thank you so much for your teaching to us. Is that you mean that a traditional HTML file with embedded jpg, png, docx. to PDF? and even using tag to display outlook email content in HTML?
Hi Shane,
that`s a great video as always, thanks a lot !!! 🙂
In your example you`re passing only one information/field (= 9 cups) from Power Apps to Flow/Power Automate.
How does the VideoMakePDF.Run(XXXXX) expression needs to look like if i want to pass multiple fields and how can i reference/select the various variables in the HTML code via the triggerBody() expression in Power Automate then?
Thanks in advance.
This is super cool. Dynamic PDF generation. Thank you.
Glad to help. 😀