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

Notifications

Announcements

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,368 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,368 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,368 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

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Pages

#1
Fubar Profile Picture

Fubar 74 Super User 2025 Season 2

#2
Jerry-IN Profile Picture

Jerry-IN 55

#3
sannavajjala87 Profile Picture

sannavajjala87 31

Last 30 days Overall leaderboard