Can flow check for a duplicate file name prior to attempting to add attachment in SharePoint? The problem is if duplicate file already exists in SharePoint flow will not add the file. Turning on versioning in SharePoint is not the answer in this case. I know how to make the file name unique (using flow) by adding the date/time to the name, however, what I would really like to do is first check for a duplicate file name in SharePoint, and then if found, add a time stamp to that file. I could use content organizer in SharePoint but the preferred resolution would be to add a condition in flow to check for duplicate files names and if found add file with a time stamp to make that file unique. Can this be accomplished using flow? Thank you!!
I think your requirement to check for duplicate file name in SharePoint cannot be accomplished in flow so far. As you can see, in the condition, there is no such related relationship options:
You could post this idea in the Flow Ideas forum, so it might be considered for future releases.
Mona, Thank you! I have submitted the idea request. I also have additional questions, that I'm hoping you may be able to shed some light on ...
Because the solution above is not yet available using flow I decided to use the Content Organizer feature in SharePoint to flag duplicate files with unique ID's. However the problem I ran into is it that the files will move to the drop box but waits for the 'Edit Properties' command and the 'Submit' command to be invoked. Based on my research it looks like a timer job delays this process. I can manually select those commands and the files move to the destination library, however I'm trying to prevent user intervention and my concern is if they are waiting on the timer job duplicate files will be overlaid. From my understanding this timer job is scheduled to run daily, however I would like the files to be moved as soon as they hit the drop off library. Do you know if it's possible to have flow complete these steps? If not, then perhaps I check to see if SharePoint Designer can complete these steps.