web

You’re offline. This is a read only version of the page.

News and Announcements icon

Dynamics 365 CommunityForums Microsoft Dynamics CRM (Archived) Duplicate detection Ru...

Microsoft Dynamics CRM (Archived)

Duplicate detection Rule With a condition

(0) Share

Report

Report

Posted on by Jamil Lamyae

5

Hello community ,

I have a duplicate detection to implement but it depends on a picklist field A, I mean :

If A = 1 then ( the fields to check are A , B , C )

if A = 2 then ( the fields to check are A, B,D)

if A= 3 then ( the fields to check are A ,B, E )

I was wondring if it's possible to implement this in the duplicate detection rule or if it exist any workaround

Please Let me know !!!!

Ps : I work on Dynamics crm on permise 2015

*This post is locked for comments

I have the same question (0)

All responses Img

All responses (4)

Answers Img

Answers (2)

Sort by

Verified answer

gdas 50,091 Moderator on at

Like (1)

Report
Copy link

Link copied!

Hi Lamaye,

You can not add IF-ELSE condition in the duplicate detection rule. However you can create multiple rules instead of single rules .

For example

A= 1 B=3 C=5 -- First Rule

A= 2 B=6 C=9 -- Second Rule

Another option would be using plugin.

Hope this helps.

Was this reply helpful? Yes No
Jamil Lamyae 5 on at

Like (0)

Report
Copy link

Link copied!

Thanks Goutam for the reply

I get your point

But here is an other issue when I am trying to implement your GREAT suggestion I got this error : the max code correspondence reached 568/450

Do you have any Idea how to overcome this :

I guess the first field (picklist field A) has much caracters when I remove it I got 312/450 but i need it as filter

Was this reply helpful? Yes No
Verified answer

gdas 50,091 Moderator on at

Like (1)

Report
Copy link

Link copied!

There is limitation match code length 450 characters. You cant change it , make sure you are doing check only those are under 450 characters.

You can refer below thread -

https://community.dynamics.com/crm/f/117/t/95303

Was this reply helpful? Yes No
gdas 50,091 Moderator on at

Like (0)

Report
Copy link

Link copied!

Hi Lamye,

Please verify my first answer as this is the main answers for your main/initial question. This will helps other people in future if people are looking for similar requirement.

Was this reply helpful? Yes No

Helpful resources

Quick Links

Leaderboard > 🔒一 Microsoft Dynamics CRM (Archived)

#1

#2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans