Unanswered

Duplicate detection before submit JS

(0) Share

Report

Posted on by ahilisa

Hi all,

Can you tell me now to apply a duplicate detection rule to a portal basic web page form, that when the user clicks submits it will check my dataverse table to see if an entry already exists. I was to check if the email address is already in the table and if it is then the user should be given an error message and the form cannot be submitted.

Can this be done with JS as I am not familiar with plugin.

Thanks

Categories:

Customize & extend

I have the same question (0)

All responses (2)

Answers (0)

OOlashyn 3,496 Most Valuable Professional on at

Like (0)

Report

Hi @ahilisa ,

It can be done with JS but it might be a bit tricky from a security perspective. I would highly recommend you to do it via plugin if possible. However, if not possible you could do it with JS. I wouldn't recommend using Web API or fetchxml to query the data as you would need to provide your used Global access which in most cases is a problem. What you could do instead is create a Cloud Flow with Power Pages trigger, send an email as an input parameter, fetch data inside the flow and send true/false back to indicate if it is a duplicate or not. Then on the form, you can hide OOB submit button, and replace it with your custom one that on click will call a cloud flow to perform a validation.

Was this reply helpful? Yes No
EmadBeshai 806 Moderator on at

Like (0)

Report

Hi @ahilisa ,

As @OOlashyn it is recommended to use plugin if possible to control on the the error message, another solution is adding the alternative key but in this case you will be able to prevent the duplication, but you will receive the OOB error message without any control from your side except catching the error message and replacing it with JS, but I don't like that solution.

If this post helps you with your problem, please mark this answer as Accepted Solution.

If you like my response, please give it a Thumbs Up.

Was this reply helpful? Yes No