Throw an error in Dynamics 365

(0) Share

Report

Posted on by Sumaira Noor

1,083

Hello community experts,

I have a requirement where, if i try to enter a duplicate mail ID, that field should not allow me to enter the duplicate. I should throw an error, that this record already exist.

I tried using keys and duplicate detection rule.

Both does'nt meet this requirement.

Please Help.

Best Regards,

Sumaira Noor

All responses (10)

Answers (2)

Verified answer

LeoAlt 16,331 Moderator on at

Like (0)

Report

RE: Throw an error in Dynamics 365

Hi Sumaira,

Sorry for my mistake, in your case we should use "retrievemultiplereocrds" to get data because "retrieveRecord" could only get an special record with GUID.

So just use "retrievemultiplereocrds" instead, and which entity are you filling the emailaddress? According to your code, I think you might using contact. Then you need to replace the main entity "email" with "contact".

function compareEmailID(executionContext){

var formContext = executionContext.getFormContext();

var emailID=formContext.getAttribute("emailaddress1").getValue();

Xrm.WebApi.retrieveMultipleRecords("contact","?$select=emailaddress1&$filter=emailaddress1 eq '" + emailID+"'").then(

function success(result) {

if (result.length>0) {

Xrm.Page.ui.setFormNotification("This EmailID is exsited, please try another one!", "ERROR")

}

},

function error(error) {

Xrm.Navigation.openAlertDialog({ text: error.message });

}

);

}

docs.microsoft.com/.../retrievemultiplerecords

Hope it helps.

Best Regards,

Leo
Sumaira Noor 1,083 on at

Like (0)

Report

RE: Throw an error in Dynamics 365

Thanks for the response Leo.

Here is the code.

I have added it as a script webresource

function compareEmailID(executionContext){

var formContext = executionContext.getFormContext();

var emailID=formContext.getAttribute("emailaddress1").getValue();

Xrm.WebApi.retrieveRecord("email", "?$select=emailaddress1&$filter=emailaddress1 eq '" + emailID + "'").then(

function success(result) {

if (result.length>0) {

Xrm.Page.ui.setFormNotification("This EmailID is exsited, please try another one!", "ERROR")

}

},

function error(error) {

Xrm.Navigation.openAlertDialog({ text: error.message });

}

);

}
LeoAlt 16,331 Moderator on at

Like (0)

Report

RE: Throw an error in Dynamics 365

Hi Sumaira,

According to the error message, there should be something wrong in the web api filter conditions. Could you kindly share your code to us and so that we could debug or check it for you.

Best Regards,

Leo
Sumaira Noor 1,083 on at

Like (0)

Report

RE: Throw an error in Dynamics 365

Thanks for the response Leo

I'm attaching there screenshot below.

I have replaced the correct name

Best Regards,

Sumaira Noor
LeoAlt 16,331 Moderator on at

Like (0)

Report

RE: Throw an error in Dynamics 365

Hi partner,

Please pay attention that you should replace the correct field name in your case, "emialid" is only a sample.

If it is possible, please share the log file for more details.

Best Regards,

Leo
Sumaira Noor 1,083 on at

Like (0)

Report

RE: Throw an error in Dynamics 365

Thanks a lot for your response Leo

I'm getting this error

One of the scripts for this record has caused an error. For more details, download the log file.

Kindly guide

Best regards,

Sumaira Noor
Suggested answer

Dynamics365 Rocker 7,755 on at

Like (0)

Report

RE: Throw an error in Dynamics 365

Create a plugin and register it on create of respective entity.

In this plugin retrieve record that has same email id , If record found then throw invalid pluginexecution exception.
Suggested answer

LeoAlt 16,331 Moderator on at

Like (0)

Report

RE: Throw an error in Dynamics 365

Hi partner,

First of all, we could not choose email as "base record type" in duplicate detection rule, so we could only use custom development.

If the mail ID is a custom field not GUID, there are 2 ways to meet your requirement.

1.Using JS code.

You could create a js function the compare the email ID you've entered in the create form with other existing emails and if this ID is existed, then throw an error or alert.

function compareEmailID(executionContext){

    var formContext = executionContext.getFormContext();

    var emailID=formContext.getAttribute("emailid").getValue();

    Xrm.WebApi.retrieveRecord("email", "?$select=emailid&$filter=emailid eq '" + emailID + "'").then(

        function success(result) {



            if (result.length>0) {

                Xrm.Page.ui.setFormNotification("This EmailID is exsited, please try another one!", "ERROR")

            }

        },

        function error(error) {

            Xrm.Navigation.openAlertDialog({ text: error.message });

        }

    );

}

2.Using Plug-in.

You could refer to this doc with samples.

https://docs.microsoft.com/en-us/previous-versions/dynamicscrm-2016/developers-guide/hh210213(v=crm.8)?redirectedfrom=MSDN

https://www.inogic.com/blog/2015/11/use-retrieveduplicaterequest-in-dynamics-crm/

Hope it helps.

Best Regards,

Leo
Sumaira Noor 1,083 on at

Like (0)

Report

RE: Throw an error in Dynamics 365

Thanks for the response Lu

Actually i tried many times the key feature is not working. It does'nt throw any error upon duplicate detection.

Best Regards,

Sumaira Noor
Verified answer

LuHao 40,886 on at

Like (0)

Report

RE: Throw an error in Dynamics 365

Hi Sumaira,

Could you tell me why the alternate key and duplicate detection rules don't meet your needs?