Merge PDF Files in Power Automate

(0) Share

Report

Posted on by CU17060151-0

I need your help.

I’m currently working on a Power Automate flow to export around 10 Power BI reports as PDF files, consolidate them into a single PDF, and email it to the target users. So far, I’ve been able to successfully export the PDFs and send them via email — but each report is sent as a separate attachment.

The main issue is that I’m unable to merge the individual PDFs into a single consolidated file within Power Automate. I’ve looked for a free built-in action or service to handle the merging, but haven’t found one available.

Can anyone advise on how to achieve this within Power Automate? Thank you in advance for your help.

Thank you,
Keela.

Categories:

Building flows

I have the same question (0)

All responses (2)

Answers (0)

Suggested answer

Riyaz_riz11 3,874 Super User 2025 Season 2 on at

Like (0)

Report
Hi,

Option 1: Use Encodian PDF Actions (Free for limited use)

Encodian offers a Power Automate connector with PDF manipulation capabilities, including merging PDFs.

Steps:

Sign up for Encodian (free tier available with limited runs).

Website: https://www.encodian.com/

Register and get API key if needed.

Install Encodian Connector in Power Automate:

Add a new step → Search for "Encodian"

Choose “Merge PDF” action

Use “Merge PDF” action:

Add all your exported Power BI PDF files (content or base64) into the merge action

Send the merged PDF via Email

Attach the merged file in the "Send an email" step.

Example Flow Outline:

For Each Power BI report: Export to PDF Store PDF in array Encodian - Merge PDF (input: array of PDFs) Send Email with merged PDF as attachment

Option 2: Use Plumsail Documents (Paid, with free trial)

Plumsail offers PDF processing, including merging.

Steps:

Use "Plumsail Documents - Merge PDF" action

Upload or provide PDF content as input

Note: Both Encodian and Plumsail are premium connectors, but offer free trials or limited free use.

Option 3: Use Local Script via Power Automate Desktop (PAD)

If you're okay using Power Automate Desktop, you can:

Export all PDFs using Power Automate Cloud to a shared folder (OneDrive, SharePoint, etc.)

Use Power Automate Desktop to:

Monitor folder

Use “Merge PDF files” action in PAD (available natively)

Send merged PDF via Outlook or cloud trigger

PAD Steps:

Launch PAD

Use “Get files in folder”

Use “Merge PDF files” (native action)

Use “Send email” (or return merged file to cloud)

Option 4: Use Azure Function / PowerShell / Logic App

If you're technical, you can:

Host a simple Azure Function or PowerShell script (with iTextSharp, PdfSharp, or PowerShell PdfDocument)

Accept a list of PDFs via HTTP POST

Return a merged PDF

Call from Power Automate via HTTP action

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

1 people found this reply helpful.

Was this reply helpful? Yes No
takolota1 4,974 Moderator on at

Like (0)

Report

If you don’t want to use a 3rd party service & you have access to Azure then you can use this template that includes merge & split PDF functions:

https://community.powerplatform.com/galleries/gallery-posts/?postid=a5255ced-dc08-f011-bae3-6045bdf03fcb

Was this reply helpful? Yes No