Automatically send an email notification when an item in a sharepoint list has a value of 30, 60, or 90 in a specified column.

Question

Automatically send an email notification when an item in a sharepoint list has a value of 30, 60, or 90 in a specified column.

Answer 1

Hi @bz,

You can integrate a Power Automate with your SharePoint list to achieve this. Here are the steps:

1. Create a flow and select "When an item is created or modified" as trigger.
2. add a condition and set when [column] is equal to 30, 60, or 90.
3. add an action "send an email notification(V3)" under "True".

Hope this answer helps. Please let me if you still have any questions.

---

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.

Answer 2

@bz,

You should modify "AND" to "OR" here:

As per my test, it runs successfully when an item with column value 30, 60 or 90 created or modified.

---

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.