125
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
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.
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.
#1
Fubar
69
Super User 2025 Season 1
#2
oliver.rodrigues
49
Most Valuable Professional
#3
Jon Unzueta
43
Share
Report
All responses (
Answers (
