Power Platform Community Forum Thread Details

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.