Skip to main content

Notifications

Announcements

No record found.

Dynamics 365 Community / Forums / Sales forum / Duplicates record from...
Sales forum
Answered

Duplicates record from Power automate flow

Posted on by 10

Hi community, 

Happy new year, 

I have a periodic Power automate flow which insert data in Dynamics 365. 

I have two duplicate rules but I have more than 20.000 duplicates in my table. 

Have you a suggestion how can I prevent this ? Have you a filter that I must add in my flow ? 

Can I delete all duplicators in the system ? 

Thank you for your help 

  • Verified answer
    Mohamed GRAIB Profile Picture
    Mohamed GRAIB 2,498 Super User 2024 Season 2 on at
    RE: Duplicates record from Power automate flow

    Please follow this link

    community.dynamics.com/.../how-can-i-remove-duplicates-in-dynamics-crm

    Hope that's helpful for you

  • MAROUA AY Profile Picture
    MAROUA AY 10 on at
    RE: Duplicates record from Power automate flow

    Thank you very much for this suggestion Mohamed GRAIB

    Have you a solution how can I delete all duplicates records please ?

  • Suggested answer
    Bipin D365 Profile Picture
    Bipin D365 28,962 Moderator on at
    RE: Duplicates record from Power automate flow

    Hi,

    Alternate key can be configured to avoid duplicates

    learn.microsoft.com/.../define-alternate-keys-reference-records

    Duplicate detection jobs can be created to detect duplicate records and delete them.

    learn.microsoft.com/.../run-bulk-system-jobs-detect-duplicate-records

  • Verified answer
    Mohamed GRAIB Profile Picture
    Mohamed GRAIB 2,498 Super User 2024 Season 2 on at
    RE: Duplicates record from Power automate flow

    Hi Maroua,

    I suggest that you create a Key from make.powerapps.com

    You must just navigate to your table, Then add a new key 

    pastedimage1672663015880v1.png

    This solution will prevent the creation of duplicates records. 

    Hope that's helpful for you. 

    Please mark the answer as verified if that's helpful for you. 

Helpful resources

Quick Links

Dynamics 365 Community Update – Sep 9th

Welcome to the next edition of the Community Platform Update. This is a weekly…

Announcing Our 2024 Season 2 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 290,339 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 228,177 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans