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 Apps / Dataverse table has mu...
Power Apps
Answered

Dataverse table has multiple unique records

(0) ShareShare
ReportReport
Posted on by 6

Greetings, 

I have a Dataverse table that is producing multiple records for each unique record. This is happening due to a system generated column called versionnumber. The multiple records are showing up in my canvas app. Any one struck this before and know how to fix? Many thanks.

scottmcqueen_0-1636678790497.png

 

I have the same question (0)
  • Verified answer
    Ram Prakash Duraisamy Profile Picture
    5,785 Super User 2026 Season 1 on at

    Hello @scottmcqueen,

     

    Please enable Duplicate Detection Rules for this Table, so that when an User Tries to create a same record it will throw an popup for the same.

     

    For Enabling Duplicate Detection Rules

     

    1. Navigate to https://make.powerapps.com

    2. Click on Gear icon at the top 

    3. Click Advance Settings

    4. Click Data Management then Duplicate Detection Rules

    5. Enter the Rules over there

     

    Please mark as Answer if it is helpful and provide Kudos


    Subscribe : https://www.youtube.com/channel/UCnGNN3hdlKBOr6PXotskNLA
    Blog : https://microsoftcrmtechie.blogspot.com

  • scottmcqueen Profile Picture
    6 on at

    Thanks @rampprakash 

    I found that my duplicates are being created each time my Dataflow refreshes. I want the data to be updated by the refresh process, so I'm not sure how the duplicate detection will handle that? 

  • Ram Prakash Duraisamy Profile Picture
    5,785 Super User 2026 Season 1 on at

    Hello @scottmcqueen,

     

    If that is the case, we cannot handle this in Duplicate detection, we need to write some custom code via plugins to avoid the same.

     

    Please mark as Answer if it is helpful and provide Kudos

     

     

    Subscribe : https://www.youtube.com/channel/UCnGNN3hdlKBOr6PXotskNLA

    Blog : https://microsoftcrmtechie.blogspot.com

     

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 April Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Apps

#1
Vish WR Profile Picture

Vish WR 1,074

#2
Valantis Profile Picture

Valantis 639

#3
11manish Profile Picture

11manish 606

Last 30 days Overall leaderboard