Skip to main content

Notifications

Community site session details

Community site session details

Session Id : x1HllpvISfxh36lP6kQBnI
Power Automate - Building Flows
Unanswered

Remove duplicate rows in Excel based on multiple columns

Like (0) ShareShare
ReportReport
Posted on 5 Mar 2024 23:56:38 by 21

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.

 

duplicatetable.PNG

  • takolota1 Profile Picture
    4,863 Super User 2025 Season 1 on 06 Mar 2024 at 05:26:07
    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

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Announcing the Engage with the Community forum!

This forum is your space to connect, share, and grow!

🌸 Community Spring Festival 2025 Challenge Winners! 🌸

Congratulations to all our community participants!

Warren Belz – Community Spotlight

We are honored to recognize Warren Belz as our May 2025 Community…

Leaderboard > Power Automate - Building Flows

#1
David_MA Profile Picture

David_MA 368 Super User 2025 Season 1

#2
Michael E. Gernaey Profile Picture

Michael E. Gernaey 300 Super User 2025 Season 1

#3
stampcoin Profile Picture

stampcoin 299

Overall leaderboard
Loading started