Hello PA Community,
New Power Automate user here.
I have tried searching online and on this forum for any advice and guidance in creating a flow to detect duplicate files and delete them from a determined file location such as an external drive, (eventually in a SharePoint document library). There are a lot of tutorials out there that refer to SP lists and records but I am struggling to find anything that is specific to files and folders.
I believe there will be a need for a little more sophistication and wondered if any other users have solved this before and if anyone could point me in the right direction to other solutions.
For any file type (.jpg; .xlxs; .pdf etc). How might PA:
- search a given location (external drive, SharePoint document library)
- analyze for duplicate files by name
- In this example, that would just catch files that are named the same, how would it capture files that were already copied and have the (1), (2), (3) following its name.
- If it finds duplicate names, provide comparison data such as file size, date created, file location (perhaps) to help further determine if its a true duplicate and not just a duplicate by name.
- Move or delete the duplicated file(s) to another location either for review or deletion
I am looking for a little guidance in a good practice for this analysis.
Thanks in advance for any help.
A