Remove duplicate items from list - Data copied from Excel table

Like (0) Share

Report

Posted on 23 Feb 2022 08:02:07 by Anurag_R

Hi,

I am trying to fetch data from the excel sheet, add them to a new list and remove duplicates from the list. However, when using the action- "Remove duplicate items from list" the flow is not able to capture or remove the duplicate values from the list created.

Because of this, when I am writing the data present in the list into the excel sheet, the same values are captured (with duplicates).

I have followed same instructions as suggested in a similar post- https://powerusers.microsoft.com/t5/Power-Automate-Desktop/Removing-duplicate-records-in-datatable/td-p/849155

Sharing the screenshots for reference. Could anyone please help how to remove the duplicates?

Thanks.

Flow FlowExceldataList valuesValues written to excel

All responses (4)

Answers (1)

Anurag_R 25 on 24 Feb 2022 at 07:59:12

Like (0)

Report

Re: Remove duplicate items from list - Data copied from Excel table

Hi @MichaelAnnis thanks for your suggestion. I was able to implement the 2nd suggestion since it is more reliable.
Anurag_R 25 on 24 Feb 2022 at 07:57:20

Like (0)

Report

Re: Remove duplicate items from list - Data copied from Excel table

Thanks @Highboy your suggestion worked. I am able to remove the duplicates. 😀
Verified answer

Highboy 1,161 Super User 2024 Season 1 on 23 Feb 2022 at 10:04:13

Like (1)

Report

Re: Remove duplicate items from list - Data copied from Excel table

This works for me

Before removal of dublicates
After removal of dublicates
New list in column B
MichaelAnnis 5,721 Super User 2025 Season 1 on 23 Feb 2022 at 08:25:29

Like (0)

Report

Re: Remove duplicate items from list - Data copied from Excel table

Use the UI elements or send keys to use Excel’s feature to remove Duplicates before importing.