How to Create a Dynamic PDF Report in Power Automate Without Premium

Need to generate PDF reports from your flows but do not want to pay for a premium connector? Here is the trick using Word Online and OneDrive — both included in your Microsoft 365 license.

The Setup

Step 1: Create a Word Template

1. Open Word and create your report layout
2. Go to Developer tab > Plain Text Content Control
3. Add content controls where you want dynamic data
4. Name each control in Properties (e.g., CustomerName, OrderTotal)
5. Save the template to OneDrive or SharePoint

Step 2: Build the Flow

1. Add the Word Online (Business) action: Populate a Microsoft Word template
2. Select your template file
3. Fill in each field with dynamic content from your trigger
4. Add Convert Word Document to PDF (OneDrive action, not premium)
5. Use the PDF output however you need — email, save, etc.

Example: Invoice Generator

Trigger: When a SharePoint item is created in "Orders"

Actions:

1. Populate Word template with order details
2. Convert to PDF
3. Send email with PDF attachment
4. Create file in SharePoint document library

Handling Tables in the Template

For repeating rows (like line items), use the Word repeating section content control:

1. Insert a table in your Word template
2. Select the entire table
3. Add a Repeating Section Content Control
4. In Power Automate, the repeating section appears as an array field

Limitations

• Maximum file size: 50MB
• Complex formatting may shift slightly
• No password protection on the generated PDF

Pro Tip

Create multiple templates for different report types and use a Switch action to select the right one based on report type. Store templates in a dedicated SharePoint library for easy management.

---

This method works with Microsoft 365 Business Basic and above — no Power Automate Premium required.