Answered

Submit a file but became duplicate or more in SharePoint Documents folder

(0) Share

Report

Posted on by PaulineTCL

I have workflow where staff can submit the file by drag and drop in a Document folder in SharePoint, in this case SP-Staff.

This will trigger a workflow where the file will be copied to another Document folder in another SP site, SP-Admin. At the same time, an email will be sent out to the staff that the file has been received by Admin.

However, sometime, the file dropped by the staff became duplicate or more, sometime up to 4, 5 duplicates. And, emails will be sent out few times also. This mostly happened when the staff drag and drop few files together.

I would like to know why did this happen? And, how to solve this issue?

Thanks

Pauline

Categories:

Using flows

I have the same question (0)

All responses (10)

Answers (1)

Sort by

Rhiassuring 8,692 Moderator on at

Like (0)

Report
Copy link

Link copied!

Are you able to s how us the configuration of your flow? My guess is that you've got an Apply To Each that's duplicating, but of course I'd need to see it to tell you.

Was this reply helpful? Yes No
PaulineTCL 31 on at

Like (0)

Report
Copy link

Link copied!

Hi
Following is my flow:

Flow ends after the 'Delete File'.

Was this reply helpful? Yes No
Rhiassuring 8,692 Moderator on at

Like (0)

Report
Copy link

Link copied!

Thank you!

Do you have any Filter Query on your "Get Files (properties only)"?

Was this reply helpful? Yes No
PaulineTCL 31 on at

Like (0)

Report
Copy link

Link copied!

Hi

This is my Get Files (properties only). 'Filter Query' I didn't put any entry.

Was this reply helpful? Yes No
Rhiassuring 8,692 Moderator on at

Like (0)

Report
Copy link

Link copied!

Okay.

So, if your staff drag & drop multiple files, when it hits the "Get Items", it is going to find every file that came at the same time - not just the one. Your trigger is "When a file is created", so it would trigger for each any every one of these.

The solution: use Filter Query to filter on the filename in your Get Files (Properties Only). Then it will only pick up the one file it has triggered on.

Was this reply helpful? Yes No
PaulineTCL 31 on at

Like (0)

Report
Copy link

Link copied!

Hi
Is it like this:

Was this reply helpful? Yes No
Rhiassuring 8,692 Moderator on at

Like (0)

Report
Copy link

Link copied!

Close! Filter Query: FileLeafRef eq 'FileNameDynamicContent'

(Where FileNameDynamicContent is the same as what you have in y our screenshot)

Was this reply helpful? Yes No
PaulineTCL 31 on at

Like (0)

Report
Copy link

Link copied!

Hi
There was error after I added the Filter Query and tested it.

I tested by dragging 3 files together and none of the files passed the flow at 'Get Properties'. Tried also just dragged 1 file (other file), same error.

I will copy the flow and do the test again later, as I need to ensure office operations not interrupted for now.

Thanks

Was this reply helpful? Yes No
Verified answer

v-jefferni Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi @PaulineTCL ,

Have you solved this issue? If not yet, please try and use another output from the trigger for the filter query:

Best regards,

Was this reply helpful? Yes No
PaulineTCL 31 on at

Like (0)

Report
Copy link

Link copied!

Hi Jeffer Ni

Sorry for trying out after 2 months of your reply.
May I know, for the 'When a file is created' [the one I used in my flow], do I need to change to 'When a file is created in a folder' as you have shown in your reply above?
I couldn't get the 'x-ms-file-name-encoded' from the 'Add dynamic content'. I can only see the few options as shown below.

Last 2 weeks, only ONE of my staff having problems where 2 files which he uploaded once in mid of September, these 2 files 'auto-uploaded' itself few times in a day and after 1-2 days, again it 'auto-uploaded'. Not sure what happened. And, only those 2 files.

Was this reply helpful? Yes No