How to Merge Documents to PDF with PDF.co Connector for Power Automate Cloud
Combine documents into one PDF with PDF.co and Power Automate, then save the result in SharePoint.
Choose the action based on your inputs:
- Merge PDF: Combine PDF files.
- Merge PDF (Advanced): Convert and combine supported documents and images into one PDF.
This walkthrough uses Merge PDF (Advanced) to place a PDF cover before a DOCX report.
Step 1: Add the Official Connector
Create an Instant cloud flow with Manually trigger a flow.
Add the official PDFco connector, select Merge PDF (Advanced), and connect using your PDF.co API key.
PDFco is a Premium connector in Power Automate, so confirm that your account and environment permit its use.
The advanced merge action supports PDF, DOC, DOCX, XLS, XLSX, RTF, TXT, PNG, JPG, and ZIP inputs. Start with two small, unencrypted documents for this example.
Step 2: Prepare the Source URLs
Provide download URLs that PDF.co can retrieve.
The URL field expects a comma-separated string, not a JSON array:
YOUR_COVER_PDF_URL,YOUR_REPORT_DOCX_URLReplace both placeholders with your actual download URLs. Put the cover first and the report second to request that order in the merged PDF. Do not surround the list with quotes or square brackets.
A SharePoint or OneDrive preview page that requires your browser login may not be accessible to PDF.co. Follow the Power Automate file-source guide using a method permitted by your organization.
Do not change a confidential file’s sharing permissions merely to obtain a public link.
Step 3: Run the Merge
For this small test:
- Set Async to No.
- Leave Profiles blank.
- Save and test the flow.
Confirm that the action completes successfully and Error is false before using its URL output.
For a longer merge, enable Async and retain Job Id. Use Background Jobs Check with that ID:
- working: Wait briefly and check again.
- success: Use the completed result URL.
- failed or aborted: Stop and review the response.
An accepted background job is not yet a completed PDF.
Step 4: Save the PDF in SharePoint
Add an HTTP action:
- Method:
GET. - URI: Map the completed merge’s URL output.
Then add SharePoint’s Create file action:
- Site Address: Select the destination site.
- Folder Path: Select the destination folder.
- File Name: Enter
document-packet.pdf. - File Content: Map the HTTP action’s Body output.
The URL identifies the download location; the HTTP Body supplies the file content. Save the PDF before its temporary link expires.
For repeated runs, use a unique filename. If you send a notification, link to the stored SharePoint copy.
Step 5: Check Order and Conversion
Open the saved PDF and confirm that:
- The cover appears before the report.
- Every expected document and page is present.
- Converted text, fonts, page breaks, and tables are readable.
If your flow builds the input list dynamically, check the final comma-separated URL list before submitting it. Its order should match the intended document sequence.
Related Tutorials
