Answered

Date from Excel file is not retrieved properly

(0) Share

Report

Posted on by sara_bartosova

Hi, I'm building a flow to send a notification to the HR Admin in case that somebody's contract end date is in 60 days or earlier. I have the HR data in excel file and my flow looks like this:

The flow runs smoothly, but somehow does not evaluate the conditions. Conditions look like this:

The excel file has data in this format:

When I did not have there the "null" conditions, it somehow retrieved the data and send me an email about everybody who did not have Contract End date filled in. Now it does not send an email and the flow checker looks like this:

Does somebody have any idea where might be an issue? I thought it's the formatting of the date in excel file, but did not find a solution to this on my own. 😞

Categories:

General topics

All responses (3)

Answers (1)

Sort by

Anil_g 668 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

@sara_bartosova

Looks like the data is not coming as null…as it is in dateformat may be the default date is coming as input..try to check the runtime values to know what is getting fetched when date is null..or may be it can be an empty string as well

cheers
Verified answer

v-mengmli-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @sara_bartosova ,

Do you mean that the Condition always returns false?

The Date in excel table is in "yyyy-MM-dd" format default, but you are using "mm/DD/yy" format in utcNow, so please modify compared date to same format firstly.

Note: You also need to turn on this setting firstly, otherwise the date of excel table will be in serial number.

Best regards,

Rimmon
sara_bartosova on at

Like
a
(1)

Report
Copy link

Link copied!

Hi,
yes, thanks, I also came up with this solution. Also changed the conditions a bit and now it all works.

Kind regards,
Sara