cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
mxh7875
Frequent Visitor

Flow sends emails regardless of conditions

I am trying to create a Flow that will check list items to see if a column is empty AND if a due date in another column has passed, and if true, send an email for each of those specific list items.  The list has 15 items and only 3 items meet both criteria.  No matter what I do the flow sends an email for all 15 items, regardless of the condition.  What am I missing?

 

 And I can't find the "editor's toolbar." to post my images of the flow. 

1 ACCEPTED SOLUTION

Accepted Solutions
mxh7875
Frequent Visitor

ID10T error, 

 

Original condition was @and(empty(triggerBody()?['OSC Ref #']),greater(utcNow(), items('Apply_to_each')?['Due_x0020_Date']))

 

There was no trigger body, as the Flow began with a recurrence, not "get items," so the empty criteria wasn't being checked.

 

Rewrote condition to @AND(empty(items('Apply_to_each')?['OSC_x0020_Ref_x0020__x0023_']),greaterOrEquals(utcNow(), items('Apply_to_each')?['Due_x0020_Date']))

 

Now all conditions are being checked, emails only send for each overdue item w/o a "OSC Ref #"

View solution in original post

1 REPLY 1
mxh7875
Frequent Visitor

ID10T error, 

 

Original condition was @and(empty(triggerBody()?['OSC Ref #']),greater(utcNow(), items('Apply_to_each')?['Due_x0020_Date']))

 

There was no trigger body, as the Flow began with a recurrence, not "get items," so the empty criteria wasn't being checked.

 

Rewrote condition to @AND(empty(items('Apply_to_each')?['OSC_x0020_Ref_x0020__x0023_']),greaterOrEquals(utcNow(), items('Apply_to_each')?['Due_x0020_Date']))

 

Now all conditions are being checked, emails only send for each overdue item w/o a "OSC Ref #"

View solution in original post

Helpful resources

Announcements
Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

User Group Leader Meeting January 768x460.png

Calling all User Group Leaders!

Don't miss the User Group Leader meetings on January, 24th & 25th, 2022.

Top Solution Authors
Top Kudoed Authors
Users online (1,593)