Showing results for 
Search instead for 
Did you mean: 
Helper II
Helper II

Duplicate detection via portal

I have seen some discussion about using alternate keys to prevent duplicate detection in portals.  


I need to prevent users from adding the same entry twice in to a table.



User skills table

Lookup - UserName

Looup- SkillName


I need to ensure the same user does not enter the same skill twice via portal form.


Any ideas?



Solution Sage
Solution Sage

Either use an Alternate Key (applies to everything not just Portal) or write a Plugin or Custom Workflow Activity and set up to be synchronous (real-time) that will query the existing data to check not a duplicate.  Could also use a Custom Validation on the Portal and make either call via Portal Web API or (the older) call a Web Page that returns JSON results. 

Super User
Super User

Hi @MichelleH 


Alternate keys will definitely work. Official reference below 


In some cases, duplicate detection rules will help but alternate key is the easiest way.  


Hope it helps. 

If you like this post, give it a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users to find it.


Helpful resources

Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

Super User 2 - 2022 Congratulations 768x460.png

Welcome Super Users

The Super User program for 2022 - Season 2 has kicked off!

Users online (4,078)