Skip to content
Simple Smooth Safe
Insight · How-to

How to generate a PDF from Dataverse or Power Apps: 6 methods and where each breaks

Six ways to turn a Dataverse record into a PDF, each with its steps, its licence and the documented limit where it stops working.

To generate a PDF from Dataverse or Power Apps, match the method to the job. Use PDF() or Print() for a quick capture of a canvas screen, Export to PDF for Dynamics 365 Sales records, Power Automate for low-volume flows, paginated reports for long print-exact reports, and a document engine for high-volume branded documents that change often.

Disclosure. We build SSS DocGen, one of the options in method 6; Simple Smooth Safe sells products and consultancy on Dataverse. Every Microsoft fact below links to the page we read it on, checked on 25 September 2026.

Choosing between add-ins? This page is organised by method, not vendor. For vendors, read Dynamics 365 document generation tools compared.

The six methods at a glance

“Breaks when” is the first documented limit most teams hit; each section lists the rest.

MethodWhere it runsLicence neededGood forBreaks when
1. Canvas PDF() functionExperimentalOn the user’s device, inside the canvas appA Power Apps licence that covers Dataverse, such as Power Apps PremiumCapturing a form or inspection screen and emailing itYou need it in production, nested galleries, charts or large files on mobile
2. Canvas Print() and the browser dialogThe browser’s print dialog on the user’s machineSame as the canvas app; no extra licenceA one-page printout or “Save as PDF” by a personThe content runs past one page, or users are on mobile
3. Word template, then Export to PDFDynamics 365 SalesInside the Dynamics 365 app, on Microsoft’s serversCustomer engagement apps; Export to PDF is documented for SalesOne quote, order or invoice at a time, on demandMore than 100 related rows, conditional sections, custom fonts or batches
4. Power Automate: Populate a Word template, convert to PDFA cloud flow, with templates in OneDrive or SharePointPremium connector: Power Automate Premium or ProcessAutomatic PDFs on a trigger, at modest volumeFiles over 10 MB, conversions over 2 minutes, MFA conditional access, labelled files
5. Power BI paginated report exported to PDFThe Power BI service; API export needs capacityPro or PPU to publish; Premium, Embedded or Fabric capacity for API exportLong, print-exact reports and statementsYou try bulk export on PPU (one per five minutes) or exports run past 60 minutes
6. Document-generation add-in or engineVendor cloud or your own Azure, depending on the productThe vendor’s licence, on top of your Microsoft licencesBranded documents at volume that change several times a yearThe document is simple enough that the licence is not worth it

1. How do you generate a PDF in a Power Apps canvas app?

The canvas PDF() function exports a screen, or part of one, to a PDF object (PDF function, Microsoft Learn).

  1. In Power Apps Studio, open Settings > Upcoming features > Experimental and turn on PDF function. It is off by default (Work with the PDF function).
  2. Put the document’s content inside a container or vertical gallery.
  3. In a button’s OnSelect, call something like Set(myPDF, PDF(Container1, {Size: "A4", ExpandContainers: true})). ExpandContainers prints the full content of scrolling containers and galleries.
  4. Show the result in the PDF viewer control, attach it to an Outlook email, or pass it to a flow (PowerApps (V2) trigger with a File input) that saves it.

Licence. No separate price, but the app needs a licence that covers Dataverse. Power Apps Premium is listed at $20 per user per month, paid yearly, with Dataverse entitlements (Power Apps pricing). Microsoft 365 use rights do not cover standalone custom apps on Dataverse; Dynamics 365 licences include Power Apps rights only in the context of the licensed Dynamics 365 app (licensing overview).

Where it breaks (all from the PDF function reference):

Yes, for one page. The canvas Print() function opens the current screen in the browser’s print dialog, where the user can save it as a PDF (Print function, Microsoft Learn).

  1. Add a screen with New Screen > Portrait print (or size one to 794 × 1123 for A4) and lay out the record.
  2. Add a button with Print() in OnSelect. Set its Visible property to Not Screen1.Printing so the button does not appear in the output.
  3. The user chooses Save as PDF as the printer in the browser dialog.

Licence. Nothing beyond the licence the canvas app already needs (see method 1).

Where it breaks (from the Print function reference):

Print() is canvas-only. For Dynamics 365 Sales records, Microsoft’s printing guidance is to export to PDF (Print quote, invoice, or other records). That is method 3.

3. How do you create a PDF from a Dynamics 365 record?

Dynamics 365 Sales has a built-in Export to PDF command. It fills one of your Word templates with the record’s data and returns a read-only PDF (Export sales records to PDF).

  1. An administrator turns it on. In Sales Hub, go to App Settings > Productivity tools > Convert to PDF and select the tables (Enable PDF generation).
  2. In the Power Platform admin center, open the environment’s Settings > Templates > Document templates > New > Download Word Template, and pick the table and relationships (Use Word templates).
  3. In Word, use Developer > XML Mapping Pane to insert fields, set the related-records table row to Repeating, and upload the template.
  4. A user opens the record, selects Export to PDF, picks the template, and chooses Download, Email, or Save to SharePoint (or Save to Dynamics, which stores it as a note).

Licence. Word templates are a feature of the customer engagement apps (Use Word templates). Export to PDF is documented for the Sales Hub and Sales Professional apps, and Microsoft points to the Sales licensing guide if it is missing (Export sales records to PDF).

Where it breaks. The Word template limits apply first (Use Word templates):

The PDF step adds its own limits (Export sales records to PDF):

More detail and workarounds: Dynamics 365 Word template limitations.

