Populate PDF Documents No Premium Licenses with Power Apps and Power Automate

แชร์
ฝัง
  • เผยแพร่เมื่อ 14 ม.ค. 2025

ความคิดเห็น • 51

  • @btoz6237
    @btoz6237 2 หลายเดือนก่อน +2

    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

    • @andrewhess123
      @andrewhess123  2 หลายเดือนก่อน

      Awesome B, glad it's simple and working well this way. Yeah the old school way used to be fun 😊

  • @stefano94103
    @stefano94103 10 หลายเดือนก่อน +1

    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!!

    • @andrewhess123
      @andrewhess123  10 หลายเดือนก่อน

      Wooo! Nice yeah! Thanks Stefano!

  • @stewartmcgovern2k10
    @stewartmcgovern2k10 10 หลายเดือนก่อน +2

    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
      @andrewhess123  10 หลายเดือนก่อน

      Hi Stewart!
      That's a good one and should be totally possible by using HTML. Will write that one down.

  • @Synthven
    @Synthven 10 หลายเดือนก่อน +2

    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.

    • @andrewhess123
      @andrewhess123  10 หลายเดือนก่อน +1

      Thanks for watching Synthven!

  • @andrewhess123
    @andrewhess123  10 หลายเดือนก่อน

    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!

  • @HOWTOTALLYCOOLdotcom
    @HOWTOTALLYCOOLdotcom 2 หลายเดือนก่อน +1

    Bless you!!!! Thank you so much for this!!! You are a rock star!!!

    • @andrewhess123
      @andrewhess123  2 หลายเดือนก่อน +1

      Thank you! You too! 😄

  • @muzammil2927
    @muzammil2927 4 หลายเดือนก่อน +2

    Hey Andrew can you do for more complex pdf like which has lot ofvalues in some form or anything?

    • @andrewhess123
      @andrewhess123  4 หลายเดือนก่อน

      I can write this down to do.

  • @gerardovaldez4103
    @gerardovaldez4103 9 หลายเดือนก่อน +1

    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!

    • @andrewhess123
      @andrewhess123  8 หลายเดือนก่อน

      Hi Gerardo, in order to do this you can do an HTML table and use the PDF function.

  • @tylernot1
    @tylernot1 2 หลายเดือนก่อน +2

    Hello can you make a tutorial on how can we get more than 20 inputs PowerApps(V2) trigger pls I need a solution

    • @andrewhess123
      @andrewhess123  2 หลายเดือนก่อน

      That's a good idea. Thanks

    • @tylernot1
      @tylernot1 2 หลายเดือนก่อน +1

      @@andrewhess123 Omg wow I didn't expected a reply thanks and I will be waiting for the vod lol

    • @andrewhess123
      @andrewhess123  2 หลายเดือนก่อน +1

      @@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.

    • @tylernot1
      @tylernot1 2 หลายเดือนก่อน +1

      @@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...

    • @andrewhess123
      @andrewhess123  2 หลายเดือนก่อน +1

      @@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.

  • @imran002ali
    @imran002ali 10 หลายเดือนก่อน +1

    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!! 👍👍👍

    • @andrewhess123
      @andrewhess123  10 หลายเดือนก่อน +1

      Hey Imran! It will work, especially if you use a gallery and convert it to a HTML table.

    • @imran002ali
      @imran002ali 10 หลายเดือนก่อน +1

      @@andrewhess123 , thank you for the idea, I will look into this and will let you know. Again, appreciate your kind assistance and knowledge sharing 😊

    • @andrewhess123
      @andrewhess123  10 หลายเดือนก่อน

      Of course Imran! Thanks for watching!@@imran002ali

  • @MichaelDeBlasis1369
    @MichaelDeBlasis1369 7 หลายเดือนก่อน +1

    Will this work for multipage documents or should I stick with word templates and content types for that?

    • @andrewhess123
      @andrewhess123  7 หลายเดือนก่อน +1

      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.

    • @MichaelDeBlasis1369
      @MichaelDeBlasis1369 7 หลายเดือนก่อน

      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

  • @vivek8237
    @vivek8237 7 หลายเดือนก่อน +1

    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

    • @andrewhess123
      @andrewhess123  7 หลายเดือนก่อน

      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.

  • @luisenriquebaldovinomartin8689
    @luisenriquebaldovinomartin8689 10 หลายเดือนก่อน +1

    Hi @andrewhess123, is it possible to create PDF documents of more than one page with this process?

    • @andrewhess123
      @andrewhess123  10 หลายเดือนก่อน +1

      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.

    • @andrewhess123
      @andrewhess123  10 หลายเดือนก่อน +1

      I saw something about {ExpandContainers:true} but I haven't tried it exactly yet.

  • @SJMiller-t3d
    @SJMiller-t3d 6 หลายเดือนก่อน

    How do u loop it through many records I have transcripts I need to convert to pdf

  • @sustainbhoomi
    @sustainbhoomi 6 หลายเดือนก่อน

    Hi Andrew, how to generate multiple page PDF documents with all types of controls in the different containers.

    • @mohammedaldalaein7261
      @mohammedaldalaein7261 5 หลายเดือนก่อน +1

      add all the containers in one main container and print the main one

  • @B_D60
    @B_D60 9 หลายเดือนก่อน

    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.

    • @andrewhess123
      @andrewhess123  9 หลายเดือนก่อน

      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.

    • @B_D60
      @B_D60 9 หลายเดือนก่อน

      @@andrewhess123 I will try that. Thank you!

  • @CHAMONIX552
    @CHAMONIX552 4 หลายเดือนก่อน +1

    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?

    • @andrewhess123
      @andrewhess123  4 หลายเดือนก่อน

      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
      @CHAMONIX552 4 หลายเดือนก่อน +1

      @@andrewhess123 Thanks. So the PDF function just does screen print, I need to get the desired output ready first.

    • @andrewhess123
      @andrewhess123  4 หลายเดือนก่อน

      @@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.

    • @CHAMONIX552
      @CHAMONIX552 4 หลายเดือนก่อน

      @@andrewhess123 Thanks, not familiar with using container. Let me do some research

    • @CHAMONIX552
      @CHAMONIX552 4 หลายเดือนก่อน +1

      @@andrewhess123 Can I apply some logic to the container so some columns wont show if condition not met?