Problem with Condition / all result are false.

(0) Share

Report

Posted on by Ranp34

I have a list with a calculated field its formula is:

=[Expiration Date]-TODAY()

I want to create a daily recurrence flow, that checks the calculated field and if the result = 90 send an email. However, even when the item with the 90 exist, the result for the flow is always false.

My flow:

Sin título.jpg

The Condition Formula is:

equals(triggerBody()?['Outstanding_x0020_Days_x0020_for'], '90')

['Outstanding_x0020_Days_x0020_for'] is the calculated column

Categories:

Building flows

I have the same question (0)

All responses (1)

Answers (0)

tom_riha 10,185 Most Valuable Professional on at

Like (0)

Report
Hello @Ranp34 ,
try to add a 'Compose' action directly before the 'Condition' and put the 'Outstanding Days for' dynamic content into that action. You'll then see in the run history what value it contains.
If it contains 90, I'd try to define the condition in a simpler format using the gui
Instead of: <expression> is equal to <true> try: <column> is equal to 90

Was this reply helpful? Yes No