web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id : xx02tsCYGdzp8epiLmYkix
Power Pages - General Discussions
Unanswered

Duplicate detection via portal

Like (0) ShareShare
ReportReport
Posted on 21 Jun 2022 12:51:45 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 21 Jun 2022 at 22:21:28
    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
    8,032 Super User 2025 Season 2 on 21 Jun 2022 at 22:14:51
    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

Announcing our 2025 Season 2 Super Users!

A new season of Super Users has arrived, and we are so grateful for…

Paul Stork – Community Spotlight

We are honored to recognize Paul Stork as our July 2025 Community…

Congratulations to the June Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Pages

#1
Lucas001 Profile Picture

Lucas001 60 Super User 2025 Season 2

#2
Fubar Profile Picture

Fubar 55 Super User 2025 Season 2

#3
surya narayanan Profile Picture

surya narayanan 35

Loading complete