Unanswered

When a file is created in SharePoint - Duplicate files problem

(0) Share

Report

Posted on by EM25

Hi, so i got the following problem. We created a flow to extract information from PDF's files that we add to a particular folder in Sharepoint, the trigger for the operation is "When a file is created in a folder (deprecated)" , and it works well, we obtain the info that we need with de AI builder at 96% and we storage in another list.
But the problem comes when we accidentally upload the same file to the folder, i assume that will trigger the process anyways and we will have duplicate info, so i got some questions.

First, There is a way to avoid this to happen? I mean to protect the flow from read the same file.

Or, There is a property in SharePoint to prevent the duplicate upload?

The thing is that i need to create or manage a way to make an error control with duplicated files, cause the PowerAutomate flow works well but that doesn't prevent the human errors. I tried to look up for a solution but i don't find something this puntual so any idea will be useful

Categories:

AI Builder

I have the same question (0)

All responses (2)

Answers (0)

CedrickB Moderator on at

Like (0)

Report

Hi,

If you have a way to link the file name or file id with the entry you have created in the list, you can try to get the list item with below using "Filter Query"

If you found something (the file was already processed), you can skip the rest of the flow.

Was this reply helpful? Yes No
EM25 2 on at

Like (0)

Report

Yes every file had an ID number, so where should i put that option? i mean, after the IA builder read the file and before the flows create new elements in the list of SharePoint? Cause i imagine the fix, but after the ia builder extract the info, what are the changes that i have to do? extract the info, compare the id number with the ones that already exist in the list and what is the option to realize if there is a coincidence end the flow?

Was this reply helpful? Yes No