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

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Pages / Duplicate records busi...
Power Pages
Unanswered

Duplicate records business rule for PowerApps Portal

(0) ShareShare
ReportReport
Posted on by 175

Hello,

How can I restrict dding duplicate records in CDS entity for PowerApps Portal?

Can I set some business rule for respective entity?

Categories:
I have the same question (0)
  • oliver.rodrigues Profile Picture
    9,453 Most Valuable Professional on at

    Hi

     

    you can create an alternate key which would make your record unique based on an existing attribute: https://docs.microsoft.com/en-us/powerapps/maker/common-data-service/define-alternate-keys-portal

     

    ------------

    If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.

  • Dhananjay_Patil Profile Picture
    175 on at

    Hello @OliverRodrigues 

    I had created one entity : UserMaster with two fields firstName and LastName

    I also created alternate key with these both fields, then I added first records its added successfully 

    But when I added second record with same value/string, not getting any error for duplicate values

  • oliver.rodrigues Profile Picture
    9,453 Most Valuable Professional on at

    Can you try creating the duplicate record via Model-Driven App?

    perhaps it's missing a publish or something

  • Dhananjay_Patil Profile Picture
    175 on at

    Hello @OliverRodrigues 

    I am working on Portal application only, I did not checked in model driven application

    Can you please support to restrict duplicates in PowerApps Portal

  • oliver.rodrigues Profile Picture
    9,453 Most Valuable Professional on at

    the alternate key should apply for both model-driven app and Portal --> this is because it happens at the CDS level

    I am asking you to test via Model-Driven App to make sure your key is working properly

     

    that's easy enough to test, go to make.powerapps.com --> apps --> Portal Management --> Advanced Find and locate your entity then create a new record

    advfind.PNG

    you can also get there via solution --> make.powerapps.com --> solutions --> your solution --> your entity --> data --> new record

     

    if you are able to create duplicate records it means there is something wrong with the key

    also, note that if you already have duplicated record in your CDS, the key won't activate, first delete any duplicates and try publishing the key again

     

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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Users!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Congratulations to the March Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Pages

#1
rezarizvii Profile Picture

rezarizvii 53

#2
DP_Prabh Profile Picture

DP_Prabh 40

#3
oliver.rodrigues Profile Picture

oliver.rodrigues 28 Most Valuable Professional

Last 30 days Overall leaderboard