Answered

How to PDF pages using Power Automate Desktop where some invoices are over two pages rather than the usual one page.

(0) Share

Report

Posted on by Nerfino80

Hi,

I am having an issue where I built a flow where it can split PDF document invoice into single pages based on heading. The issue I am facing is how do I do it where some invoices are over two pages.

So the heading will be on page 1 and the next heading is on page three. I need page 1 and 2 to be built into a single PDF document.

Invoice will be coming from different people so the heading will change but the variable will be passed from the cloud flow alongside the page number. Then PAD will loop and extract the pages by text reference.

I have attached my PAD flow with page number from Cloud Flow alongside two invoices. One invoice covering one page the other is over two pages then on the third page and forth page it covering the invoice on a single page for both three and four.

Categories:

Power Automate Desktop

I have the same question (0)

All responses (17)

Answers (1)

Sort by

Deenuji_Loganathan_ 6,250 Moderator on at

Like (0)

Report
Copy link

Link copied!

@Nerfino80
could you please explain with some screenshot or sample pdf document of your use case so that we can try and propose appropriate solution for you. Thanks.

Thanks,
Deenuji Loganathan 👩‍💻
Automation Evangelist 🤖
Follow me on LinkedIn 👥

-------------------------------------------------------------------------------------------------------------
If I've helped solve your query, kindly mark my response as the solution ✔ and give it a thumbs up!👍 Your feedback supports future seekers 🚀. If you'd like to appreciate me, please write a LinkedIn recommendation 🙏

Was this reply helpful? Yes No
VishnuReddy1997 2,656 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Hi @Nerfino80 ,

It that headings are same or any common points in PDF.
As mentioned @Deenuji ,Please share the screenshot or PDF File.

(Note:- if you got your solution you can mark as solution and gives kudos)

Thanks & Regards
Vishnu Reddy

Was this reply helpful? Yes No
Nerfino80 36 on at

Like (0)

Report
Copy link

Link copied!

I have updated with screenshot thank you for looking into this

Was this reply helpful? Yes No
Nerfino80 36 on at

Like (0)

Report
Copy link

Link copied!

Screenshot have been added thank you.

Was this reply helpful? Yes No
Deenuji_Loganathan_ 6,250 Moderator on at

Like (0)

Report
Copy link

Link copied!

@Nerfino80
I understand that the first invoice consists of one page containing the invoice information, while the second invoice spans two pages. Could you please clarify what exactly you're trying to achieve here? I'm not entirely clear on your objective. Could you elaborate a bit more?

Thanks,
Deenuji Loganathan 👩‍💻
Automation Evangelist 🤖
Follow me on LinkedIn 👥

-------------------------------------------------------------------------------------------------------------
If I've helped solve your query, kindly mark my response as the solution ✔ and give it a thumbs up!👍 Your feedback supports future seekers 🚀. If you'd like to appreciate me, please write a LinkedIn recommendation 🙏

Was this reply helpful? Yes No
Nerfino80 36 on at

Like (0)

Report
Copy link

Link copied!

What I am trying to do here is when the invoice comes into sharepoint cloud flow will pick that up and it a 25 page PDF documents with multiples invoice on one documents. I am trying to split this one documents into multiples documents based on the heading. I can get it to work when the heading and invoice on one page but across two pages is where I am struggling.

Was this reply helpful? Yes No
IWantToKnow 90 on at

Like (0)

Report
Copy link

Link copied!

Hi @Nerfino80 ,
When you say you were able to split the PDF into single files you meant that you did it with indicating the text to split to and from or simply split the file into single pages?

Was this reply helpful? Yes No
Nerfino80 36 on at

Like (1)

Report
Copy link

Link copied!

Yeah each invoice got a header starting with "Short" in a one documents over three pages and I managed to split this into 3 different PDF documents based on the header "Short" so I ended up with 3 invoice document from 1 document.

Just Headers spaced out over two pages is where I am struggling

Was this reply helpful? Yes No
Agnius Bartninkas Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

Split them into individual files per page, and build a Loop condition while 1=1 (infinite loop). Then use Get files in folder to pick up your files inside this loop. If %Files.Count% = 0, use Exit loop to stop looping.

Then if it's not equal to 0, continue the flow. Add a For each loop to iterate through the files. Use Extract text from PDF to get the text from the current item and store it in a variable. Continue looping until the header value changes. When it does, use Exit loop to exit the For each, and merge the files you've iterated through using Merge PDF files. Once done, delete the original files, and move the merged file elsewhere, so it is not picked up during the next iteration of the while loop.

It's an ugly workaround, but it can be made to work. We've done that for a client in the past.

Was this reply helpful? Yes No
Nerfino80 36 on at

Like (0)

Report
Copy link

Link copied!

Thank you for sharing this Agnius, I have attempted this are you able to share an image or build of how you done it so I can try replicate it please.

Was this reply helpful? Yes No