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
Exceldata
List values
Values written to excel
