Automated notifications happening too often

[LauraCas72]

I am building a workflow that requires 2 notifications that occur at different points.  The workflow contains several steps.  I have the emails set up, but they send out at every step and not just at the assigned steps I am looking for.  How do I set this up so the flow only sends at the 2 times that are actually required and not multiple times causing confusion?

New item added

Pull Date Entered - 1st Email Notification sent

Identification entered

Prep Date Entered

Scan Date Entered

Validation Date Entered - 2nd Email Notification sent

Breakdown Date Entered

Verification and Mailing Date Entered

Currently, 1st email is being sent out 7 times, 2nd email is being sent out 3 times

[v-yujincui-msft]

Hi @LauraCas72 ,

Is the trigger you are using "When an item is created or modified"?

I suggest you to use conditional Action in Flow to achieve your needs.

I have made a test for your reference.

1. Here is my SharePoint List.

2. Create a flow.

Result Screenshot:

Best Regards,

Charlie Choi

[LauraCas72]

Unfortunately, this didn't work.  It still sent the email again after the next update occurred.

Here is a screen shot of my flow:

I only want it to send when the date pull has a date entered but does not have a string of values in the CTN category.

[v-yujincui-msft]

Hi @LauraCas72 ,

I guess the Expression Result of your Condition Action is always false, you can check it in the flow's run history.

Is 'CTN category' a choice column?  If so, you should select 'CTN Value' in the dynamic content.

In addition, you may consider formatting the time before comparing.

formatDateTime(utcNow(),'yyyy-MM-dd')

Best Regards,

Charlie Choi

[LauraCas72]

Hi, the CTN is not a choice.  It is a series of numbers

I updated to this and still not working:

it still sent a notification when a different date was entered for a step further down and the CTN is already populated with a value.

Expectation is that the notification only happens when the Pull Date is Entered and CTN is NOT populated.  No other time.

[v-yujincui-msft · Accepted solution]

Hi @LauraCas72 ,

Try to modify the Condition Action as follows:

Best Regards,

Charlie Choi

[LauraCas72]

Charlie - Thank you for all of your help!  It is finally working!