Email is being sent on one flow and not on the second identical one

(0) Share

Report

Posted on by Trmisha

Hi everyone.

I have 2 almost identical flows which only difference is that they are pointing to the different tables.

Both flows should be sending emails once they check the condition which is:

1) Expiry Date is not equal to blank value

2) addDays(utcNow(),5,'yyyy-MM-dd') is greater than Expiry Date (in the flow which works and is sending emails the value for adding days is 90 instead of 5)

3) addDays(utcNow(),0,'yyyy-MM-dd') is less than Expiry Date.

Both of the tables have the same Date format for the column Expiry Date:

Can someone please help me with this as I'm breaking my head around it and don't know what I am missing.

How is it possible that both tables are formatted in the same way but condition is working only for one and not for the other one?

Thank you in advance!

All responses (2)

Answers (0)

Trmisha 3 on at

Like (0)

Report

Re: Email is being sent on one flow and not on the second identical one

Hi @v-liwei-msft ,

Thank you for replying me.

When I go to test the flow I get that all the expressions outputs for condition part are "false" even though I do have some of the dates in Excel in the next 5 days which should give "true" output.
v-liwei-msft on at

Like (1)

Report

Re: Email is being sent on one flow and not on the second identical one

Hi @Trmisha ,

Please check whether the data in the excel table meets the conditions set in your flow.

Best Regards,
Levi