Skip to main content
All CollectionsIntegrationsCRMs
Microsoft Dynamics 365 data-import integration
Microsoft Dynamics 365 data-import integration
Updated over 3 months ago

Availability: Business and Enterprise plan

Data-import integration with Microsoft Dynamics 365 allows you to pre-populate PandaDoc documents with data from Microsoft Dynamics 365 to easily send and esign them. This integration works with Competitors, Opportunities, Contacts, Quotes, Leads, and Accounts objects in Microsoft Dynamics 365.

Skip to:

Features

Variables: You can pass information from Microsoft Dynamics 365 to PandaDoc documents automatically with the help of variables.

Recipients: You can pass contact information from Microsoft Dynamics 365

Connect Microsoft Dynamics 365 to your PandaDoc account

  1. Log in to both your PandaDoc and Microsoft Dynamics 365 accounts.

  2. In PandaDoc, open a template or a document and go to Apps on the right panel

  3. Click on the Microsoft Dynamics 365 tile

  4. In the popup, select Authorisation and Account type, fill out the subdomain, Client ID, and Client Secret from Microsoft Dynamics 365, then sign in with Microsoft

Set up templates to pull information from Microsoft Dynamics 365

PandaDoc data-import integration with Microsoft Dynamics 365 allows you to pre-populate information from Microsoft Dynamics 365 in your PandaDoc templates through variables and pre-assign contact information to template roles.

Now let's dig deeper.

Import field values from Microsoft Dynamics 365 via variables

Pre-set a PandaDoc template with variables that will pull information from Microsoft Dynamics 365 each time you create a new document from this template.

  1. Open your template (click here to learn how to create a new one) in PandaDoc

  2. Go to Apps on the right panel

  3. Click Microsoft Dynamics 365

  4. Click Change variables to select the object you need to see relevant variables (you can choose between Competitors, Opportunities, Contacts, Quotes, Leads, and Accounts objects)

    Note:

    One document can be linked to a single object at a time.

  5. Select View related variables. You will see a list of available variables corresponding to a Microsoft Dynamics 365 object's fields. Copy and paste these variables into your template

Import field values Microsoft Dynamics 365 via fields

You can pass data into PandaDoc fields similarly to how variables operate. Unlike with variables, however, you must not include square brackets.

  1. In your template, go to the Variables tab and scroll down to Microsoft Dynamics 365 variables, or click Apps > Microsoft Dynamics 365 > View related variables

  2. Copy the variable without square brackets

  3. Click on a field in your template and select Properties on the floating panel

  4. Paste the copied variable into the “Merge field”.

Once you create and send the document, the recipient will see the pre-filled from Microsoft Dynamics 365 data and they will be able to update this field, provided the field has been assigned to them.

Import Microsoft Dynamics 365 contacts via template roles

Now let’s pre-populate this template with the recipient information from Microsoft Dynamics 365 by matching the template role with the contact placeholder from a Microsoft Dynamics 365 object. You can pre-populate your template roles with contact information from Opportunities, Leads, and Quotes in Microsoft Dynamics.

To do this, go to Roles and select the placeholder from the object you linked under “Pre-assign a recipient”.

If your template is linked to:

  • Opportunities and Leads objects, you’ll see Contact and Account as recipient placeholders

  • Quotes object, you’ll see Potential customer in “Pre-assign a recipient” dropdown

Create a document

  1. When in your template, select Use this template at the top right to create a document

  2. Click on the entity you need and select Link. Please note, you need to type the full name of an entity to find it using the search bar

  3. In the next pop-up, you’ll see the recipient information from Microsoft Dynamics 365 populated into the template role in your template (provided you’ve selected a placeholder as described here). Assign more recipients to roles if needed and click Continue (select Skip to add recipients later)

Once your document is created, variables will be populated with information from Microsoft Dynamics 365.

You can easily refresh data in the document if information in Microsoft Dynamics 365 was updated or link it to another object/record.

To link a document to another object:

  1. Go to Apps on the right panel

  2. Click Microsoft Dynamics 365

  3. Click the Unlink (click Link document if your document wasn’t created from a pre-set template)

  4. Select the Microsoft Dynamics 365 object you want to link the document to

  5. Select the record in the object and click Link. Please note, to search for a record you must type its full name

Note:

You’ll be unable to pull recipients from another object in a created document.

To update information in your document:

  1. Go to your Microsoft Dynamics 365 object and update the information

  2. Then go back to your PandaDoc document

  3. Click Apps on the right and click Microsoft Dynamics 365

  4. Select Refresh data

Note:

You can use Refresh data only in a draft document.

Did this answer your question?