Answered

Remove duplicate items from list - Data copied from Excel table

(0) Share

Report

Posted on 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

Categories:

Power Automate Desktop

I have the same question (0)

All responses (4)

Answers (1)

MichaelAnnis 5,727 Moderator on at

Like (0)

Report

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

Was this reply helpful? Yes No
Verified answer

Highboy 1,183 Super User 2024 Season 1 on at

Like (1)

Report

This works for me

Before removal of dublicates
After removal of dublicates
New list in column B

Was this reply helpful? Yes No
Anurag_R 25 on at

Like (0)

Report

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

Was this reply helpful? Yes No
Anurag_R 25 on at

Like (0)

Report

Hi @MichaelAnnis thanks for your suggestion. I was able to implement the 2nd suggestion since it is more reliable.

Was this reply helpful? Yes No