• Skip to main content
  • Skip to primary sidebar
  • Skip to footer
  • Home
  • Blog
  • Power Platform
    • Power Apps
    • Power Automate
    • Power BI
    • Power Virtual Agents
  • Dynamics 365
  • Azure
  • About Me
Joe Gill Logo

Joe Gill

Microsoft MVP - Power Platform Consultant

Home » Power Platform » Dynamics 365 » Flow to Email PDF from Dynamics 365 using the Word Online Connector

Flow to Email PDF from Dynamics 365 using the Word Online Connector

3rd February 2019 by Joe Gill

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 to Email PDF from Dynamics 365 using the Word Online Connector Joe Gill Dynamics 365 Consultant

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.Flow to Email PDF from Dynamics 365 using the Word Online Connector Joe Gill Dynamics 365 Consultant

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

Flow to Email PDF from Dynamics 365 using the Word Online Connector Joe Gill Dynamics 365 Consultant

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 to Email PDF from Dynamics 365 using the Word Online Connector Joe Gill Dynamics 365 Consultant

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

 

 

 

 

Share This On Social:
  • Tweet
  • Flow to Email PDF from Dynamics 365 using the Word Online Connector Joe Gill Dynamics 365 Consultant

Filed Under: Dynamics 365, Logic Apps, Power Automate, Power Platform

Primary Sidebar

Popular Categories

  • Power Platform
    • Power Apps
    • Power Automate
    • Power Virtual Agents
  • Azure
    • Logic Apps
  • Dynamics 365
  • .NET
  • AI
  • SQL

More to See

Power Platform Requests – Base Request Capacity

17th December 2020 By Joe Gill

Power Automate Desktop

Power Automate Desktop – UI Flow

26th November 2020 By Joe Gill

Tweets

Footer

Joe Gill

Microsoft Business Applications MVP – Power Platform, Dynamics 365 and Azure.

An architect with over twenty years experience designing and developing technology solutions. Specializing in the Microsoft technology stack including Power Platform, Dynamics 365 and Azure. Microsoft MVP Profile

Connect on Social

Useful Links

  • Home
  • Blog
  • About Joe Gill
  • Power Platform
  • Dynamics 365
  • Azure

Featured Posts

Power Platform Requests – Base Request Capacity

Power Automate Desktop – UI Flow

MB-600 – Solution Architect – Supportability

AI Builder – Form Processing Layouts

© 2021 · Joe Gill