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...


The result being items like this:

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