Great simple video Andrew. I've been doing this the old school way by populating Word templates with data, saving to Sharepoint, and then having to convert to PDF in my flows .. and this just blows it all away with either using Galleries, Containers, etc. Thanks again for showing this
The print screen was a great idea! I've been creating the entire document in power apps. The print screen saves a lot of time for complex forms. Great video!!
Thanks for the tutorial! If I want to create one-page PDFs soon, I'll give this a try. I can imagine using it very well for certificates of attendance or similar.
Hi Andrew, this is great and I have been following your content for some time. How can I pass a signature using the pen input in to the pdf without premium?
@@andrewhess123 Well my problem was to populate program file but due to limitation I wasn't able to so. Then I found a alternative where I used compose action created a html structure just like my program file and brought those inputs from my SharePoint list, used those inputs inside the HTML and then I used the HTML to text action and created text. I earlier tried your method of populating the word template but I couldn't able to due to that 20 input limitation. Again thank you because of you I got somewhere at least...
@@tylernot1 Awesome glad you got it working. My video next week goes over doing more than 20 inputs with the Power Apps V2. Also, it shows your question. Just have it waiting to release. The trick is to use JSON.
Hi Andrew, If we have checkbox input in screen 1, so How can we connect it screen 2. I tried but it is asking agin to check in screen 2 as well. pls suggest me
Hi Vivek, thanks for always watching! In Screen 1 when you check the checkbox set a variable like Set(varName,true) then on the 2nd checkbox change the Default to varName.
Thank you so much Andrew! Very helpful. Im curious if its possible to populate repeating controls in a word template without using the premium action "populate a microsoft word template". If info on this would be very much appreciated. Thanks again!
mdizzle! Thanks for watching again. as far as I know this is good for 1 document but.. this is in preview. Also there are tricks to printing more than one pdf and then combining them later.
Thanks Andrew! I ended up using a flow to populate a PDF via html to pdf conversion. The formatting isn't great on the PDF but it works as a nice invoice receipt that's automated. For multi page docs I'm using the populate a word doc flow I learned from you. This works well for multipage docs and all users need to do it export the word to pdf manually once its ready. Its still a huge time save over having to manually edit these documents. We have a good deal of paper work so these are all helpful. @@andrewhess123
Hi Andrew, as always, just another awesome video. Very simple and great information, I am thinking creating with repeating table, not sure if this will work or not, but will let you know. Appreciate your knowledge sharing!! 👍👍👍
Thank you for this, my is working but for some reason is not expanding the full container. I am utilizing Microsoft List, I then created the Power Apps with that. I followed your video but is not showing the full information. Do you know where in the formula I would put expand container? Thanks.
Hi @B_D60, so the PDF function is a preview experimental feature so things may change, but if you are creating a PDF Template you could try putting in an HTML text to align it correctly. Using HTML width and height commands or padding could make a difference. Another option is to work with different types of containers using either Horizontal or Vertical Container to align it correctly as you'd like. It definitely depends on how you are trying to display your data and what data you have.
Hi CHAMONIX, should be possible. I can write down this idea for a video. You would create a collection based on columns that are selected then create an html table based on that collection, then print to PDF.
@@CHAMONIX552 You can print certain Containers I believe too, not just the entire screen. And then inside that container you would have an HTML table with the selected columns.
Great simple video Andrew. I've been doing this the old school way by populating Word templates with data, saving to Sharepoint, and then having to convert to PDF in my flows .. and this just blows it all away with either using Galleries, Containers, etc. Thanks again for showing this
Awesome B, glad it's simple and working well this way. Yeah the old school way used to be fun 😊
The print screen was a great idea! I've been creating the entire document in power apps. The print screen saves a lot of time for complex forms. Great video!!
Wooo! Nice yeah! Thanks Stefano!
Thanks for the tutorial! If I want to create one-page PDFs soon, I'll give this a try. I can imagine using it very well for certificates of attendance or similar.
Thanks for watching Synthven!
Hi Andrew, this is great and I have been following your content for some time. How can I pass a signature using the pen input in to the pdf without premium?
Hi Stewart!
That's a good one and should be totally possible by using HTML. Will write that one down.
Hey Andrew can you do for more complex pdf like which has lot ofvalues in some form or anything?
I can write this down to do.
Hi All, I know I'm getting a ton of questions for videos and new content to create. Thank you for sharing your ideas! I I am working on it though!
Hello can you make a tutorial on how can we get more than 20 inputs PowerApps(V2) trigger pls I need a solution
That's a good idea. Thanks
@@andrewhess123 Omg wow I didn't expected a reply thanks and I will be waiting for the vod lol
@@tylernot1 I think its a great idea for a video, I can't promise next week. I already have a video ready for then, but hopefully soon.
@@andrewhess123 Well my problem was to populate program file but due to limitation I wasn't able to so. Then I found a alternative where I used compose action created a html structure just like my program file and brought those inputs from my SharePoint list, used those inputs inside the HTML and then I used the HTML to text action and created text. I earlier tried your method of populating the word template but I couldn't able to due to that 20 input limitation. Again thank you because of you I got somewhere at least...
@@tylernot1 Awesome glad you got it working. My video next week goes over doing more than 20 inputs with the Power Apps V2. Also, it shows your question. Just have it waiting to release. The trick is to use JSON.
Hi Andrew, If we have checkbox input in screen 1, so How can we connect it screen 2. I tried but it is asking agin to check in screen 2 as well. pls suggest me
Hi Vivek, thanks for always watching! In Screen 1 when you check the checkbox set a variable like Set(varName,true) then on the 2nd checkbox change the Default to varName.
Bless you!!!! Thank you so much for this!!! You are a rock star!!!
Thank you! You too! 😄
Hi @andrewhess123, is it possible to create PDF documents of more than one page with this process?
I don't think there is an easy out-of-the-box way to do this yet. The PDF function is experimental maybe Microsoft will make it easier in the future.
I saw something about {ExpandContainers:true} but I haven't tried it exactly yet.
Thank you so much Andrew! Very helpful. Im curious if its possible to populate repeating controls in a word template without using the premium action "populate a microsoft word template". If info on this would be very much appreciated. Thanks again!
Hi Gerardo, in order to do this you can do an HTML table and use the PDF function.
How do u loop it through many records I have transcripts I need to convert to pdf
Will this work for multipage documents or should I stick with word templates and content types for that?
mdizzle! Thanks for watching again. as far as I know this is good for 1 document but.. this is in preview. Also there are tricks to printing more than one pdf and then combining them later.
Thanks Andrew! I ended up using a flow to populate a PDF via html to pdf conversion. The formatting isn't great on the PDF but it works as a nice invoice receipt that's automated. For multi page docs I'm using the populate a word doc flow I learned from you. This works well for multipage docs and all users need to do it export the word to pdf manually once its ready. Its still a huge time save over having to manually edit these documents. We have a good deal of paper work so these are all helpful. @@andrewhess123
Hi Andrew, as always, just another awesome video. Very simple and great information, I am thinking creating with repeating table, not sure if this will work or not, but will let you know. Appreciate your knowledge sharing!! 👍👍👍
Hey Imran! It will work, especially if you use a gallery and convert it to a HTML table.
@@andrewhess123 , thank you for the idea, I will look into this and will let you know. Again, appreciate your kind assistance and knowledge sharing 😊
Of course Imran! Thanks for watching!@@imran002ali
Hi Andrew, how to generate multiple page PDF documents with all types of controls in the different containers.
add all the containers in one main container and print the main one
Thank you for this, my is working but for some reason is not expanding the full container. I am utilizing Microsoft List, I then created the Power Apps with that. I followed your video but is not showing the full information. Do you know where in the formula I would put expand container? Thanks.
Hi @B_D60, so the PDF function is a preview experimental feature so things may change, but if you are creating a PDF Template you could try putting in an HTML text to align it correctly. Using HTML width and height commands or padding could make a difference.
Another option is to work with different types of containers using either Horizontal or Vertical Container to align it correctly as you'd like.
It definitely depends on how you are trying to display your data and what data you have.
@@andrewhess123 I will try that. Thank you!
Thanks for the video. Is it possible to pull data from selected columns of the record (SharePoint list item) to print to the PDF file?
Hi CHAMONIX, should be possible. I can write down this idea for a video. You would create a collection based on columns that are selected then create an html table based on that collection, then print to PDF.
@@andrewhess123 Thanks. So the PDF function just does screen print, I need to get the desired output ready first.
@@CHAMONIX552 You can print certain Containers I believe too, not just the entire screen. And then inside that container you would have an HTML table with the selected columns.
@@andrewhess123 Thanks, not familiar with using container. Let me do some research
@@andrewhess123 Can I apply some logic to the container so some columns wont show if condition not met?