I am having an issue sending email notifications when the item has been modified. I have an SP online list of two columns. The first column is a choice field called job status and has In-Progress and Completed options. The second column is multiple lines of text called comments.
When the job status columns field change from in-progress to completed the creator will receive the notification that your job has been completed.
My issue is the Marketing team wants to go back to the list and add some comments even after the job status has been changed to complete. And the moment they add some words, the creator will receive another email about the job status that has been changed to complete.
Would you please help me to make sure the email is only sent once? I am using SP online, and Power automate.