Answered

Date Condition always false

(0) Share

Report

Posted on by honganhuynh1

302

I have a date and time column - 2 Day Notice

and a condition that checks if
2 Day Notice is equal to utcnow('MM/dd/yyyy')

Status is equal to 'Manager Notified'

Then it sends an email - but everything is returning false.

Categories:

Building flows

I have the same question (0)

All responses (5)

Answers (1)

Sort by

honganhuynh1 302 on at

Like
a
(0)

Report
Copy link

Link copied!

I changed utcnow('MM/dd/yyyy') to ('yyyy-MM-dd') and still not difference

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

Like
a
(1)

Report
Copy link

Link copied!

Hi @honganhuynh1,
Could you please show some screenshots about your columns '2 Day Notice' and 'Status' in your dataset and your condition formula in order to help you better?
There is usually time difference between date in Datasource like SharePoint list and Power automate.
The default Time zone in SharePoint is based on your site region settings.

Best Regards,
Kyrie

Was this reply helpful? Yes No
Verified answer

honganhuynh1 302 on at

Like
a
(0)

Report
Copy link

Link copied!

hi there! I realized I was using Status which is a choice column so in my condition i should be using Status Value.

Once changing it to Status Value it validated correctly.

Was this reply helpful? Yes No
coliveira03_ 13 on at

Like
a
(0)

Report
Copy link

Link copied!

What do you mean you have changed to statues value? i am facing the same issue
thank you

Was this reply helpful? Yes No
honganhuynh1 302 on at

Like
a
(0)

Report
Copy link

Link copied!

Hey there so for example when i was adding the condition.
I was adding Status which kept throwing me false. You need to choose Status Value (if it's a choice column)

So if youre trying to run a condition based off a choice column choose the <Column Name> Value.

Was this reply helpful? Yes No