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

Notifications

Announcements

Community site session details

Community site session details

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

Flow to send emails based on Excel is sending duplicates

(0) ShareShare
ReportReport
Posted on by 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

 

Categories:
I have the same question (0)

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

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 522 Super User 2025 Season 2

#2
Tomac Profile Picture

Tomac 364 Moderator

#3
abm abm Profile Picture

abm abm 243 Most Valuable Professional

Last 30 days Overall leaderboard