
All,
I want a Power Automate to check an Excel file everyday at midnight (when no one else is using it) I want it to look for duplicates in Col A (Its where a project number is stored and it should be unique) and IF it finds duplicates then it sends me an email that duplicates are found and lists the numbers in the email body
How can I set this up?
To assist: I know how to setup schedule flow and I my idea to find duplicate was to use Conditional Formatting --> Duplicates. Then filter for the specific colour