Skip to main content
News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate - Building Flows / Flow to send emails ba...
Power Automate - Building Flows
Unanswered

Flow to send emails based on Excel is sending duplicates

(0) ShareShare
ReportReport
Posted on by PaulHet 6

Hi,

 

I'm new to Power Automate and have read a number of articles to try to address my problem, and i'm now almost resolved - other than for some reason my data is triggering twice instead of just once...!

 

My Use Case is we have a table in excel to track action items, I want to generate automated emails for when actions are overdue. I have a field in excel to calculate if it is overdue or not, so I just want to filter the table to get overdue items and then email each item owner with the details of their action. This is currently working, however it consistently is sending two emails per item instead of one... 

 

PaulHet_0-1643736056213.png

PaulHet_2-1643736098169.png

The result being items like this:

 

PaulHet_5-1643736252481.png

 

This is my full JSON:

{
    "type": "array",
    "items": {
        "type": "object",
        "properties": {
            "@@odata.etag": {
                "type": "string"
            },
            "ItemInternalId": {
                "type": "string"
            },
            "Action ID": {
                "type": "string"
            },
            "Opened on": {
                "type": "string"
            },
            "Action Description": {
                "type": "string"
            },
            "Action Assigned to": {
                "type": "string"
            },
            "Required Completion Date": {
                "type": "string"
            },
            "Aging (days)": {
                "type": "string"
            },
            "Overdue?": {
                "type": "string"
            },
            "Update Due Date": {
                "type": "string"
            },
            "Action log (comments)": {
                "type": "string"
            },
            "Risk ID (If applicable)": {
                "type": "string"
            },
            "Status": {
                "type": "string"
            }
        },
        "required": [
            "@@odata.etag",
            "ItemInternalId",
            "Action ID",
            "Opened on",
            "Action Description",
            "Action Assigned to",
            "Required Completion Date",
            "Aging (days)",
            "Overdue?",
            "Update Due Date",
            "Action log (comments)",
            "Risk ID (If applicable)",
            "Status"
        ]
    }
}

 

Does anyone know why this would be the case? It's like it's applying the 'apply to each' twice instead of once

 

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

News and Announcements

Now Available: 2025 Release Wave 2
Welcome to the Power Platform Communities

Quick Links

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!

Announcing the Engage with the Community forum!

This forum is your space to connect, share, and grow!

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 497 Super User 2025 Season 1

#2
David_MA Profile Picture

David_MA 436 Super User 2025 Season 1

#3
Riyaz_riz11 Profile Picture

Riyaz_riz11 244 Super User 2025 Season 1

Last month Overall leaderboard

Featured topics

Start and wait for an approval action

Product updates

Microsoft Power Platform Community release plans