sending an email based on an item being modified

(0) Share

Report

Posted on by BT-06031656-0

I set up the following flow:

Trigger: When an item or a file is modified in a sharepoint list

Condition: Estimated Arrival date is not equal to empty

Update an item: update the status field for that item to Ordered

Send an email: to the creator of the item that their order has been placed.

I set it to check for items every 15 seconds.

The problem is that every 15 seconds, the same email gets sent again. The flow seems to think that it's being modified again and again. How do I change this?

Categories:

Building flows

I have the same question (0)

All responses (5)

Answers (0)

BB-18031745-0 45 on at

Like (0)

Report

Could you share a screenshot of how you're getting it to check every 15 seconds?

Was this reply helpful? Yes No
creativeopinion 10,502 Super User 2025 Season 2 on at

Like (1)

Report

@BT-06031656-0 When using automated triggers in your flow it's always best practice to add trigger conditions. This prevents the flow from triggering each time an item or file is modified (in your case). When you set a trigger condition, the flow will only trigger when the criteria is met. In your case, you need a trigger condition to check whether the Arrival Date is not empty.

However, to prevent from your flow triggering again after the Arrival Date has been filled and the email has been sent you should create a column that marks whether an email has been sent. Adjust your trigger condition to check for if the Arrival Date is not empty and if the email has not been sent.

4 Ways You Can Use Trigger Conditions in Your Microsoft Power Automate Flow

Trigger conditions can be set in most flow triggers. These conditions you set must be true for the trigger to fire.

In this Power Automate tutorial, I’m going to show you how to use trigger conditions in your flows to control when your Power Automate flows trigger. If your plan has flow run limits—you can avoid triggering your flows unnecessarily by using trigger conditions.

I’ll cover four different flow examples that would benefit from trigger conditions:

⚡️ Triggering a flow when a column is changed to a specific value
⚡️ Triggering a Flow When an Event Updated or Deleted
⚡️ Triggering a Flow When a New Folder is Created
⚡️ Triggering a Flow When a Specific Email is Received

I’ll also show you a trick on how to easily create the expressions needed and give you a few tips on how to troubleshoot your flow.

IN THIS VIDEO:

✓ Four different flows that would benefit from trigger conditions

✓ What is a trigger condition?

✓ How to add a trigger condition to your flow

✓ How to trigger a flow when a column is changed to a specific value

✓ How to trigger a flow when an event is updated or Deleted

✓ How to trigger a flow when a new folder is created

✓ How to trigger a flow when a specific email is received

✓ How to troubleshoot a trigger condition

✓ How to prevent case sensitivity issues with a trigger condition

✓ How to use the filter array action to easily compose an expression that can be used in a trigger condition

If you still run into issues while building your flow, share screenshots of your full flow and the logic behind it.
Upload a screenshot of your flow in edit mode. If you are using the new designer, toggle it off and click each action to expand it.

Hope this helps!

Consider giving me a ❤️ if you liked my response!

👉 Level up your Power Automate skills by checking out my tutorials on YouTube
👉 Tips and Tricks on TikTok and Instagram

Was this reply helpful? Yes No
BT-06031656-0 10 on at

Like (0)

Report

When I add the condition @equals(@{triggerBody()?['Progress/Value']},'Submitted'), I get an error message

The input parameter(s) of operation 'When_an_item_or_a_file_is_modified' contains invalid expression(s). Fix invalid expression(s) for the input parameter(s) of operation 'When_an_item_or_a_file_is_modified'.

What should I do?

Was this reply helpful? Yes No
David_MA 12,966 Super User 2025 Season 2 on at

Like (0)

Report

Is this the trigger condition: @equals(@{triggerBody()?['Progress/Value']},'Submitted') you tried to add?

If so, that is not a valid expression. It should be @equals(triggerBody()?['Progress/Value'],'Submitted')

When posting to the forums, it is always best to share a screen shot of the configured action that you are having trouble with. It makes getting a resolution to your issue go faster.

Was this reply helpful? Yes No
BT-06031656-0 10 on at

Like (0)

Report

It's still not working. I'm attaching all the screen shots.

I'm a newbie at powerautomate, so I have no clue how to fix any of this. I'd be so grateful if someone can help me resolve this.

These are my trigger settings:

These is my condition:

This is my update item action

This is my send email action:

This is my list:

After all this, I ran a test, and before I updated any estimated arrivals, the status was changed and I got emails.

and when I manually updated the estimated arrival, nothing happened.

and what's more, I got the first set of emails again.

Was this reply helpful? Yes No