Showing results for 
Search instead for 
Did you mean: 
Frequent Visitor

How to prevent duplicate records with advanced forms


I have a dataverse table that contains the portal user (lookup on Customer table ) and a string column, 'period'.

I have an advanced form with the first step displaying an input field for this field 'period'.  However, I want to prevent duplicate entries, so that there is only one record for each portal user.  

I cannot use alternative keys as there is no column for the lookup column when I try and create an alternative key in dataverse, I see the rest of the columns but not the portal user column.  


The ideal behaviour is when the user starts the advanced form and enters a value in the period column.  If there is already a record with the portal user and period value, then it should redirect to an edit form.


Thanks in advance,

Resolver I
Resolver I

I am writing an article for the solution for custom duplicate detection, will post here as soon as it's ready.

Helpful resources

UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

M365 768x460.jpg

Microsoft 365 Collaboration Conference | December 7–9, 2021

Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.

Users online (2,083)