Unanswered

Merge PDf files using power automate desktop

(0) Share

Report

Posted on by Th11

Hi, I am trying to merge the pdf files based on the file names using PAD. I am able to merge them if the names are similar. But in a folder, we have different kinds of filenames. I have no idea. kindly help.

Eg: abc.pdf

abc1.pdf

abc2.pdf

abc3.pdf

xyz.pdf

xyz1.pdf

sample.pdf

sample1.pdf

I need to merge the above files based on the filenames like

abc.pdf

xyz.pdf

sample.pdf

Thanks in Advance!

Categories:

Power Automate Desktop

I have the same question (1)

All responses (5)

Answers (0)

Agnius Bartninkas Most Valuable Professional on at

Like (0)

Report

The Merge PDF files action works the same way regardless of the names of the files. You just need to work on the way you pick those files, as you need a list of files to merge. So, you likely need to either manually build the list, or use Get files in folder.

How exactly are you doing it? Can you share some screenshots? Maybe we can then help you figure out what's wrong in your flow.

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

Was this reply helpful? Yes No
Th11 on at

Like (0)

Report

Hi @Agnius , Thank you for your response. I am using Get files in folder action and in advance section I am filtering like this. It is not merging based on the name condition. I want to merge it based on the file names like ABC.pdf, XYZ.pdf and sample.pdf. But its merging all the files as single pdf file (merged.pdf.). Not sure which part I am missing.

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

Like (0)

Report

The incorrect part is that you are getting all your files into a list without any filters, apart from the fact you only get .pdf files. And then you're using that list to merge the files without any pre-processing. So, clearly, it will merge all of the files you get in Get files in folder.

You either need to apply some file filters there (you can include several file names, separated by a comma), or you need to Create a new list and then use a For each loop on %Files% and only add the relevant files to this new list. And then use the new list in Merge PDF files.

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

Was this reply helpful? Yes No
Th11 on at

Like (0)

Report

Hi @Agnius , Thank you so much for your response. I am new to PAD. can you please send me the screenshot regarding what you have explained that would be super helpful. Thank you!

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

Like (0)

Report

Here you go:

Note the semicolon separating the different file names in the file filter. You can obviously change the names, and also use wildcards, such as * in the file filter.

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

Was this reply helpful? Yes No