Answered

Date condition always FALSE

(0) Share

Report

Posted on by AnnaC

Hi there,

I'm trying to create a simple flow that sends an email based on a date within an Excel column named "Richiesta CV2", so I set up a conditional to check when the values (dates) in the "Richiesta Cv2" column are equal to today, if YES send an email.

However, I seems that the condition never results in "true", therefore the email is not sent.

This is the flow I created:

Screenshot 2023-10-17 163023.png Screenshot 2023-10-17 163120.png From the Compose action, the output seems to be correct (the date from the "Richiesta CV2" column) but the Conditional is still "false".

Screenshot 2023-10-17 163219.png Screenshot 2023-10-17 163239.png Hope anyone can help, thanks in advance! Bye!

Categories:

General topics

I have the same question (0)

All responses (2)

Answers (1)

Verified answer

wskinnermctc 6,519 Moderator on at

Like (0)

Report
Copy link

Link copied!

The condition is comparing text strings.

"2023-10-17T00:00:00.000Z" does not equal "2023-10-17"

Also the utcNow('yyyy-mm-dd') is incorrect since "mm" is minute. You need to have "MM" for months.

utcNow('yyyy-MM-dd') is 'year-month-day'

utcNow('yyyy-mm-dd') is 'year-minute-day'

So you need to format the outputs of the Excel to be the same as the utcNow().

formatDateTime(outputs('Compose'),'yyyy-MM-dd') is equal to utcNow('yyyy-MM-dd')

Was this reply helpful? Yes No
AnnaC 12 on at

Like (1)

Report
Copy link

Link copied!

Thank you very much, with your corrections the flow works perfectly.

Was this reply helpful? Yes No