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 / Compare dataverse rows
Power Apps
Unanswered

Compare dataverse rows

(0) ShareShare
ReportReport
Posted on by 2

I have a table in Dataverse for Teams and I need to compare a cell in another row using a calculated formula field to be able to detect and mark duplicate records.

 

Any Ideas how this can be done? 

 

Thanks

I have the same question (0)
  • Gowri Halan Profile Picture
    262 on at

    @_Luca Could you please give more details please. Looking at the partially understood scenario this might not be possible OOB. but achievable through Pre Validation plugin.

  • _Luca Profile Picture
    2 on at

    I have loaded a excel file into a new DV table with Dataflows. The table has a column of unique references called ID these rows are duplicated due to a 1:N relationship with another column in the excel file. However i want to be able to identify the duplicate ID's and mark them in a separate calculated column so they can be filtered out. E.g. if the original ID column had 150 values but within that there are 70 dupes, I need to be able to identify the other 80 unique values. If ID=2009 was duplicated three times, I would need 2 of these duplicates to be marked in the calculated column and one original to remain unmarked. Thanks.

  • Gowri Halan Profile Picture
    262 on at

    @_Luca You can create a alternate key for the unique identifier attribute to avoid duplicates. To get the duplicate record count. you cannot use calculated fields/rollup field. However if you already loaded and would like to update this field go for code (Dynamics SDK).

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!

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 529 Most Valuable Professional

#2
Haque Profile Picture

Haque 230

#3
Kalathiya Profile Picture

Kalathiya 217 Super User 2026 Season 1

Last 30 days Overall leaderboard