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]