Skip to main content



No record found.

Dynamics 365 Community / Forums / Sales forum / How to Eliminate dupli...
Sales forum
Suggested answer

How to Eliminate duplicate items using power automate ?

(1) ShareShare
Posted on by 354
Hi All,
I have a requirement, where I need to find the duplicate contact from dynamics and need to send the list of duplicate contacts to user.
All I have done, through the logic like first I have sort the output of list rows and then comparing(email column) second row to first and third to second and fourth to third and so on. So like this I got Unique and Duplicate contacts list.
But issue is that, Like I need to the all duplicate itmes inside the duplicate list but here it is giving one item in unique list and rest of the duplicate item in duplicate list.
for example: Array=[A,A,A,B,B,C,C,D,E] then  it is giving
Unique Array=[A,B,C,D,E]
Duplicate Array=[A,A,B,C]
But It should be 
Duplicate Array =[A,A,A,B,B,C,C]
Unique Array=[D,E]
Can someone please suggest me a way to achieve this ?
  • Suggested answer
    Leah Ju Profile Picture
    Leah Ju Microsoft Employee on at
    How to Eliminate duplicate items using power automate ?
    Hi Partner,
    You can just use two nested 'List rows' steps to achieve the purpose.
    Please refer to the following steps:
    1.List rows:
    Note: click “Settings”, activate “Pagination” and set the “Threshold” to the maximum allowed value of 100,000. If you don’t take this step, your Flow will only check 512 records by default and probably won’t catch all of your duplicates.
    2.Variabe to store the number of return contacts


    4.Update 'isduplicate' flag of the contact:

    Then you can use this flag to specify records are duplicate or unique.
    More information:

    I hope you can mark my answer verified if it is helpful! If you have any questions, please feel free to contact me.

Helpful resources

Quick Links

Community Spotlight of the Month

Kudos to Mohamed Amine Mahmoudi!

Blog subscriptions now enabled!

Follow your favorite blogs

TechTalk: How Dataverse and Microsoft Fabric powers ...

Explore the latest advancements in data export and integration within ...


André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 284,876 Super User

Martin Dráb Profile Picture

Martin Dráb 225,425 Super User

nmaenpaa Profile Picture

nmaenpaa 101,146


Featured topics

Product updates

Dynamics 365 release plans