Integrating Twilio with D365 CRM Online to send SMS Messages using Microsoft Flow

 One of the most popular ERP systems that is amazingly popular among all small and mid sized businesses is Microsoft dynamics NAV integration. Installing CRM NAV integration is extremely easy and simple and its interface is so easy to understand that anybody can learn it within no time. This is the reason NAV integration has earned a good reputation in the market and people love using it as well.

In today’s cloud based environment if you upgrade dynamics NAV you will surely have an edge in your business as compared to your peers. With improved functionality enhanced capabilities and new features your business productivity will be boosted multiple times reducing your overall business cost improving customer service.

Introduction:

SMS Messages can be sent from a D365 CRM Online to an individual using the Twilio. In this blog, we will see how we can send SMS Messages from CRM using Twilio and we will be using Microsoft flows to achieve this.

Pre-Requisites:

• Twilio Account
• D365 CRM
• Microsoft Flow

Steps to be followed:

Dynamics 365-

1. 1. Create two fields in Contact Entity, named as
      a. Send SMS
      b. SMS Sent

Data Type (Two options)

Twilio-

To Connect Twilio in Microsoft Flow You require:

• Twilio Account Id
• Twilio Access Token

Steps:

1. Sign in to your Twilio account
2. Click on Dashboards
3. Under Project info tab you can find the Account SID and Auth Token (Copy this value and paste it somewhere you will require this values in MS Flows) 
4. Setup Phone Number.   
   a. Click on “All Products & services”

   b. # Phone Numbers

   

MS Flow

1. Login to Microsoft flow.
2. Select Create from Blank.
3. Select Dynamics 365 connector.a. Select when a record is updated trigger.b.  Select the organization name and Entity.
4. Select “+New Step” and “Add a condition”a. Enter condition in “Edit in advance mode”.Condition:

   @and
   
   (
   
   equals(triggerBody()?['cf_sendsms'], true),
   
   equals(triggerBody()?['new_smssent'], false)
   
   )
   

5. If Yes

   a. Enter Twilio Account Id which is Acoount SID and Twilio Access Token which is Auth Token.

   b. After Connection is being established.

   • Enter the From and To Phone Number.
   • Enter Text message which you want to send.

   

6. Click on “Add a connection” –> Dynamics 365 – Update a record.

Overall Flow: