cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
MichelleH
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.

 

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

2 REPLIES 2
Fubar
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. 

ragavanrajan
Super User
Super User

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.

 

Helpful resources

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