Generate Personalised Invitations and Merge Them Into One PDF in Power Automate: A 7-Step Dropbox Workflow
· 24 min read
The painful part of bulk mailouts is not writing the letter, it is stitching the personalised copies together so finance, HR, or operations get one clean PDF instead of fifty attachments. This walkthrough builds the exact pattern in Power Automate with PDF4me Generate Documents (Multiple), Merge multiple PDF files, Dropbox, and a single Apply to each loop. Seven flow actions. One DOCX template. A JSON array of recipients. Out the other end falls one consolidated PDF, one page per recipient, named and uploaded back to Dropbox automatically.
The flow at a glance
1. Manual trigger
Manually trigger a flow. Swap in any business trigger later (HTTP, SharePoint, schedule).
2. Get file content (path)
Dropbox path /blog data/merge blog template/template.docx, Infer Content Type Yes.
3. Generate Documents (Multiple)
PDF4me action. Template DOCX plus JSON array of recipients. Output Type PDF. Returns body/outputDocuments.
4. Initialize variable
Name mergefiles, Type Array. Buffer for the per-recipient PDF binaries.
5. Apply to each
Loop body/outputDocuments. Inside, Append to array variable with base64ToBinary on streamFile.
6. Merge multiple PDFs
PDF4me action. Body/docContent mergefiles, Output File Name Test.pdf. One combined PDF out.
7. Create file
Dropbox /blog data/merge blog template/output, File Name Merged_files.pdf.