• Home
  • Blog
  • About Me
  • Home
  • Blog
  • About Me
Dynamics 365  ·  Logic Apps  ·  Power Automate  ·  Power Platform

Generate Dynamics 365 PDF with Power Automate

By Joe Gill  Published On 3rd February 2019

One of the never ending challenges of using Dynamics 365 was how to generate and email PDF’s using data from Dynamics. While Word templates went some way towards solving the problem they have not been improved for a number of years. So generating PDF’s usually requires third party tools. With the release of the new Word Online (Business) connector for Flow and Logic Apps it looks like we have a potential solution. The new connector comes with two actions. The first populates a Word Template with values from a flow. The second action converts a document to a PDF.

I was able to use these actions in a Flow to populate a confidentiality agreement with  a contact’s fullname and address and email it as a PDF to the contact.Flow Email PDF from Dynamcis 365 - Joe Gill

To create a template in Word select the developer tab and click plain text content control which inserts a control thst acts as a merge placeholder. Now give your control a name which is used to identify and populate it from Flow. Once your template is created upload it to a SharePoint or OneDrive location where your flow can retrieve it. I could not find a way to load a template directly from Dynamics.Word Online Connector Template - Joe Gill

You can now use the template in your flow populating it with your Dynamics data.

Flow Populate Word Template with Dynamics Content - Joe Gill

The next action saves the result of the template population to a SharePoint drive so it can be converted to a PDF by the next action.  The final action sends an email with the converted PDF as an attachment to the contact’s email address.

Flow Send Email with PDF Attachment - Joe Gill

The Word Online Connector is currently in preview however I am suitably impressed with its potential and looking forward to seeing it expanded.

 

 

 

 


PowerPlatform DataGateway - Joe Gill MVP
How to install the Data Gateway
Previous Article
Microsft Flow - Http Request - Split On
Flow - Http Request - Split On Collection
Next Article