cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
scottmcqueen
Frequent Visitor

Dataverse table has multiple unique records

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

 

1 ACCEPTED SOLUTION

Accepted Solutions
rampprakash
Super User
Super User

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

View solution in original post

3 REPLIES 3
rampprakash
Super User
Super User

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

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? 

rampprakash
Super User
Super User

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

 

Helpful resources

Announcements
Power Platform Call June 2022 768x460.png

Power Platform Community Call

Join us for the next call on August 17, 2022 at 8am PDT.

Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

Users online (4,271)