Condition not operating correctly

[Anonymous]

Hi all,

I'm building a flow which has a condition reliant on a date from excel. Snip is attached. When using the date formula in other flows it worked perfectly. But in the condition, all of the inputs come out as false. I have checked in other flows and my date is coming out of excel as the correct number, and the formula is producing the same number, so unsure as to what is going wrong. All help is appreciated, thanks a million.

[efialttes]

Hi!

My suggestion is to add a dummy Compose action block inside your 'Apply to each', just before the 'Condition' action block, and assign as its input 'Start date' dynamic content from excel. Now you can inspect easily its content.

My guessing is that your 'Start Date' Excel column has Date format, if so, it is stored internally as an integer. If this is the case, you will find the way to proceed here:

https://www.bythedevs.com/post/working-with-date-time-data-of-excel-in-power-automate

If not the case, please share 'Start date' content and the WDL expression also

Hope this helps

[Anonymous]

Hi @efialttes 

I appreciate your help with this.

As you can see below, the date matches the output of the formula.

But when I put them into a condition it comes back as failed.

Can you think of any reason as to why this is happening?

[efialttes · Accepted solution]

Hi!

Then the issue is probably a data mismatch. So your addDays() expression output is of type integer, but the Excel column is of type string. Try to cast your excel column, by means of int()... or cast your addDays() output by means of string()

Hope this helps

[Anonymous]

Hi @efialttes 

Thank you for your help and I appreciate the suggestion.

I have used the get a row function on several different flows using the same data and formula.

It has worked fine for me in these flows.

However, I need to use list rows present for this flow.

Would using the list rows present function have changed anything?

If not could you write the expression for me to fix this error

[efialttes]

Finally solved, right? If so...

Congrats!

[Anonymous]

Yes, thanks so much😁