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

Categories:

Using flows

I have the same question (0)

All responses (6)

Answers (1)

Sort by

v-yujincui-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
LauraCas72 18 on at

Like (0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
v-yujincui-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!
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

Was this reply helpful? Yes No
LauraCas72 18 on at

Like (0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
Verified answer

v-yujincui-msft Microsoft Employee on at

Like (1)

Report
Copy link

Link copied!

Hi @LauraCas72 ,

Try to modify the Condition Action as follows:

Best Regards,
Charlie Choi

Was this reply helpful? Yes No
LauraCas72 18 on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No