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

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps - Microsoft Dataverse / Data import creates du...
Power Apps - Microsoft Dataverse
Answered

Data import creates duplicate rows

(0) ShareShare
ReportReport
Posted on by Dereva 8

Hello,

 

I have created a custom table using a data import from an excel with the primary key: Work_Order_#. When I check the table, the initial 1812 rows has ballooned to over 4000 with duplicate rows using the same primary key (i.e. 3 rows for WO1817, 2 rows for WO1819). I thought you couldn't have multiple primary key entries? On top of that, I see that it imported ~80 blank rows.

 

Any help would be appreciated, thanks.

Categories:
Dataflows
Tables
Microsoft Dataverse
Capture.PNG
I have the same question (0)
  • Verified answer
    AhmedSalih Profile Picture
    AhmedSalih 6,678 Moderator on at
    Re: Data import creates duplicate rows

    Hello, @Dereva, your custom table must have an Alternate Key assigned to your Primary Key Column before you run the DataFlow.

     

     

    If my reply helped you, please give a 👍 , & if it solved your issue, please 👍 & Accept it as the Solution to help other community members find it more.


    I am primarily available on weekdays from 6-10 PM CT and 5-10 PM CT on weekends.


    Visit my Blog: www.powerplatformplace.com


     

     

     

  • Fubar Profile Picture
    Fubar 8,319 Super User 2025 Season 2 on at
    Re: Data import creates duplicate rows

    Primary Name field is not a primary key (Primary Name is what gets displayed in Lookup fields and at the top of the a Model Driven App form when you view/edit a record). 

    The true primary key is a generally a system generated GUID (but can be forced to be another unique GUID useing code or when data importing) that is held in a field with the same schema name as your Table with a suffix of "id" e.g. new_mytableid for a Table with a schema name of new_mytable.  You can create your own Alternate Key to enforce uniqueness on other Column(s).  If integrating etc with other systems you would need to either use the actual Primary Key field or an Alternate Key.

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

News and Announcements

Welcome to the Power Platform Communities
Forum hierarchy changes arriving December 5th!
Explore Copilot Studio Forums, Blogs & Galleries!

Quick Links

Coming soon: forum hierarchy changes

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

Chiara Carbone – Community Spotlight

We are honored to recognize Chiara Carbone as our Community Spotlight for November…

Congratulations to the October Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 803 Most Valuable Professional

#2
Michael E. Gernaey Profile Picture

Michael E. Gernaey 314 Super User 2025 Season 2

#3
MS.Ragavendar Profile Picture

MS.Ragavendar 253 Super User 2025 Season 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Microsoft Power Platform Community release plans