Skip to main content

Notifications

Community site session details

Community site session details

Session Id :
Power Automate - Using Flows
Answered

Duplicate Emails Sent in SharePoint List Item Flow

(1) ShareShare
ReportReport
Posted on 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 at
    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

Understanding Microsoft Agents - Introductory Session

Confused about how agents work across the Microsoft ecosystem? Register today!

Markus Franz – Community Spotlight

We are honored to recognize Markus Franz as our April 2025 Community…

Kudos to the March Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 146,708 Most Valuable Professional

#2
RandyHayes Profile Picture

RandyHayes 76,287 Super User 2024 Season 1

#3
Pstork1 Profile Picture

Pstork1 66,030 Most Valuable Professional

Leaderboard

Featured topics

Restore a deleted flow