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.
Solved! Go to Solution.
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 #"
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 #"
Join digitally, March 2–4, 2021 to explore new tech that's ready to implement. Experience the keynote in mixed reality through AltspaceVR!
Power Platform release plan for the 2021 release wave 1 describes all new features releasing from April through September 2021.
User | Count |
---|---|
87 | |
57 | |
39 | |
35 | |
33 |
User | Count |
---|---|
79 | |
67 | |
57 | |
49 | |
41 |