This video details how with the Encodian Flowr connector for Power Automate we can automatically detect and remove duplicates from an Excel file (or CSV file).
Reference Actions:
Get Rows from Excel - https://support.encodian.com/hc/en-gb...
Utility - Array Remove Duplicates - https://support.encodian.com/hc/en-gb...
Convert JSON to Excel - https://support.encodian.com/hc/en-gb...
Delete Rows from Excel - https://support.encodian.com/hc/en-gb...
Add Rows to Excel - https://support.encodian.com/hc/en-gb...