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.
Solved! Go to Solution.
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:
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))),
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.
Check it out!
Check it out!
Fill out a quick form to claim your user group badge now!
Find out where you can attend!
Features releasing from October 2019 through March 2020
The largest Power BI, Power Platform, and Data conference in New Zealand