How to Stop SharePoint Files and Emails from Being Duplicated
Question details
Users need to stop duplicate files and repeated confirmation emails from being generated when uploading files to SharePoint sites.

- Product
- SharePoint Online / Power Automate
- Device & OS
- not provided
- Scenario
- Uploading multiple files together to a SharePoint Online site utilizing a Power Automate flow for copying and notifications.
- Observed behavior
- Duplicate files are created and multiple confirmation emails are sent out despite users uploading each file only once.
Ensure you have owner or edit permissions for the Power Automate flow and the corresponding SharePoint sites to review and modify the workflow settings.
Review Power Automate Flow Triggers and Concurrency
Troubleshoot and fix duplicate triggers or concurrency issues in your Power Automate flow that are causing the duplicate files and emails.
A custom Power Automate flow can inadvertently run multiple times for a single file upload if the triggers are too broad or if multiple files uploaded simultaneously cause race conditions.
Log in to Microsoft Power Automate, navigate to 'My flows', and open the specific flow responsible for copying files between your SharePoint sites.
Check your starting trigger. Ensure the flow is not set to trigger unnecessarily on both 'When a file is created' and 'When a file is modified'. If the system modifies file metadata right after creation, it can trigger the flow twice.
Click the ellipsis (...) on your trigger action and select 'Settings'. Turn on 'Concurrency Control' and lower the 'Degree of parallelism' to limit parallel runs, preventing conflicts when several files are uploaded together.
Before the 'Copy File' and 'Send an email' actions, add a 'Get file metadata' action and a condition block to verify if the file already exists in the destination site, preventing duplicate copying.

Verify the File Upload Method in SharePoint
Determine if the method users are using to upload files is inadvertently triggering the workflow multiple times.
Consult the Microsoft Power Automate Community
Seek expert help for complex custom flows from the official Microsoft Power Automate community forums.
Try WPS Office for Seamless Document Management
While troubleshooting complex SharePoint and Power Automate workflows, consider WPS Office for your daily document creation and editing needs. It is a free, lightweight, and highly compatible alternative to Microsoft Office, offering an intuitive interface and seamless migration.
- 1. Download WPS Office: Visit the official WPS website and download the free installation package for your operating system.
- 2. Install the software: Run the installer and follow the simple on-screen instructions to set up WPS Office on your device.
- 3. Open and save files seamlessly: Open your existing Microsoft Office documents in WPS Office and save them directly in their native formats to ensure perfect compatibility with your team.

Frequently Asked Questions
Why does my Power Automate flow trigger multiple times for one SharePoint upload?
This usually happens if the trigger is set to 'When a file is created or modified' and SharePoint automatically updates the file's metadata immediately after creation, causing a second run. It can also happen when uploading multiple files at once without concurrency limits set in the flow.
Can dragging and dropping files into SharePoint cause duplicate workflows?
Yes, depending on how the browser and SharePoint process background file creation requests, dragging multiple files can trigger individual flows simultaneously. This can lead to race conditions and duplication in custom Power Automate flows that aren't configured to handle concurrent runs.
How do I prevent Power Automate from sending repeated confirmation emails?
You can prevent this by adding a delay or a batching process in your flow. Alternatively, set a specific metadata flag (like an 'Email Sent' column) to 'Yes' after the first email is sent, and configure your trigger conditions to ignore files where this flag is already set to 'Yes'.




