Easy contact form to CRM lead using Microsoft flow

Many companies are looking for an easy solution to process a contact form on their website to a lead in CRM. In this post I’ll provide an easy, self service solution that requires no code.

Tools

To build this solution we are assuming the following:

  • You have Dynamics 365 CRM
  • Microsoft Flow is enabled in your tenant
  • You are ok with using Cognitoform or any other form tool or custom code that can post the form data to an url
  • You already use WordPress and Contact Form 7

I’ll be using a generic approach where you parse the json data from a webhook call. The tool above also has a built in connector to Microsoft Flow. That would even be a better option, but not all platforms support Flow. This approach is very easy to implement for a developer building your website.

Setup

The first thing we need to create is the basic Microsoft Flow. Go to Microsoft Flow and log in with your Office 365 credentials.Create a new flow and start with a blank canvas.
The first step is adding a trigger. The trigger you are looking for is the Request trigger. Select it and don’t fill out anything just yet. Next, add the Dynamics 365 connector and configure it to create a lead in your CRM instance. For now just use some dummy values. Save your flow and notice that you’ll get a request url in the Request trigger. Copy that so we can use it in the Cognitoform setup.

It’s pretty easy to setup a test account with Cognitoformand and create your first form. It took me less than 5 minutes. After you are done configuring your fields, you want to go to the submission settings on the bottom of the page. Add the Flow url in the “Post Json data to a website”:

Test your form and return to your flow and you’ll likely see one run has failed. That’s ok for now. Click this failed run and look for the request body of the trigger. Copy that:

Edit your flow and click the Request trigger. Click “Use sample payload to generate schema” and paste in the json from the previous step. Now you have defined the schema from the request and you can use those schema values to create the lead. Click the “Create record” step and use the defined values form the previous step to enter the values for your CRM fields.

Now you’re all setup. Fill out a form a see that a lead is created in CRM.

WordPress

For WordPress and Contact Form 7 users, there’s a great plugin available. It posts the form data to an http endpoint, like flow, with just a few clicks in configuration. At the time of writing, CF7 to Zapier is not very popular yet, but I’ve tested it personally and it works great. Although the name contains Zapier, you can use any http endpoint that accepts application/json as it’s body.

Other options

In this sample I used a service that allowed me to test this integration without creating a subscription. There are many alternatives like Wufoo or Typeform that most likely could deliver a similar integration.

Leave a Reply

Your email address will not be published. Required fields are marked *