cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Anonymous
Not applicable

Duplicate Check in CDS

While creating a new record in CDS using an entity form, is there any way to show the duplicate entries as the user types in the name, or any other way. 

 

For example, if a user wanted to make a new record and began typing "AB" into the name field, existing record "ABC" would appear and the user would know that "ABC" already exists in the CDS database.

 

Thanks

2 ACCEPTED SOLUTIONS

Accepted Solutions
jaguil3ra
Level: Powered On

Re: Duplicate Check in CDS

You used the duplicate detection rules?. You maybe to use a detection rule that allow to check when the name start with the same first characterssample1.jpg

 

View solution in original post

jaguil3ra
Level: Powered On

Re: Duplicate Check in CDS

Hello @Inpriya01,

Follow this route: Advanced Setting > Data Management > Duplicate detection rules temp1.png:

temp2.jpg

 

temp3.jpg

View solution in original post

5 REPLIES 5
jaguil3ra
Level: Powered On

Re: Duplicate Check in CDS

You used the duplicate detection rules?. You maybe to use a detection rule that allow to check when the name start with the same first characterssample1.jpg

 

View solution in original post

Community Support Team
Community Support Team

Re: Duplicate Check in CDS

Hi @Anonymous ,

Could you please share a bit more about your scenario?

How do you create a new record into your CDS Entity? Using Entity form or PowerApps app form?

 

If you want to create a new record into your CDS Entity using Entity form, I afraid that there is no way to achieve your needs.

The Duplicate Dection Rule would take effect when you add a new record or update an existing record within your CDS Entity, it could not take effect when you type text within the Name field. In addition, it could not display the existing record within your CDS Entity.

 

If you want to create a new record using PowerApps app form, I think PowerApps app form could achieve your needs.

On your side, you could consider generate an app based on your CDS Entity, then go to the Edit form. Within the Edit form, unlock the Name Data card, and within the Name Data card, add a Data Table control as below:1.JPG

Set the Items property of the Data Table to following:

Filter([@TaskLists], StartsWith(TaskName, DataCardValue6.Text))

On your side, you may type:

Filter('YourCDSEntity', StartsWith(NameField, NameFieldTextInputBox.Text))

Set the Visible property of the Data Table to following:

If(
    IsBlank(NameFieldTextInputBox.Text) || IsBlank(LookUp('YourCDSEntity', StartsWith(NameField, NameFieldTextInputBox.Text))),
false,
true )

Note: If the NmaeFieldTextInputBox is Blank or there is no existing record whose name starts with NmaeFieldTextInput text value, the Data Table would be hidden.

 

Please consider take a try with above solution, check if the issue is solved.

 

Best regards,

Community Support Team _ Kris Dai
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Inpriya01
Level: Powered On

Re: Duplicate Check in CDS

Hello 

thanks for your reply, just wanted to know how did you navigate to this screenshot which you mentioned in your reply?

dup chk.PNG

 

Anonymous
Not applicable

Re: Duplicate Check in CDS

jaguil3ra
Level: Powered On

Re: Duplicate Check in CDS

Hello @Inpriya01,

Follow this route: Advanced Setting > Data Management > Duplicate detection rules temp1.png:

temp2.jpg

 

temp3.jpg

View solution in original post

Helpful resources

Announcements
thirdimage

Power Automate Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

sixthImage

Power Platform World Tour

Find out where you can attend!

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

fifthimage

Microsoft Learn

Learn how to build the business apps that you need.

Top Kudoed Authors (Last 30 Days)
Users online (4,655)