Duplicate detection via portal

[MichelleH]

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.

Example,

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?

Thanks

[Fubar]

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. 

[ragavanrajan]

Hi @MichelleH 

Alternate keys will definitely work. Official reference below 

https://docs.microsoft.com/en-us/power-apps/developer/data-platform/define-alternate-keys-entity 

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.