Remove duplicate rows in Excel based on multiple columns

Like (0) Share

Report

Posted on 5 Mar 2024 23:56:38 by ontheclock

I have a Flow that is connected to a sharepoint list and adds rows into an Excel table depending on the leave dates entered. As staff may enter multiple leave dates, I want to ensure the table in Excel doesn't contain any duplicates rows.

I need to create a flow that checks the rows in Excel table and identifies duplicates by looking at the Staff Member column and Leave Date column. If a staff member has more than 1 row with the same leave date, I would like PA to delete the earliest row(s) (as the latest row added should be the most accurate) until only 1 row with that date and staff member is left.

I will run this flow as a scheduled trigger every 30 minutes to continually clean the data being entered.

I have had a look online but found nothing in relation to this, only support to do this in Power Query (which I don't want to do). Any support is appreciated or links to resources.

All responses (1)

Answers (0)

takolota1 4,859 Super User 2025 Season 1 on 06 Mar 2024 at 05:26:07

Like (0)

Report

Re: Remove duplicate rows in Excel based on multiple columns

@ontheclock

This template allows you to list any columns in the Select input to check for duplicates & you can control which are marked as duplicates based on the sorting you apply to the data.

You will just have to replace the SharePoint actions with Excel actions.

https://powerusers.microsoft.com/t5/Power-Automate-Cookbook/Find-and-Remove-Duplicates/td-p/2191403