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

Like (0) Share

Report

Posted on 26 May 2022 15:33:18 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!

I have the same question (0)

All responses (2)

Answers (0)

Trmisha 3 on 31 May 2022 at 10:17:34

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.

Was this reply helpful? Yes No
v-liwei-msft on 31 May 2022 at 10:06:28

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

Was this reply helpful? Yes No