How to remove duplicate rows from a table with an automation?

1

I know I can filter a table for duplicates with Table.Filter(Column.Contains(thisrow.Column).Count()>1

Is there a way to do this in automation? I’m trying to get a automation to find duplicate values in a table, modify the most recent one, and then delete all the others.

Any tips?

2

Hey @Phil_Young! I’d recommend creating a button that finds and deletes duplicate rows (check out this community post for steps on that), then set an automation that pushes that button at whatever time interval you’d like (e.g. every week).
Hope that helps :smile: