Let’s make something together

KAISPE has been providing solutions and services to customers using Microsoft Dynamics, Azure, Power platform, Oracle NetSuite, mobile and web app development.

    • US OFFICE
    • +1 315 791 4472
    • KAISPE LLC
      590 Madison Avenue 21st Floor Manhattan, NY 10022 USA.

 

  • PAKISTAN OFFICE
  • +92 213 432 6085
  • M/S KAISPE
    Suite#213 Sumya Business Avenue MACHS Karachi, Pakistan.

Generate Lead record in Microsoft Dynamics CRM through Web Contact form using MS Power Automate

  • May 4, 2020
  • 496 Views

Recently I was working on a scenario where I have to automatically generate a lead record in Microsoft Dynamics CRM through a simple web contact form using MS Power Automate. Typically, when visitors visit a corporate website, they show their interest in products or services by filling in a contact form in Contact page of website. This is helpful in RPA (Robotic Process Automation) scenarios where we need to automatically generate a lead record in CRM through the information in contact form without human intervention.

So, today we will walk through an entire process step by step to understand the flow in detail.

Here are the steps we follow in our scenario – add trigger When a new email arrives, add an action HTML to Text to convert an email body to plain text.

Next, add Compose action to split an email body into an array:

Now, as we have output in an array, each element a line from your email. Next, we need to add a Filter array to extract the line with ‘Name:’ and configure its condition rule to verify if current item () contains ‘Name: ‘

Next, we have to split Name into First and Last name – add Compose action to perform the following task:

In the next following steps, add a Filter array to extract the lines with ‘Email:’, ‘Company:’, ‘ Phone:’ and ‘Message:’ – add Compose action with following outputs we get from filter array.

To automate the process, we use UI Flow to generate lead record in MS Dynamics CRM through Web Contact form using MS Power Automate

Then send an email to CRM, admin to get approval on if the Lead can be created with approval comments.

If the following is Approve or Rejected, sends back an email to the requester with approver response.

Finally, we have successfully created lead record in MS Dynamics CRM:

We hope you have found it useful. For any queries, please contact [email protected]