web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id : Gs991ZvhWk820yE/7JCTU1
Power Automate - Using Flows
Answered

Duplicate Emails Sent in SharePoint List Item Flow

Like (1) ShareShare
ReportReport
Posted on 27 Oct 2023 13:10:12 by 29

Hello Power Automate Community,

I am experiencing an issue with a flow I created intended to automate emails based on SharePoint (SP) List items. I'd appreciate any guidance or suggestions you can provide. Here are the specifics:

 

My Objective:
I have set up a flow that should:
1. Identify items in a SharePoint list with the status 'Open' and related to a specific project named "Other."
2. Send a weekly email to an 'Observer' assigned to each of these items.

Screenshot 2023-10-27 at 4.03.10 PM.png

Issue:
The flow is functional but is sending duplicate emails for each item. For three test items, instead of receiving three separate emails, I received six - each duplicate being identical to the original.

 

Flow Setup:
1. The trigger is set to the appropriate SharePoint List.
2. Using 'Get items' to retrieve items with 'Open' status related to the "Other" project.
3. A condition checks if the items retrieved meet the criteria.
4. If 'Yes', an email is sent to the 'Observer.'

Screenshot 2023-10-27 at 4.06.44 PM.png Screenshot 2023-10-27 at 4.07.46 PM.png

 

Attempts to Resolve:
I have reviewed the flow steps and configurations, and there doesn't appear to be any loops or additional steps that would cause the duplicate emails. All conditions and actions seem correctly aligned with the objectives.

I would greatly appreciate it if anyone could shed light on why the system might be sending these duplicate emails and how I might resolve this issue. Are there known causes for such behavior, or perhaps is there a configuration setting I might have overlooked?

If needed, I can provide additional details or screenshots of the flow setup for a more in-depth analysis.

Thank you in advance for your time and assistance!

Best regards,
Arman

  • Verified answer
    kuspaar Profile Picture
    29 on 27 Oct 2023 at 13:33:15
    Re: Duplicate Emails Sent in SharePoint List Item Flow

    The issue has been resolved. I discovered that the reason I was receiving duplicate emails was due to the specific configuration in my list settings. The list contained a column for an 'Observer' (the responsible person), and the system was retrieving the observer's email. This caused duplicates because, in the 'To' section of the email action, I initially referred not to the "Observer" column but to the observer's email directly. Once I corrected this reference, the flow worked as intended, sending only one notification email per item. The problem is now solved. Thank you for your assistance.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Announcing our 2025 Season 2 Super Users!

A new season of Super Users has arrived, and we are so grateful for…

Paul Stork – Community Spotlight

We are honored to recognize Paul Stork as our July 2025 Community…

Congratulations to the June Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 497 Super User 2025 Season 2

#2
David_MA Profile Picture

David_MA 436 Super User 2025 Season 2

#3
Riyaz_riz11 Profile Picture

Riyaz_riz11 244 Super User 2025 Season 2

Featured topics

Restore a deleted flow