4. How do you generate a PDF from Dataverse with Power Automate?

Use the Word Online (Business) connector’s Populate a Microsoft Word template action, then convert the result (Word Online (Business) connector).

  1. Build the template in desktop Word with titled content controls (plain text, image, repeating section and others) and save it to OneDrive for Business or SharePoint.
  2. Trigger the flow from a row change or an app, read the row and related rows, and shape the lines into an array for the repeating section.
  3. Call Populate a Microsoft Word template. It returns a Word file.
  4. Save the file to the library, then wait about a minute, as Microsoft suggests.
  5. Call Convert Word Document to PDF, or the OneDrive for Business Convert file action with PDF as the target type (OneDrive for Business connector).
  6. Write the PDF back to the record, or email it.

Licence. Word Online (Business) is a premium connector in Power Automate and Power Apps (connector reference). Power Automate Premium is listed at $15 per user per month and Process at $150 per bot per month, paid yearly, both with premium connectors (Power Automate pricing).

Where it breaks. From the Word Online (Business) reference:

The OneDrive Convert file route cannot convert digitally signed, password-protected or IRM-restricted Word documents (OneDrive for Business connector). Apply to each runs one iteration at a time by default (up to 50), and daily Power Platform requests range from 10,000 on the Low performance profile to 500,000 on High (Power Automate limits).

5. When should you use a paginated report for PDFs?

When the output is really a report. Microsoft positions them for “highly formatted, print-ready output optimized for printing or PDF generation”; a long table prints in full across pages (Paginated reports in the Power BI service).

  1. In the free Power BI Report Builder, connect to Dataverse, a native data source (Supported data sources).
  2. Design the report with a parameter for the record ID, so one run produces one document.
  3. Publish to a workspace. Outside My Workspace, that needs a Pro or Premium Per User licence and at least a Contributor role (Supported data sources).
  4. Export to PDF by hand from the service, or automate it with the exportToFile API (request, poll, download) or Microsoft’s Power Automate templates (Export paginated report to file).

Licence. Microsoft lists Power BI Pro at $14 and Premium Per User at $24 per user per month, paid yearly. Fabric capacity is “variable” there (Power BI pricing). For automated export, the report must sit in a workspace backed by Premium, Embedded or Fabric capacity (exportToFile). Microsoft’s Power Automate templates list A4–A6 or P1/F2 and above as the prerequisite (Export paginated reports with Power Automate).

Where it breaks:

6. When do you need a document-generation add-in or engine?

When methods 1–5 each fail on something you need: batches, conditional sections, deep related data or frequent template changes.

  1. Install the vendor’s solution or connector.
  2. Design the template in the vendor’s tool, bound to Dataverse tables.
  3. Call it from a button, a flow or an API.
  4. Store the PDF on the record, in SharePoint, or send it out.

Licence. The vendor’s, on top of your Microsoft licences, priced per user, per document, per credit or per environment. We compare nine options and their published prices in Dynamics 365 document generation tools compared.

Ours, for transparency. SSS DocGen is a document engine that runs in your own Azure subscription. Apps and flows call one Dataverse custom API, sss_GenerateDocument. Templates are Handlebars HTML plus FetchXML datasets, stored as Dataverse rows, rendered to PDF by Chromium. The licence is €7,500 per production environment per year, excluding VAT, with dev and test environments free. Deployment and onboarding is €5,500 for the first environment (DocGen, pricing).

Where it breaks, for DocGen specifically:

Which method should you use?

Stop at the first clear answer.

  1. A quick copy of a canvas screen? Print() for one page; PDF() for a file, accepting it is experimental.
  2. One Dynamics 365 Sales record, a short list of lines, standard fonts? A Word template with Export to PDF; no add-in needed.
  3. Automatic PDFs on a row change, a few dozen a day? Power Automate, if you hold premium licences and no MFA conditional access blocks the connector.
  4. The output is a long report, and you already run Power BI capacity? Use a paginated report with exportToFile.
  5. Batches, conditional content, brand fonts, deep related data or frequent changes? Shortlist an add-in or engine and price it at your busiest month’s volume.

Two numbers usually decide it: related rows per document and documents per month. Check both before you build.

SSS DocGen

When the built-in methods run out

SSS DocGen renders branded PDFs from Dataverse records in your own Azure subscription. Templates are configuration held as Dataverse rows, so changing one needs no code release. €7,500 per production environment per year, excl. VAT. Unlimited users, templates and documents; dev and test environments are free.

Sources

Microsoft pages this article relies on (checked 25 September 2026):

  1. PDF function (experimental), Microsoft Learn
  2. Work with the PDF function (experimental), Microsoft Learn
  3. Print function, Microsoft Learn
  4. Print quote, invoice, or other records, Microsoft Learn
  5. Export sales records to PDF, Microsoft Learn
  6. Enable or disable PDF file generation from sales records, Microsoft Learn
  7. Use Word templates to create standardized documents, Microsoft Learn
  8. Word Online (Business) connector reference, Microsoft Learn
  9. OneDrive for Business connector reference, Microsoft Learn
  10. Limits of automated, scheduled, and instant flows, Microsoft Learn
  11. Paginated reports in the Power BI service, Microsoft Learn
  12. Supported data sources for Power BI paginated reports, Microsoft Learn
  13. Export paginated report to file, Microsoft Learn
  14. Export paginated reports with Power Automate, Microsoft Learn
  15. Licensing overview for Microsoft Power Platform, Microsoft Learn
  16. Power Apps pricing, microsoft.com
  17. Power Automate pricing, microsoft.com
  18. Power BI pricing, microsoft.com