web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / Html format for with h...
Power Automate
Unanswered

Html format for with header in all pages and export to pdf

(0) ShareShare
ReportReport
Posted on by

Hi All ,

 

I need to generate pdf which has constant header which has to be generated in all pages.

And i need to generate the table of 1st value filter and calculate sum of quantity column particulary below that and then I need to generate a table of 2nd value filter and generate sum and this process goes on for all the valuse of of sheet. And If that is the 2nd page of pdf i should have heading which is there in 1st page .How can i achieve this.

 

Here is the attachement related to that with dummy data

I have the same question (0)
  • Nived_Nambiar Profile Picture
    18,138 Super User 2026 Season 1 on at

    Hi @Ramya03081 

     

    Could you give some information on where the table data is coming from ?

     

    Thanks & Regards,

    Nived N 🚀

    LinkedIn: Nived N's LinkedIn
    YouTube: Nived N's YouTube Channel

    🔍 Found my answer helpful? Please consider marking it as the solution!
    Your appreciation keeps me motivated. Thank you! 🙌

  • Ramya0308 Profile Picture
    16 on at

    Its from Sharepoint list

  • Nived_Nambiar Profile Picture
    18,138 Super User 2026 Season 1 on at

    So i would suggest cloud flow design, where you should use get items to get all items from sharepont list and filter it by values and then place it as table in each excel and then convert it to pdf and finally merges to single pdf.

     

    Let me know if you need additional help or information on this 🙂

     

  • Agnius Bartninkas Profile Picture
    Most Valuable Professional on at

    The easiest way to do this in Power Automate Desktop would be to create an Excel template file that your flow would fill in with values automatically using the Excel actions, and then use VBscript/PowerShell or a macro to convert the Excel file into a PDF file. This is quite simple to implement.

     

    This would work if you do not need a very dynamic number of pages. If you know that you will always need either 1 or 2 pages, you can build 2 templates and use the one you need, depending on how many items you need to fit into the file. If you need it more dynamically, then I would suggest having one template for a single-page PDF file, but then making several PDF files per case and merging them when done.

     

    Alternatively, you could also build an HTML file and then use scripting in combination with a browser to "print" it to PDF. That is more complex to implement, though.

    -------------------------------------------------------------------------
    If I have answered your question, please mark it as the preferred solution. If you like my response, please give it a Thumbs Up.

    I also provide paid consultancy and development services using Power Automate. If you're interested, DM me and we can discuss it.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Kudos to our 2025 Community Spotlight Honorees

Expanding mentorship, skilling, and AI innovation

Congratulations to the July Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Automate

#1
David_MA Profile Picture

David_MA 253 Super User 2026 Season 2

#2
11manish Profile Picture

11manish 172 Super User 2026 Season 2

#3
trice602 Profile Picture

trice602 134 Super User 2026 Season 2

Last 30 days Overall leaderboard