Power Automate

Condition outcome is true, even though one the statements is false

(0) Share

Report

Posted on by lukejohnson1

I have a condition, reliant on two statement being true:

If a sharepoint yes/no field is ticked
If a formula (which looks at a number of data fields and choice fields to determine) equals true:

You can see clearly in the run output that the 2nd statement is false but the final outcome is true???

Why would this be the case?

Categories:

Building flows

Using flows

I have the same question (0)

All responses (4)

Answers (0)

Sort by

Kalathiya 2,211 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Hello @lukejohnson1,

Could you please share:

#1. exact formula/expression you are using for the both condition
#2. Both expression used column type/output type (Yes/No, Choice, Text)?

Because this usually happens when Power Automate is comparing a Boolean value with a text/string value. Once we see the formula and data type, it will be easier to identify the issue.

If this response resolves your issue, please mark it as the Verified Answer so it can help other community members as well.

---------------------------------------------------------------------------------

📩 Need more help? Just mention @Kalathiya and I’ll be happy to assist.

✔️ If this answer helped you, please tick “Does this answer your question?” so it can be marked as the Verified Answer.

💛 A Like always motivates me to keep contributing!

Was this reply helpful? Yes No
Suggested answer

Vish WR 3,418 on at

Like (0)

Report
Copy link

Link copied!
@lukejohnson1

Even if one part shows false in the run history, the overall condition can still pass due to:

accidental OR logic instead of AND

the formula returning text “true” instead of boolean true

SharePoint Yes/No field being treated as string instead of boolean

condition referencing a slightly different value than what you’re inspecting

You can try

and(
equals(triggerBody()?['YesNoField'], true),
equals(outputs('Your_Formula_Step'), true)
)

Was this reply helpful? Yes No
Chriddle 8,697 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

We had something similar here:

I assume that the value "False" comes from the server-side evaluation, while the value "True" from the last condition is only calculated (falsely) in the designer.

https://community.powerplatform.com/forums/thread/details/?threadid=74e5a416-3224-f111-8341-7c1e520d540b

Was this reply helpful? Yes No
David_MA 14,672 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Based on your screen shot, I would double check that the correct SharePoint Boolean field has been added to the condition. The icon shown in your screen shot does not look like what it should be if it comes from SharePoint:

It should have the SharePoint icon as shown above. That is probably why there is an exclamation point to the right of this condition in your screen shot.

Was this reply helpful? Yes No