Skip to content
  • There are no suggestions because the search field is empty.

How to connect the Microsoft Dynamics 365 Sales integration

Learn how to integrate your Firmable account with your Dynamics 365 Sales account for contact and company imports.

Learn more:

Connect the integration
How to map users
Mapping company (account) fields
Mapping lead fields
Mapping contact fields
How to create a custom field

Prerequisites

Before initiating the integration, ensure the following: 

  • You are on a Small Teams, Teams Pro or Enterprise plan with Firmable.  
  • You have the Admin, Manager or Integration role on Firmable and the Admin role in MS Dynamics. 
  • No other CRM is connected to Firmable. You can connect one CRM at a time.

Note: If your company has multiple Admins, the app only needs to be installed once by one Admin. All other Admins and users can subsequently use it. 

Integration setup

Connect the integration

  • Log in to Microsoft Dynamics 365 Sales in a separate tab. 
  • Log in to your Firmable account to begin the integration process. 
  • Click your profile picture (top right) and select Manage account. Manage account in the avatar menu highlighted
  • In the Account settings sidebar, click on Integrations.The Account settings sidebar with Integrations highlighted
  • Locate the MS Dynamics 365 Sales card and click Connect. The Integrations page with the MS Dynamics 365 Sales card highlighted
  • Enter your MS Dynamics 365 subdomain when prompted and click Continue to proceed.The Dynamics 365 Sales dialog with the subdomain field and Continue highlighted
  • In Microsoft Dynamics 365 Sales, your subdomain is the first part of your Dynamics environment’s URL.
    A Dynamics 365 environment URL in the browser with the subdomain highlighted

For example, if your environment URL is https://contoso.crm6.dynamics.com, your subdomain is contoso.crm6.

  • Your Microsoft Dynamics 365 Sales integration is now connected.
    Connected badge on the MS Dynamics 365 Sales card highlighted

How to map users (optional but recommended)

Note: If users are not mapped, the default behaviour is to leave the record owner field blank. 

  • Click on User mappings.User mappings tab highlighted
  • For each Firmable user, select the matching MS Dynamics user from the Owners name dropdown.  Open Owners name dropdown highlighted
  • Repeat this step for each Firmable user and click Save changes.The MS Dynamics 365 Sales User mappings tab with Save changes highlighted
  • To clear a user mapping, click the rubbish bin icon and click Save changes. Rubbish bin icon on a mapped row highlighted

Mapping company (account) fields

Note: Firmable matches company records by website domain, so ensure the domain or website field is mapped correctly at your endpoint to enable accurate record matching downstream and avoid duplicate records.

  • The next step is to review a list of MS Dynamics Account properties (fields) mapped to corresponding Firmable company properties (fields). Under Integrations, click MS Dynamics 365 Sales, then select the Account field mappings tab. 
  • Note: Firmable will map some MS Dynamics 365 Sales fields by default. 
  • If an MS Dynamics 365 Sales field is already mapped, it will be greyed out and unavailable for selection. To map it to another field, you’ll need to clear the current mapping first.Account field mappings tab highlighted
  • Change the pre-selected Firmable properties by choosing a Dynamics field from the MS Dynamics 365 Sales account field dropdown next to each Firmable field.
    Open MS Dynamics 365 Sales account field dropdown highlighted
  • To add more fields to map, click Add field.
    The MS Dynamics 365 Sales Account field mappings tab with Add field highlighted

    • Use the search bar to find the field you want to map, or browse the category list and expand a category using the down arrow.
      Search box and a category expand arrow highlighted
    • Click + Add to include the field in your mapping.
      + Add next to an unmapped field highlighted
  • Once you’ve reviewed all the properties you want to connect, select the Sync rule for each property that applies whenever Firmable updates an existing company record in your CRM, for example when you push, re-push or enrich it. The three options are: 
    • When blank use Firmable. This means if there is currently no value in the field for a record, Firmable data will be populated when enriched. This is the most commonly used sync rule. 
    • Override from Firmable. This means regardless of whether there is or isn’t a value in the field for a record, Firmable data will override it when enriched. Note: Be wary of using this, as it will override existing data you have populated in MS Dynamics for that field. 
    • Don’t sync. You can also choose not to sync the property at all.  
    Open Sync rule dropdown highlighted

  • Click Save changes when done. 

Note: During mapping, ensure that the data types match between Dynamics and Firmable so that the data can be pushed to MS Dynamics without errors. Firmable supports Text, Number, and Boolean field types, but for optimal compatibility, map to Text type fields in MS Dynamics. 

Mapping lead fields

Note: Firmable matches people records by email address, so ensure the email field is mapped correctly at your endpoint to enable accurate record matching downstream and avoid duplicate records.

  • Click on Lead field mappings and review the list of MS Dynamics lead fields mapped to corresponding Firmable contact fields.
  • Complete the same steps as described under Mapping company (account) fields above, including mapping properties and choosing sync rules.
  • Click Save changes when done.

Mapping contact fields

Note: Firmable matches people records by email address, so ensure the email field is mapped correctly at your endpoint to enable accurate record matching downstream and avoid duplicate records.

  • Click on Contact field mappings and review the list of MS Dynamics contact fields mapped to corresponding Firmable contact fields.
  • Complete the same steps as described under Mapping company (account) fields above, including mapping properties and choosing sync rules.
  • Click Save changes when done.

Your MS Dynamics 365 Sales integration is now set up and ready for use.

How to create a custom field on Microsoft Dynamics 365 Sales 

If your Dynamics 365 Sales instance does not have a suitable field to capture Firmable ID, you can create a field using the following instructions. The following steps are focused on creating the custom Firmable ID field for the Account object. The same steps will need to be repeated for the Lead and Contact objects also. 

  • Click Settings.
    The Dynamics 365 Sales dashboard with the Settings icon highlighted
  • Click Advanced Settings.
    The Dynamics 365 Settings panel with Advanced Settings highlighted
  • Click Customizations.
    The Dynamics 365 Power Platform Environment Settings sidebar with Customizations highlighted
  • Click Customize the system.
    The Dynamics 365 Customization page with Customize the system highlighted
  • Click Account.
    The Power Apps Tables list with the Account table highlighted
  • Click Columns.
    The Account table in Power Apps with Columns highlighted under Schema
  • Click New Column.
    The Account table Columns list in Power Apps with New column highlighted
  • Enter the Display Name, Data type and Format for the new custom field e.g. Firmable ID, Single Line of text and Text, followed by clicking Save to continue.
    The Power Apps New column panel with Display name, Data type, Format and Save highlighted
  • A new custom field has now been created.