Answered

Automated notifications happening too often

(0) Share

Report

Posted on by 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

All responses (6)

Answers (1)

LauraCas72 18 on at

Like (0)

Report

Re: Automated notifications happening too often

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

v-yujincui-msft on at

Like (1)

Report

Re: Automated notifications happening too often

Hi @LauraCas72 ,

Try to modify the Condition Action as follows:

Best Regards,
Charlie Choi
LauraCas72 18 on at

Like (0)

Report

Re: Automated notifications happening too often

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 on at

Like (0)

Report
Re: Automated notifications happening too often

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 18 on at

Like (0)

Report

Re: Automated notifications happening too often

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 on at

Like (0)

Report

Re: Automated notifications happening too often

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