Skip to main content

Notifications

Community site session details

Community site session details

Session Id :
Power Apps - Microsoft Dataverse
Unanswered

Excel Import duplication

(0) ShareShare
ReportReport
Posted on by 124

I imported some fields in dataverse and its creating duplicated records daily for some reason. any idea how to fix it?

  • Jonathan Manrique Profile Picture
    2,678 on at
    Re: Excel Import duplication

    Hi @Sean9 

     

    You must review whether there are any system operations, or the currents that you are using are accidental because at the moment you are importing the form you cannot duplicate

     

    If I have answered your question, please mark your post as Solved.
    If you like my response, please give it a Thumbs Up.
    You can accept more than one post as a solution

  • Sean9 Profile Picture
    124 on at
    Re: Excel Import duplication

    It seems that they are duplicating based on a scheduling job

    Sean9_0-1702550312987.png

     

  • Jonathan Manrique Profile Picture
    2,678 on at
    Re: Excel Import duplication

    Hi @Sean9 

     

    When we import data into a table through an Excel file there is an option to not allow duplicates, but this will depend on the GUID, or if you have keys that do not allow duplicate values.

     

    On the other hand, if I can understand what you are saying, it is that after the import new records were created, and this is only possible if the duplication is not being validated as I mentioned above, or if there is a background process that is creating records within of your table, call it a Workflow or a Power Automate.

     

    Jmanriquerios_0-1702073280584.png

     

    But it is most likely associated with the way you are importing the data.

     

    If you want to avoid duplicate data, using a key is a way to protect data duplication depending on your structure, for example a combination of two fields that makes that value unique.

     

    Another way is that you can create rules to stop duplicates, but this does not work when we import data, only when we create it manually

     

    If I have answered your question, please mark your post as Solved.
    If you like my response, please give it a Thumbs Up.
    You can accept more than one post as a solution

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

Announcing the Engage with the Community forum!

This forum is your space to connect, share, and grow!

🌸 Community Spring Festival 2025 Challenge Winners! 🌸

Congratulations to all our community participants!

Warren Belz – Community Spotlight

We are honored to recognize Warren Belz as our May 2025 Community…

Leaderboard > Power Apps - Microsoft Dataverse

#1
mmbr1606 Profile Picture

mmbr1606 22 Super User 2025 Season 1

#2
stampcoin Profile Picture

stampcoin 17

#3
ankit_singhal Profile Picture

ankit_singhal 11 Super User 2025 Season 1

Overall leaderboard

Featured topics