Power Automate - Open PDF and move last page to front

Documents
1

I am trying to create a Power Automate flow that will open a PDF, move the last page to the front, then save and close. The trigger is moving the PDF to a sharepoint folder. I've tried but am struggling with success. Any ideas? Thanks!

2

Hi @dwells1,

You can use this scenario:

  1. Let's say I have a PDF file with 4 pages and want to move page 4 before page1;

  2. This is my flow. I'm using 2 Plumsail actions there: Split PDF and Merge PDF. I separate first 3 pages and the page 4, then combine the first 3 pages to get a single file and finally create a new PDF with the page 4 in the beginning of the result PDF.

image
image831×1710 86 KB

Please give it a try.

Best regards,
Petr
Plumsail team

3

Hi Petr,

The PDFs will have a different number of pages each time, so that would need to be dynamic. Can I set that up?

Thanks

4

Hi @dwells1,

Yes, it's possible

  1. You need to count the number of pages in the source PDF. Add Compose action and this expression.

image

sub(length(split(replace(base64ToString(outputs('Get_file_content')?['body']['$content']), 'Type/Pages', ''), 'Type/Page')),1)
  1. Add an integer variable to get the number of pages without the last page.

image

  1. Finally, replace all static page number values in the Plumsaill actions.

This is how the entire flow looks like

image
image884×2351 112 KB

Best regards,
Petr
Plumsail team

5

Hi Petr,

Which action is the last Plumsail action before the Apply to Each? The "Create a pdf file with all pages without the last one"? When I add a "Merge PDF" the available field is different. It says "Content Item - 1", not "Content". If I enter Result files item, it automatically puts that in an "Apply to each".

Imgur

6

Hi @dwells1,

It is Merge PDF action, click on the button, remove all brackets and insert dynamic content from Get all pages without the last one

image
image783×450 97.8 KB

Best regards,
Petr
Plumsail team

7

Got it.

In the Apply to each output, which content do I choose? One of the circled?

image
image1029×607 28.9 KB

Then in the "Merge PDF with all pages with the last one", do I choose "Result files item" from "Get the last page" or "Get all pages without the last one"?

image
image919×480 26.5 KB

This keeps adding another apply to each. I hate to be so needy, but can you show which dynamic content exactly is needed for all fields in the Apply to each?

image

Thanks!

8

Hi @dwells1,

The logic is that I want to merge the last page and all the pages without the last one.

The apply to each section is added automatically when I select the Merge PDF action to merge the last page and the rest of the document. Please check out the attached video.

Best regards,
Petr
Plumsail team

11

I figured it out. Success!! Thank you so much for the help!!

1 Like