Unanswered

Conditon {Greater Then Current Date} does not evaluate correctly

(0) Share

Report

Posted on by zwornik80

102

I have daily Flow which should send email notification when date in column "Actual delivery date (LEST)" is exceeded. I have used below setting in "Condition":

Problem is that I am getting email notification about exceeded date also when "Actual delivery date (LEST)" is equal to today's date. For example I run it today (27.02.2021) and data associated wit below row

Actual delivery date.png

was also included in email, while it should be included in tomorrow's notification, because below condition should not evaluate to True:

[utcNow() = 27/02/2021] IS GREATER THAN [Actual delivery date (LEST) = 27/02/2021]

Categories:

Building flows

I have the same question (0)

All responses (2)

Answers (1)

Verified answer

tom_riha 10,185 Most Valuable Professional on at

Like (0)

Report
Hello @zwornik80 ,

try to add a 'Compose' action before the condition and store the utcNow() and Actual delivery date into the compose action. That way you'll be able to see what values enter the 'Condition'.

I can image that since you're not formatting the utcNow() date it'll contain also hours/minutes/seconds, and then it might evaluate:

[utcNow() = 27/02/2021 10:21:40...] IS GREATER THAN [Actual delivery date (LEST) = 27/02/2021]

which is true as the Actual delivery date without time would be at 00:00:00. utcNow() is 10:21:40 greater than the Actual delivery date.

I'd try to remove the time from utcNow() to keep only the year, months and days (that will take today's date at 00:00 in UTC time zone).

utcNow('yyyy-MM-dd')

Was this reply helpful? Yes No
zwornik80 102 on at

Like (0)

Report

I did Compose on utcNow('yyyy-MM-dd') and the output was: 27/02/2021
I did Compose on "Actual delivery date (LEST)" and the output was: 2021-02-27
This revealed what why I was having issue. Flow sees date formatted as YYYY-MM-DD while in SharePoint List I see it as DD/MM/YYYY
I fix it by applying this condition:

utcNow('yyyy-MM-dd') IS GREATER THAN [Actual delivery date (LEST) = 27/02/2021]

Many thanks for help!

Was this reply helpful? Yes No