Power Platform Community Forum Thread Details

Good Morning Experts

I really need some help. I have built a flow that's main purpose is to send a single email when the status of a column in a Microsoft List has been updated to a certain value. I have been through a number of examples to make sure that it only sends a single email when the flow is triggered. That seems to work fine. The problem that I am is that when the column is updated again, not only does it send the new email but it also sends the previous emails again. I have added in a column called EmailStatus and this is updated with a Sent when the initial email is sent. I have then tried to configure conditions at multiple places in the flow to limit what is sent based on the email status column but no matter what I do, it always seems to send multiple emails.

This is what is happening in summary:

Microsoft List is updated with "Approved".

This triggers and email to be sent to the owner of that row in the Microsoft List.

Another item in the Microsoft List is updated with "Approved".

This triggers the flow again and the new email is sent.

Another email is also sent with the information from the previous update.

It basically means that once a column has the Approved status in it, it will continue to send the email. Below are some screen shots from the flow that I have created:

Below is the initial trigger that then gets items: