Set up automate flow to send only one email if certain conditions are met

Question

I created an automated flow to send an email if certain columns had been modified in a SharePoint list but it sends out multiple duplicate emails. I assume it's sending multiple because of the conditions. How do I set up the flow to only send one email if all or only a few conditions are met?

Example: I have two categories on my SharePoint list, one for home and another for office. If certain columns have been modified for the home category an email would go to a certain person. And if certain columns have been modified for the office category it will go to someone else.

I have four columns - C1 Cleaning Service, C2 Repairs, C3 Pantry Restock, C4 Lawn Care (each column has multiple choice selections but I just need to know if it changed, regardless of the chosen selection). I only want to know when items are modified in C1, C2 and C4. So if I modify/change C1 and C4 only for home, how do I set up the flow to only send one email and not send two emails because both C1 and C4 columns were modified?

Thank you

Answer 1

I did lots of test, due to the trigger is "When an item or a file is modified", even C1 column or C4 column is modified, alert emails will be sent. So, there is no method to only send one email when certain columns are modified in the SharePoint list.

And you could start a new discussion via the Power Automate Community so that you can get dedicated support on this issue.

---

If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.