Skip to main content

Notifications

Community site session details

Community site session details

Session Id :
Power Pages - General Discussions
Unanswered

Duplicate detection via portal

(0) ShareShare
ReportReport
Posted on by 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

Categories:
  • ragavanrajan Profile Picture
    7,036 Most Valuable Professional on at
    Re: Duplicate detection via portal

    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.

     

  • Fubar Profile Picture
    7,966 Super User 2025 Season 1 on at
    Re: Duplicate detection via portal

    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. 

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Michael Gernaey – Community Spotlight

We are honored to recognize Michael Gernaey as our June 2025 Community…

Congratulations to the May Top 10 Community Leaders!

These are the community rock stars!

Announcing the Engage with the Community forum!

This forum is your space to connect, share, and grow!

Leaderboard > Power Pages

#1
Fubar Profile Picture

Fubar 69 Super User 2025 Season 1

#2
oliver.rodrigues Profile Picture

oliver.rodrigues 49 Most Valuable Professional

#3
Jon Unzueta Profile Picture

Jon Unzueta 43