web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Customer experience | Sales, Customer Insights,...
Answered

Auto-Check Leads' Org using Email Domain?

(0) ShareShare
ReportReport
Posted on by 105

Hi Community,

I have a team of sales people who receive a large number of leads everyday. The challenge is that when a salesperson is working with a lead, that salesperson gets to 'own' that lead's organization during a 3-month cycle.

Ideally all leads would be turned into contacts with an account to check, but the vast majority of leads don't make it that far, and they receive too many leads to check if other leads with the same email domain exist in the CRM whenever they receive the lead.

Is there a way for Dynamics to perform an auto-check for all leads in the CRM that share the same email domain and alert the salesperson whenever matches are found?

I have the same question (0)
  • Verified answer
    LuHao Profile Picture
    40,892 on at

    Hi honeybear,

    We can create a new field for Lead to store the email domain, then use Power Automate to retrieve the email domain from the Email field and populate the new field, and finally use Duplicate Detection Jobs to query the Leads for duplicate email domains and the send notification.

    Step 1. Create a new field.

    pastedimage1604555910435v1.png

    Step 2. Create a flow to retrieve the email domain from the Email field and populate the new field.

    Go to https://us.flow.microsoft.com/ and select the D365 environment.

    Create an automated flow, set it as follow.

    pastedimage1604558031597v2.png

    pastedimage1604558050147v3.png

    split(triggerOutputs()?['body/emailaddress1'],'@')[1]

    Step 3. Create a Duplicate Detection Rule.

    Go to Settings > Duplicate Detection Rules, new a rule of Lead.

    pastedimage1604558430469v4.png

    pastedimage1604558543812v6.png

    Step 4. New a Duplicate Detection Job.

    Please refer to this blog: https://www.marksgroup.net/blog/dynamics-365-duplicate-detection-jobs-merging-records/

    pastedimage1604558958419v7.png

    The minimum time interval for running Duplicate Detection Job is 7 days. If you need a shorter time interval, then we need to achieve it through Power Automate.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Leaderboard > Customer experience | Sales, Customer Insights, CRM

#1
Tom_Gioielli Profile Picture

Tom_Gioielli 170 Super User 2025 Season 2

#2
#ManoVerse Profile Picture

#ManoVerse 70

#3
Jimmy Passeti Profile Picture

Jimmy Passeti 50 Most Valuable Professional

Last 30 days Overall leaderboard

Product updates

Dynamics 365 release plans