PowerApps PDF Generator using Microsoft Flow PDF Converter

  Рет қаралды 201,750

Shane Young

Shane Young

Күн бұрын

Пікірлер: 839
@AdiCristea
@AdiCristea 6 жыл бұрын
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!
@ShanesCows
@ShanesCows 6 жыл бұрын
Thank yoU!
@hahahaha7023
@hahahaha7023 4 жыл бұрын
i think i'm gonna dial 911
@tysonleonidas2955
@tysonleonidas2955 3 жыл бұрын
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!
@davianbrayan2585
@davianbrayan2585 3 жыл бұрын
@Tyson Leonidas instablaster =)
@tysonleonidas2955
@tysonleonidas2955 3 жыл бұрын
@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.
@feliciadawn5014
@feliciadawn5014 4 жыл бұрын
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!
@ShanesCows
@ShanesCows 4 жыл бұрын
You are very kind. 🐶
@rambonumber007
@rambonumber007 5 жыл бұрын
Just started working with Powerapps and Flow. Thanks to your videos I achieved a great progress.
@snork2209
@snork2209 4 жыл бұрын
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!!
@ShanesCows
@ShanesCows 4 жыл бұрын
That is awesome! Good job to you Snork!
@christianpilon163
@christianpilon163 5 жыл бұрын
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
@ShanesCows
@ShanesCows 5 жыл бұрын
Cool
@christopherspencer8239
@christopherspencer8239 4 жыл бұрын
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!
@ShanesCows
@ShanesCows 4 жыл бұрын
Awesome!
@thekreehaytion
@thekreehaytion 5 жыл бұрын
Shanne you are awsome, you just can't imagine how much time you made us save. Please keep posting videos!
@ShanesCows
@ShanesCows 5 жыл бұрын
Glad to help. 😀
@burning_out
@burning_out 6 жыл бұрын
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
@ShanesCows
@ShanesCows 6 жыл бұрын
I like it. 😻
@mgtd1138
@mgtd1138 4 жыл бұрын
How would you accomplish that specifically?
@82foghornleghorn
@82foghornleghorn 3 жыл бұрын
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!
@ShanesCows
@ShanesCows 3 жыл бұрын
Awesome 😎
@MrAbueslam
@MrAbueslam 2 жыл бұрын
Can you please show me how you managed filling in lookup records and data table fields in html. I am having issue with that.
@tenisviejos
@tenisviejos 5 жыл бұрын
I thought my enthusiasm for learning powerapps was weird. I feel you, bro. GREAT job, as usual. Thank you for your effort!
@ShanesCows
@ShanesCows 5 жыл бұрын
Yup 😻
@johnmizell4683
@johnmizell4683 5 жыл бұрын
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!!!
@ShanesCows
@ShanesCows 5 жыл бұрын
Cool
@chrislambe400
@chrislambe400 5 жыл бұрын
"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
@ShanesCows
@ShanesCows 5 жыл бұрын
Glad it helped and hope you remembered to shower. 😂
@ludwighallgren2554
@ludwighallgren2554 6 жыл бұрын
Thanks Shane. Had a customer the other day that wanted this and u solved it for me so easy. Thanks
@ShanesCows
@ShanesCows 6 жыл бұрын
Glad to help. 😻
@StevenNel
@StevenNel 5 жыл бұрын
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.
@ShanesCows
@ShanesCows 5 жыл бұрын
Yes but that creates a lot of extra “noise” in the html that is really scary to a newbie.
@androidgeeking
@androidgeeking 3 жыл бұрын
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.
@ShanesCows
@ShanesCows 3 жыл бұрын
Thanks for sharing!
@Chris-ig5qz
@Chris-ig5qz 6 жыл бұрын
It’s like you knew that I needed this video in my life :-)
@ShanesCows
@ShanesCows 6 жыл бұрын
I made it just for you. 😻
@peterhowell4502
@peterhowell4502 5 жыл бұрын
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.
@ShanesCows
@ShanesCows 5 жыл бұрын
Thank you Peter. 😻
@frenamakenson9844
@frenamakenson9844 3 жыл бұрын
thinking you were making this video in 2018... Awsome , thank you a lot for the sharing
@ShanesCows
@ShanesCows 3 жыл бұрын
I feel like I should make a new version but nothing has changed so 🤷‍♂️
@Maynardjones100
@Maynardjones100 3 жыл бұрын
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
@ShanesCows
@ShanesCows 3 жыл бұрын
Very kind of you. Hope you have a great weekend 🔥
@divyanshgupta3760
@divyanshgupta3760 4 жыл бұрын
Brooo... Thank you so much for making our lives easier! This is very helpful!
@ShanesCows
@ShanesCows 4 жыл бұрын
Glad to help. 😀
@GrBritton
@GrBritton 4 жыл бұрын
THANK YOU!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!! I was just trying to figure this out myself. You just saved me a TON of time!
@ShanesCows
@ShanesCows 4 жыл бұрын
Glad to help. 😀
@ghuerren
@ghuerren 4 жыл бұрын
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!!!!
@ShanesCows
@ShanesCows 4 жыл бұрын
Awesome 😁
@bexjuice
@bexjuice 3 жыл бұрын
OMG you're a hero !!! And this Concat function is just perfect
@ShanesCows
@ShanesCows 3 жыл бұрын
Thanks 😊 glad it helped.
@elierh442
@elierh442 5 жыл бұрын
Dude you are the best! You make the learning process easier and enjoyable. keep the hard work!!
@ShanesCows
@ShanesCows 5 жыл бұрын
Thank you. I will. 😀
@julmasson6403
@julmasson6403 3 жыл бұрын
A.M.A.Z.I.N.G !! saved me hours of endless training, forever grateful ;)
@ShanesCows
@ShanesCows 3 жыл бұрын
Glad to help. 😀
@eriks707
@eriks707 4 жыл бұрын
"You can choose any option you want, as long as it's PDF...Because that's the only option you have" :'D
@ShanesCows
@ShanesCows 4 жыл бұрын
😂
@niebieskiYT
@niebieskiYT 4 жыл бұрын
You are awesome Shane. I love your videos!
@ShanesCows
@ShanesCows 4 жыл бұрын
Thanks 😎
@HowToExcelBlog
@HowToExcelBlog 6 жыл бұрын
Can you skip the HTML and send your collection into a table in an Excel template, then convert that Excel file to PDF?
@ShanesCows
@ShanesCows 6 жыл бұрын
I don’t know how to convert excel to pdf programmatically.
@manuel_antonio_rivera_socarras
@manuel_antonio_rivera_socarras 4 жыл бұрын
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.
@ShanesCows
@ShanesCows 4 жыл бұрын
Glad to help. 😀
@stormybanjo
@stormybanjo Жыл бұрын
Thank you Shane, this is really helpful and easy to follow.
@ShanesCows
@ShanesCows Жыл бұрын
You're very welcome!
@keldonmoodley7565
@keldonmoodley7565 6 жыл бұрын
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!
@ShanesCows
@ShanesCows 6 жыл бұрын
Cool. Glad it works for you.
@kalliroi6182
@kalliroi6182 2 жыл бұрын
great video! thanks so much for explaining every step! Great job!
@ShanesCows
@ShanesCows 2 жыл бұрын
You're very welcome!
@MaicaLRM
@MaicaLRM 6 жыл бұрын
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!
@ShanesCows
@ShanesCows 6 жыл бұрын
Cool
@gabed06
@gabed06 3 жыл бұрын
That was worth watching, very helpful....
@ShanesCows
@ShanesCows 3 жыл бұрын
Glad to hear it!
@donah26
@donah26 4 жыл бұрын
Thanks, it helps me on one night crash course on power apps.
@ShanesCows
@ShanesCows 4 жыл бұрын
Cool
@pkp044
@pkp044 3 жыл бұрын
This is beautiful!!! Thank you so much for sharing this Shane!!
@ShanesCows
@ShanesCows 3 жыл бұрын
My pleasure!!
@mrstevennewmanEDU
@mrstevennewmanEDU 6 жыл бұрын
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.
@ShanesCows
@ShanesCows 6 жыл бұрын
That is awesome. I have toyed with patreon but I don’t know. 😀
@k1ngydoteth403
@k1ngydoteth403 4 жыл бұрын
@@ShanesCows You defo should lol
@PeterPanQuails
@PeterPanQuails 4 жыл бұрын
This is super cool. Dynamic PDF generation. Thank you.
@ShanesCows
@ShanesCows 4 жыл бұрын
Glad to help. 😀
@mds2672
@mds2672 5 жыл бұрын
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
@ShanesCows
@ShanesCows 5 жыл бұрын
Thanks
@djams1845
@djams1845 3 жыл бұрын
Shane, buen día. Realmente nos aportas mucha ayuda con tus videos de ejemplos y soluciones. Gracias!
@georgewinters2066
@georgewinters2066 6 жыл бұрын
Bravo! Fantastic! Clear, concise, and cogent!
@ShanesCows
@ShanesCows 6 жыл бұрын
Thanks George!
@matthewprzybylowski5626
@matthewprzybylowski5626 5 жыл бұрын
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?
@ShanesCows
@ShanesCows 5 жыл бұрын
Sorry I got nothing Matthew
@kattikawn
@kattikawn 4 жыл бұрын
I’ve just run into this same snag. Did you ever find a solution, Matthew?
@elizabethbadenhorst3556
@elizabethbadenhorst3556 2 жыл бұрын
This channel is so helpful!! Thank you.
@ShanesCows
@ShanesCows 2 жыл бұрын
You're very welcome!
@carolblay
@carolblay 4 жыл бұрын
Shane, you are a saviour! Happy new year :)
@ShanesCows
@ShanesCows 4 жыл бұрын
Thanks Carol and right back at you. 😻
@ericbauwens1642
@ericbauwens1642 2 жыл бұрын
Awesome, that is exactly what I need for one of my projects! Thanks Shane!
@ignaciosaravia7059
@ignaciosaravia7059 3 жыл бұрын
Great Job Shane! Excelent videos! Thanks a lot!
@ShanesCows
@ShanesCows 3 жыл бұрын
My pleasure!
@LannaSanches
@LannaSanches 3 жыл бұрын
Great tutorial, thanks! Would you know how to turn left the pdf page?
@ShanesCows
@ShanesCows 3 жыл бұрын
I don’t 😑
@clivemorgan2434
@clivemorgan2434 4 жыл бұрын
Absolutely Awsome Shane, so well explained.
@ShanesCows
@ShanesCows 4 жыл бұрын
Thanks Clive 😁
@NICAMARCEL1
@NICAMARCEL1 4 жыл бұрын
@Shane Young, two years later ago you posted this video and I'm learning it now! :)
@ShanesCows
@ShanesCows 4 жыл бұрын
Awesome!
@guyinazo
@guyinazo 6 жыл бұрын
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.
@ShanesCows
@ShanesCows 6 жыл бұрын
Glad it helped. :)
@ahlan3609
@ahlan3609 4 жыл бұрын
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!
@ShanesCows
@ShanesCows 4 жыл бұрын
Thanks Alan. This video should help speak to how we can get lots and dynamic data into the mix. kzbin.info/www/bejne/mJe7h5J9jciSgK8
@joeburns8059
@joeburns8059 5 жыл бұрын
Very useful Shane as are all your videos. Thanks so much for sharing.
@ShanesCows
@ShanesCows 5 жыл бұрын
You are welcome. Glad it helped. :)
@chrisbartman5125
@chrisbartman5125 6 жыл бұрын
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.
@ShanesCows
@ShanesCows 6 жыл бұрын
Interesting. Thanks for sharing. I haven’t ran into that yet but when I dig in on this project I will see what happens.
@seadude
@seadude 6 жыл бұрын
Are you serious!? I was just chatting with you how I had done this with Sharepoint..." HA! Here you are with the video! Nice!
@seadude
@seadude 6 жыл бұрын
Interesting! I did this a bit different: PowerApps to Sharepoint to Word Template to PDF. Love how flexible these tools are!
@ShanesCows
@ShanesCows 6 жыл бұрын
Yeah I chuckled the other day. 😀
@rebeccaj138
@rebeccaj138 6 жыл бұрын
@@seadude do you have a tutorial on your method?
@davecawthorn2234
@davecawthorn2234 6 жыл бұрын
Just stopped this to add a comment. Letter ‘x’ brilliant!!!!
@ShanesCows
@ShanesCows 6 жыл бұрын
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. 😻
@tmcpang
@tmcpang 4 жыл бұрын
This is an awesome video. I think it'll be very useful for in the near future. Thank you so much Shane.
@ShanesCows
@ShanesCows 4 жыл бұрын
I love PDFs 😍
@contactpaulo
@contactpaulo 3 жыл бұрын
Great content! Congrats Shane!
@ShanesCows
@ShanesCows 3 жыл бұрын
Thanks
@callfusion2012
@callfusion2012 5 жыл бұрын
Great!!! Now i can produce the invoices from my powerapp til now i did it with Access and ODBC on the database. Im happy! ;-) Thanks!
@ShanesCows
@ShanesCows 5 жыл бұрын
Glad to help. 😀
@kairbekshagiyev6628
@kairbekshagiyev6628 4 жыл бұрын
Many thanks for video, Shane.
@ShanesCows
@ShanesCows 4 жыл бұрын
Glad to help. 😀
@robinmauldin6149
@robinmauldin6149 4 жыл бұрын
My HTML isn't working in Flow. I keep getting an error message stating "The Expression is invalid" Any suggestions on how to check the format?
@ShanesCows
@ShanesCows 4 жыл бұрын
Make a very simple html and try again. It should work
@VibeOfCeylon
@VibeOfCeylon 2 ай бұрын
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?
@ShanesCows
@ShanesCows 2 ай бұрын
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 kzbin.info/www/bejne/Z3-agXV6n7mMZ7c
@MarcelinTchango
@MarcelinTchango 5 жыл бұрын
Fantastic, clearly explained
@ShanesCows
@ShanesCows 5 жыл бұрын
Thanks
@tokiokuwamura5817
@tokiokuwamura5817 5 жыл бұрын
Thank you very much this is exactly what I wanted! Awesome!!
@ShanesCows
@ShanesCows 5 жыл бұрын
Glad to help. :)
@tausifjamkhandi1597
@tausifjamkhandi1597 6 жыл бұрын
Awesome as always😊 thank you for this info
@ShanesCows
@ShanesCows 6 жыл бұрын
Glad to help.
@umeshkunvar4439
@umeshkunvar4439 3 жыл бұрын
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.
@ShanesCows
@ShanesCows 3 жыл бұрын
Sorry I am slow. You will need to ask in Power Apps, inside your flow, multiple times.
@carolevandenberg1474
@carolevandenberg1474 4 жыл бұрын
Love these videos - fun, and super helpful every time! Can we meet Chewy some day? I mean thru KZbin, of course.
@ShanesCows
@ShanesCows 4 жыл бұрын
Hi Carole he shows up in some videos. Or you email shane at www.PowerApps911.com and I will send you some pics. He likes the attention 😂😂😁
@carolevandenberg1474
@carolevandenberg1474 4 жыл бұрын
Shane Young I will keep watching videos - fun incentive to watch more, I might get to see Chewy! I need to teach my dogs how to build in PowerApps now...
@MrNicolaslima
@MrNicolaslima 6 жыл бұрын
very very cool, man blowed my head too, congratulations.
@ShanesCows
@ShanesCows 6 жыл бұрын
😀 Cool
@johnmizell4683
@johnmizell4683 5 жыл бұрын
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?
@ShanesCows
@ShanesCows 5 жыл бұрын
You have to experiment. I have made one that looks pretty nice. Just took elbow grease and experimenting.
@voydesvelado
@voydesvelado 4 жыл бұрын
Very helpful. Thank you so much.
@ShanesCows
@ShanesCows 4 жыл бұрын
Your are welcome 🙏
@CliveMMorgan
@CliveMMorgan 4 жыл бұрын
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.
@ShanesCows
@ShanesCows 4 жыл бұрын
Rich text control will work for the body but you still need the header and footer html.
@HowToExcelBlog
@HowToExcelBlog 6 жыл бұрын
Awesome! Can you loop through a collection or gallery to display into an HTML table?
@HowToExcelBlog
@HowToExcelBlog 6 жыл бұрын
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
@HowToExcelBlog
@HowToExcelBlog 6 жыл бұрын
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?
@ShanesCows
@ShanesCows 6 жыл бұрын
Not that I know of but maybe. If you find one let me know.
@luismmpgoncalves
@luismmpgoncalves 4 жыл бұрын
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.
@ShanesCows
@ShanesCows 4 жыл бұрын
You forgot to Ask in Power Apps inside of you flow.
@latrobe15
@latrobe15 6 жыл бұрын
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)
@ShanesCows
@ShanesCows 6 жыл бұрын
Yikes. Sorry, I am not great with HTML. I have to imagine it is possible but not sure. Sorry.
@latrobe15
@latrobe15 6 жыл бұрын
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.
@ShanesCows
@ShanesCows 6 жыл бұрын
So many nuances. 😑 Makes it interesting. 😻
@latrobe15
@latrobe15 6 жыл бұрын
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?
@ShanesCows
@ShanesCows 6 жыл бұрын
Flow will use the Flow creators account not the user . I haven’t tried to view the pdf but should work.
@kathystubbs5183
@kathystubbs5183 3 жыл бұрын
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?
@ShanesCows
@ShanesCows 3 жыл бұрын
Kathy I think you need one more ) at the end of the expression.
@andyl2895
@andyl2895 2 жыл бұрын
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!
@thurstanp
@thurstanp 4 жыл бұрын
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
@ShanesCows 4 жыл бұрын
So I could use the value pulled from Power Apps. Making things more dynamic.
@thurstanp
@thurstanp 4 жыл бұрын
@@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
@NOR3MSTI
@NOR3MSTI 2 жыл бұрын
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?
@ShanesCows
@ShanesCows 2 жыл бұрын
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 kzbin.info/www/bejne/pnfPqIyvbc6dn6M
@guillaumep8188
@guillaumep8188 4 жыл бұрын
Thanks Shane, you made my day !
@ShanesCows
@ShanesCows 4 жыл бұрын
Awesome! You made mine.
@amosp.godbyhighschool8054
@amosp.godbyhighschool8054 2 жыл бұрын
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?
@ShanesCows
@ShanesCows 2 жыл бұрын
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. kzbin.info/www/bejne/mHrRlmZ6eZh7d8k One day I need to revisit these PDF videos. :)
@lilfrog5
@lilfrog5 4 жыл бұрын
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)?
@ShanesCows
@ShanesCows 4 жыл бұрын
There are actions in Flow to populate a word template
@abuyotam
@abuyotam 4 жыл бұрын
Hi Shane, I'm having a strange bug, while the HTML file shoes my image the PDF does not, is there something wrong in my code line: Thanks, Giora
@ShanesCows
@ShanesCows 4 жыл бұрын
Looks right at first check. I would check the rest of your html and look. For any missing tags
@이재원-k5n
@이재원-k5n 5 жыл бұрын
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!!
@ShanesCows
@ShanesCows 5 жыл бұрын
Try this kzbin.info/www/bejne/mJe7h5J9jciSgK8
@AhmedNaseem
@AhmedNaseem 4 жыл бұрын
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?
@ShanesCows
@ShanesCows 4 жыл бұрын
Yes in Flow there is a respond to Powerapps. This video shows exactly that kzbin.info/www/bejne/paeveqqkn5uEoLc
@larizavelazquez5441
@larizavelazquez5441 5 жыл бұрын
Thank you for your videos! They are really useful
@ShanesCows
@ShanesCows 5 жыл бұрын
Glad to help
@susanclark1778
@susanclark1778 3 ай бұрын
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.
@ShanesCows
@ShanesCows 3 ай бұрын
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.
@babylynfrogoso1367
@babylynfrogoso1367 6 жыл бұрын
Amazing VIDEO !!!!!!!!!! THANK YOU SO MUCH SHANE!!!!!!!!
@ShanesCows
@ShanesCows 6 жыл бұрын
Thank you. 😀
@babylynfrogoso1367
@babylynfrogoso1367 6 жыл бұрын
It’s not working huhu help Shane!!!!
@robertomarra2431
@robertomarra2431 4 жыл бұрын
man... you're great! All your tutorial are amazing! thnx a lot
@ShanesCows
@ShanesCows 4 жыл бұрын
You're welcome!
@frodesellevoll
@frodesellevoll 4 жыл бұрын
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.
@ShanesCows
@ShanesCows 4 жыл бұрын
Have to use a 3rd party converter to get landscape
@georgiescicluna8405
@georgiescicluna8405 5 жыл бұрын
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.
@ShanesCows
@ShanesCows 5 жыл бұрын
It is an html typo. Most likely you forget to close a or
@SarahPoulin
@SarahPoulin 4 жыл бұрын
Is there any way, instead of filling data in the html template with what is coming directly from Powerapps, to instead fill it with the data from a Sharepoint List? Like have placeholders in the html template or something.
@SarahPoulin
@SarahPoulin 4 жыл бұрын
I FIGURED IT OUT!!! When you were showing how to get the expression for the concat stuff, that's when I figured out that I need to do. I had "Update file properties" because I was already generating a docx then a pdf for a Sharepoint List, so I hovered over one of my metadata thingies and it said "body('Get_item')?['ThisisMyColumn']" (ThisisMyColumn being one of the metadata columns in my Sharepoint List, and minus the quotations, obviously). Then, I followed your instructions for pasting the html into the concat expression for the File Content in Create file, and replaced the part that I wanted to have the Sharepoint List data with body('Get_item')?['ThisisMyColumn'] in the same way that you instructed, and BOOM, it showed up in my html. THANK YOU!!!
@ShanesCows
@ShanesCows 4 жыл бұрын
Glad you got it Sarah
@PolishTaekwondo
@PolishTaekwondo 5 жыл бұрын
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.
@ShanesCows
@ShanesCows 5 жыл бұрын
Should be possible. What have you tried?
@katherinewright4137
@katherinewright4137 4 жыл бұрын
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?
@ShanesCows
@ShanesCows 4 жыл бұрын
You need to send the data to flow and use the create item action. Should work fine
@barbloke1566
@barbloke1566 4 жыл бұрын
Great Job Shane!
@ShanesCows
@ShanesCows 4 жыл бұрын
Thanks
@teaners26
@teaners26 6 жыл бұрын
Have you made any videos on sending information from flow back to powerapps?
@ShanesCows
@ShanesCows 6 жыл бұрын
Yes. This one. 😀 PowerApps Flow Intro Upload an image to SharePoint using Flow kzbin.info/www/bejne/paeveqqkn5uEoLc
@techieeetechnologyleague
@techieeetechnologyleague 5 жыл бұрын
Hey Shane, I followed the steps up to creating the file in One drive, but when I click on the file in onedrive it downloads as a flat file with no extension. Is there some type of configuration I need to do to get it to open up immediately like in your video?
@ShanesCows
@ShanesCows 5 жыл бұрын
Maybe you didn’t set the file extension to .pdf? Should be be anything special.
@arrongreenhill2761
@arrongreenhill2761 6 жыл бұрын
Hey Shane, when I convert it to a PDF once I have data from power apps in it, the pdf displays a blank page. in the HTML it's viewable. Is this fixable or have you not came across it? Thank you
@ShanesCows
@ShanesCows 6 жыл бұрын
Is your code all html? Anything special? I would try making a simple Hello World html file and see if you can make it work first.
@aaronalbers7280
@aaronalbers7280 6 ай бұрын
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?
@ShanesCows
@ShanesCows 6 ай бұрын
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.
@aaronalbers7280
@aaronalbers7280 6 ай бұрын
@@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?
@aminahamilton1790
@aminahamilton1790 2 жыл бұрын
Hi Shane.. question for you. I have a Standard PDF form that my clients use to initiate requests. Currently they're digitally signing the form and sending a copy via email. Does powerapps allow users to digitally sign a PDF document? Thanks in advance!
@ShanesCows
@ShanesCows 2 жыл бұрын
Amina look at one of the premium connectors in Power Automate like Docusign or Adobe Sign. :) Should be just what you want.
@tonyy4471
@tonyy4471 4 жыл бұрын
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?
@ShanesCows
@ShanesCows 4 жыл бұрын
1 it will save to their OneDrive. 2 page breaks are possible but I haven’t covered it yet. Requires fun with Div tags.
PowerApps Google Maps API - Build your first App
29:44
Shane Young
Рет қаралды 72 М.
Do you love Blackpink?🖤🩷
00:23
Karina
Рет қаралды 23 МЛН
Чистка воды совком от денег
00:32
FD Vasya
Рет қаралды 4,9 МЛН
Creative Justice at the Checkout: Bananas and Eggs Showdown #shorts
00:18
Fabiosa Best Lifehacks
Рет қаралды 34 МЛН
Tuna 🍣 ​⁠@patrickzeinali ​⁠@ChefRush
00:48
albert_cancook
Рет қаралды 25 МЛН
Use the Power Automate v2 Trigger for Power Apps
19:09
Shane Young
Рет қаралды 46 М.
Create Dynamic PDFs with Tabular Data using Power Automate
16:41
Reza Dorrani
Рет қаралды 54 М.
Convert a Gallery into an HTML Email in Power Apps
11:45
Andrew Hess
Рет қаралды 7 М.
Power Apps Export to PDF
25:13
Reza Dorrani
Рет қаралды 151 М.
Docusign for Power Apps and Power Automate
28:31
Shane Young
Рет қаралды 6 М.
PowerApps - PDF function to Generate & Save PDF in OneDrive/SharePoint
15:09
PowerApps Multiple Data Sources
22:09
Shane Young
Рет қаралды 203 М.
Do you love Blackpink?🖤🩷
00:23
Karina
Рет қаралды 23 МЛН