Unanswered

Flow with a condition checking a calcualted true/false value always returns false

(0) Share

Report

Posted on by kmmesrob

I have a list with a column [Approval%] which calculates a variation +/- 20% of other columns and the output is Yes/No formatted. The Approval% column produces the correct result when the values are changed (i.e. Yes/No), so I know the formula in the list is working.

The flow I set up has a 'get item' action which pulls the list values and a condition:

@equals(body('Get_item')?['Approval_x0020__x0025_'], 'yes') which evaluates if the variation is outside the range. If Approval% value is = 'yes' it should kick off an approval. If = no, it should send an email.

Not matter what expression I put the condition ALWAYS produces a 'false' output and sends the email, not the approval.
I've tried [Yes] in single quotes, double quotes, bool(true), bool(1), yes, true, 1, and every varation thereof. No matter how I format it the expression always produces a false.

Am I missing an action step to retrieve the column values? Does the fact that the column is calcuated effect it? Is there a different trigger I should use? I'm losing my mind....

Categories:

Building flows

I have the same question (0)

All responses (2)

Answers (1)

v-yuazh-msft on at

Like (0)

Report
Hi @ kmmesrob,

The output of a calcualted column in a sharepoint list would be "0" or "1" instand of "No" or "Yes".

So you could use expression in the Condition as below:

@equals(items('Apply_to_each')?['Approval_x0020__x0025_'], '1')

I have made a test on my side and have created a flow as below:

The flow would run successfully as below:

Please let me know if your problem could be solved.

Regards,
Alice Zhang

Was this reply helpful? Yes No
Verified answer

kmmesrob on at

Like (0)

Report

Hi Alice! Thanks for the qucik reply. I actually got it work last night with a different method. I changed the calcuation for the Approval % column to be an =IF statement with Yes,No as the output and then changed the flow to recognized a boolean Yes string. Seems to be working but if it crashes I'll try your method!

Thanks!!!

Was this reply helpful? Yes No