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))),
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,
