Repeated email alerts with same details

(0) Share

Report

Posted on by RD-30050915-0

Hi,

I want to ask about the reason I am receiving repeated email alerts from a power automate flow created. Flow is that it will pull data from SQL database. Then it will count the sum of the values (number / quantity) of a certain column and once it is more than a constant (number / quantity), it will create 1 row in a Sharepoint List. When this row is created, it will send an email alert. My problem is that it keeps sending multiple emails containing the same details inside. Can you help me with this?

Thanks,

RIzzalyn

Flow_.pptx

Categories:

Building flows

I have the same question (0)

All responses (6)

Answers (0)

Sort by

Ajlan 237 on at

Like (1)

Report
Copy link

Link copied!

Hello @RD-30050915-0

Could you please add your flow screenshot here to check what's causing this issue.

Regards

Was this reply helpful? Yes No
Suggested answer

MMcCloud 393 Moderator on at

Like (1)

Report
Copy link

Link copied!

Good Morning Rizzalyn,

If you are receiving multiple emails, I would assume the issue is being caused by 1 of 2 things.

Your trigger which is kicking the task off or the way you are formatting the pull for a count.

Based on your wording I am assuming you have the When an Item is Created/Updated for the trigger on a SharePoint List. If this is the case you are getting the message multiple times because it will trigger each time it is updated as the count increases. To fix this I would personally just do a scheduled trigger for a timeframe that fits your business task.

Example: Your database is being updated by transactions from the day before and the SQL Database you are counting constants in is updated overnight at 4AM then schedule your trigger for 5AM to have as up to date as possible. Another option would be to manually trigger the process.

As for the secondary problem that could be occurring: If you are updating the fields and you are sending yourself an email (singular) when the task runs and one task is running but, you are receiving multiple emails its a problem with the way the numbers being passed from your table are working. For example, if its count the number of constants and you already had that constant before meaning there are two occurrences of the same constant with different counts may re-trigger your email based on the "Get Item" from SharePoint information passing 2 items based on your filter.

To fix something like the issue above we are going to probably need more details.

If this solves your issue feel free to choose me as the answer if not drop a reply with more details and I will ensure to follow up with you!

Was this reply helpful? Yes No
RD-30050915-0 8 on at

Like (1)

Report
Copy link

Link copied!

I have attached on the original inquiry. Please help check. Thank you!

Flow_.pptx

Was this reply helpful? Yes No
David_MA 14,404 Super User 2026 Season 1 on at

Like (1)

Report
Copy link

Link copied!

Are you being alerted by your workflow or something else? If it is your workflow, I don't see any e-mail actions in the flow. Please show where in your flow you send the notification. Your flow shows it is scheduled to run every 10 minutes, so please explain the logic in the section that sends the e-mail for when it should and should not be sent. Since the flow runs every 10 minutes, what in your process would eliminate sending the notification again the next time it runs?

Was this reply helpful? Yes No
RD-30050915-0 8 on at

Like (0)

Report
Copy link

Link copied!

Hi ,

Sorry, yes there is another flow to trigger the email alert. i have attached . I was thinking of a rule to stop sending the repeated email notifications only when the details it pulls from SQL such as the "Failed Qty" count is already same/repeating. For example, the first 10 minutes, the "Failed Qty" is 3, then it sends an email since it pass this condition, then the next 10 minutes, the "Failed Qty" is 4, if there is an additional 1 failure, next 10 minutes the "Failed Qty" is 5, so it sends another email. But the problem is that when I check my inbox, it will keep sending the same notification email with "Failed Qty" = 5. I would want to terminate as long there no new Failed Qty.

thanks!

Was this reply helpful? Yes No
David_MA 14,404 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

I think you're trying to say you don't want your second workflow to send a notification when an item is created if the failed quantity equals 0 or is null? If so, you can add a trigger condition that will prevent the flow from triggering.

Based on your screen shot, I think this trigger condition should work: @and(not(empty(triggerBody()?['FailedQTY'])), greater(triggerBody()?['FailedQTY'], 0))

If you don't know what a trigger condition is, you can learn more at Power Automate Trigger Conditions Examples - Enjoy SharePoint

Was this reply helpful? Yes No