Power Automate Desktop - PDF Merge Functionality - Need logic to merge PDF

(0) Share

Report

Posted on by LabheshPower

Hello Team,

I need your help with a logic to merge muliple PDF files based on a condition and below is the scenario.

I have a list of PDF files each 1 page report, a Total of 200 PDF files in a single Folder.

There are few PDF which report content is extended to next file or next file, which means that all PDF are not for single report. There are scenarios where merging 2 or 3 PDF together will make a single client file. And that is where I need help with logic to apply.

These are PDF files

In Power Automate Desktop, I need a logic by which I should be able to Merge

1) File 5 and 6 PDF

2) File 9, 10 and 11 PDF

Currently I am using Files in Folder loop, and able to navigate to each file 1 by 1, but I am unable to find a logic by where In that file folder loop, I can merge current and next file as well.

Power automate provide a feature to merge 2 files, but how to implement that logic is a key?

Kindly help, if you can.

Categories:

Power Automate Desktop

I have the same question (0)

All responses (4)

Answers (2)

Sort by

Verified answer

fraenK 2,125 on at

Like
a
(1)

Report
Copy link

Link copied!

So the condition is "no footer" in the filename?
Then you just check in the loop if the next filename(s) in the list contain the text until there isn't.
Use the resulting list as an input for merge pdf.
Set you list counter variable to the next not used PDF file in the main list.

Was this reply helpful? Yes No
Verified answer

LabheshPower 19 on at

Like
a
(0)

Report
Copy link

Link copied!

let me give more info.

Was this reply helpful? Yes No
vedkumar 6 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi ,

while using fix file name in merge pdf files, path like below:
%['D:\\Bank Mail\\ENBD\\15 Sep 2021\\ENBDLA21007137\\ENBDLA2100713781631621881127960COVER_LETTER_NEGO.pdf', 'D:\\Bank Mail\\ENBD\\15 Sep 2021\\ENBDLA21007137\\ENBDLA2100713781631621881229842COVER_LETTER_NEGO_COPY.pdf']%

"\\" is there in path

But when i am using variable , it has only "\". if i store the path in variable , it does not work.

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Hello @vedkumar,

I have tried below sample flow, and it runs without any problems.
Could you show us the details of your issue?

SET SourceFiles TO ['C:\\Users\\User01\\Documents\\PDF Document 01.pdf', 'C:\\Users\\User01\\Documents\\PDF Document 02.pdf'] SET MergedFile TO $'''C:\\Users\\User01\\Documents\\PDF Document Output.pdf''' Pdf.MergeFiles PDFFiles: SourceFiles MergedPDFPath: MergedFile IfFileExists: Pdf.IfFileExists.Overwrite PasswordDelimiter: $''',''' MergedPDF=> MergedPDF

Was this reply helpful? Yes No