Skip to main content

Microsoft Power Automate

Prerequisites

Use Case 1: Generate PDFs from Excel / SharePoint

Generate a PDF from Excel Online or SharePoint data and email it via Outlook.
Excel Online (new row) or SharePoint (new item) → HTTP action (PolyDoc API) → Send email (Outlook)

Create an automated cloud flow

Open Power Automate and click Create → Automated cloud flow. Name your flow (e.g. "Excel Row to PDF").

Screenshot placeholder: /img/guides/power-automate/power-automate-uc1-create-flow.png

Add the trigger

Add the trigger: Excel Online → When a row is added or SharePoint → When an item is created. Select the file location, table, and configure any filters. The trigger provides dynamic content fields for each column.

Screenshot placeholder: /img/guides/power-automate/power-automate-uc1-trigger.png

Add an HTTP action for PolyDoc

Add an HTTP action and configure:

  • URI: https://api.polydoc.tech/pdf/convert
  • Method: POST
  • Headers: Authorization: Bearer YOUR_API_KEY, X-Sandbox: true, and Content-Type: application/json (get your API key from the Dashboard)
  • Body: JSON mapping dynamic content fields from the trigger to your PolyDoc template.
Screenshot placeholder: /img/guides/power-automate/power-automate-uc1-http-action.png

Send the PDF by email

Add a Send an email (V2) action (Outlook). Map the recipient, subject, and add the PDF as an attachment:

  • Attachment Name: document.pdf
  • Attachment Content: select Body from the HTTP action output
Screenshot placeholder: /img/guides/power-automate/power-automate-uc1-send-email.png

Test the flow and turn it on

Click Test in the top-right, choose Manually, and add a test row to your Excel table or SharePoint list. Verify the PDF is generated and emailed, then turn the flow ON.

Screenshot placeholder: /img/guides/power-automate/power-automate-uc1-test-flow.png

Use Case 2: Microsoft Forms → PDF

Convert Microsoft Forms responses into PDFs and save or email them automatically.
Microsoft Forms (new response) → Get response details → HTTP (PolyDoc) → OneDrive / Outlook

Create a flow with Forms trigger

Create a new automated cloud flow with the trigger Microsoft Forms → When a new response is submitted. Select your form from the dropdown.

Screenshot placeholder: /img/guides/power-automate/power-automate-uc2-forms-trigger.png

Get response details

Add the Get response details action from the Microsoft Forms connector. This retrieves all form field values using the response ID from the trigger.

Screenshot placeholder: /img/guides/power-automate/power-automate-uc2-get-response.png

Add HTTP action calling PolyDoc

Add an HTTP action configured for the PolyDoc API. Set the URI, method, and headers as in Use Case 1. In the body, map form field values (available as dynamic content) to your PolyDoc template fields.

Screenshot placeholder: /img/guides/power-automate/power-automate-uc2-http-action.png

Save or send the PDF

Add a delivery action: OneDrive → Create file to save the PDF, or Outlook → Send an email (V2) to email it. Use the HTTP response body as the file content. Test and activate the flow.

Screenshot placeholder: /img/guides/power-automate/power-automate-uc2-deliver.png