Integrate CRM to Dynamics 365 Business Central with Microsoft Flow

Published on September 9, 2019

To access details on finance, stock inventory & processing orders, integrate CRM with Business Central using Microsoft Flow. Microsoft Flow is a cloud based service which connects one or more applications or services for;

  1. Moving data
  2. Getting notifications
  3. Collecting data
  4. Creating data
  5. Scheduling event or task
  6. Sending email

There are already predefined templates and connectors in MS Flow to achieve the integration between CRM & Business Central. When the created flow is successful, it can be converted into a template.

Steps to integrate CRM with Dynamics 365 Business central

To integrate CRM with Business Central, log into CRM, Dynamics 365 Business Central and Microsoft Flow (with CRM login credentials). The accounts table in CRM denotes the customer table in Business central.

  • From the list of connectors available in Microsoft Flow, select the Dynamics 365 connector (denotes CRM)

    Integrate CRM with Business Central using Microsoft Flow-1

  • Use the predefined trigger to create/delete and update to start the trigger action

    Integrate CRM with Business Central using Microsoft Flow-2

  • Choose the organisation and entity name in the trigger section

    Integrate CRM with Business Central using Microsoft Flow-3

  • Choose next step and search for any other connector to act as repository. For this sample, Common data services (CDS) is chosen to act repository or intermediator
  • Select the action to be performed by the CDS either to create/list/update/delete action to be performed by the repository. Choose ‘Get record’ to create the record or to retrieve the record from the Dynamics 365 system

    Integrate CRM with Business Central using Microsoft Flow-4

  • Enter the environment, entity name and item identifier for the record received from Dynamics 365 system

    Integrate CRM with Business Central using Microsoft Flow-5

  • Choose ‘Business Central’ as the final action to be performed by Microsoft Flow
  • To access the record from CRM to Business Central, choose ‘Create item’ action

    Integrate CRM with Business Central using Microsoft Flow-6

  • Enter the organisation name and table name in their respective fields

    Integrate CRM with Business Central using Microsoft Flow-7

  • Check the created flow by clicking on flow checker in the ribbon for errors and warnings. Once the flow checker is done, save and test the flow.

    Integrate CRM with Business Central using Microsoft Flow-8

  • To activate a flow in CRM, click ‘Flow’ from the account page

    Integrate CRM with Business Central using Microsoft Flow-9

  • Check the status of flow whether it is running, failed or successful

    Integrate CRM with Business Central using Microsoft Flow-10

  • Once the flow has succeeded, check the record in Dynamics 365 Business Central
  • A preview of the created flow

    Integrate CRM with Business Central using Microsoft Flow-11

    Integrate CRM with Business Central using Microsoft Flow-12

    Integrate CRM with Business Central using Microsoft Flow-13

    Integrate CRM with Business Central using Microsoft Flow-14

Steps to send email notification, condition and expression in integration

Follow the above steps mentioned in normal integration to create the customer in Business Central. As the final step includes email, a condition needs to be implemented.

    • Create the trigger and action mentioned in the above steps in integrating CRM to Business Central
    • As the final step includes the connector mail to receive the mail once the customer has been created. Choose the action to be performed by the connector mail.

      Integrate CRM with Business Central using Microsoft Flow-15

    • Select ‘Send an email notification’ action to receive mail once the action has succeeded

      Integrate CRM with Business Central using Microsoft Flow-16

      Integrate CRM with Business Central using Microsoft Flow-17

    • For using the condition in a flow, choose the control connector to perform the trigger action

      Integrate CRM with Business Central using Microsoft Flow-18

    • Select the required condition to perform the action.The condition ‘is equal to’ is used in this sample in order to get the desired result

      Integrate CRM with Business Central using Microsoft Flow-19

    • Expression in flow is used to retrieve data from the application. There are predefined expressions available in flow as templates

      Integrate CRM with Business Central using Microsoft Flow-20

By partnering with a trusted Business Central partner, you can integrate these platforms to enhance your customer management processes, streamline business operations, and gain a competitive advantage.