Unanswered

Condition Expression is Showing False while the condition is True

(0) Share

Report

Posted on by JamilJames

The logic is to check the column in my excel Sheet "DCPN" and see the data is the same data in Distributor Product Col 1,2,3,4,5. If the data is the same then update the Compliant Col to "YES", if they data is not the same then update the Compliant Col to "NO". The condition is showing false, and I think the reason is because there is an apply to each nested in another apply to reach. Please see the screenshots below.

Categories:

Building flows

I have the same question (0)

All responses (5)

Answers (0)

creativeopinion

10,502 Super User 2025 Season 2 on at

Like (1)

Report

@JamilJames To troubleshoot your condition action you should add a couple of Compose actions before the Condition action and insert the dynamic content you are evaluating in your Condition action. Run a test and view the outputs of the Compose action to see if they are what you are expecting.

Because you are using the is equal to operator, it's looking for an exact match. If the dynamic content output isn't matching the values you've manually inputted into the second value field of the condition row—it will return false.

I cover how to do that in the first section of this tutorial: 5 Power Automate Troubleshooting FAQs and Helpful Tips for Creating Better Flows

IN THIS VIDEO:

✅ How to troubleshoot a false Condition action result

✅ How to get dynamic content when it isn’t selectable from the list of dynamic content

✅ How to troubleshoot an Apply to Each action that isn’t looping through

✅ How to troubleshoot a skipped Apply to Each action

✅ How to troubleshoot a Filter Query

✅ How to use a SharePoint yes/no column in a Filter Query

✅ How to use Compose actions to troubleshoot a Power Automate flow

✅ How to troubleshoot multiple emails being sent

✅ How to troubleshoot multiple Teams messages being sent

Hope this helps!

If I helped you solve your problem—please mark my post as a solution ✅.
Consider giving me a 👍 if you liked my response! If you're feeling generous— ☕️ Buy me a coffee: https://www.buymeacoffee.com/acreativeopinion

👉 Watch my tutorials on YouTube
👉 Tips and Tricks on TikTok

Was this reply helpful? Yes No

JamilJames 6 on at

Like (0)

Report

Hi @creativeopinion

Thank you for the quick replay. Unfortunately, I have tried what you are suggesting above, and I am still getting a false expression. I am wondering if it is because the nested apply to each.

Was this reply helpful? Yes No
JamilJames 6 on at

Like (0)

Report

@creativeopinion and when I put compose for "Get Item" it puts it in apply to each, and the output is the number that is enter into the Distributor Product Column.

Was this reply helpful? Yes No

creativeopinion

10,502 Super User 2025 Season 2 on at

Like (0)

Report

@JamilJames Sorry after reviewing your flow again, you'll need to use a Filter Array action. Take a look at this tutorial: Are you using the Microsoft Power Automate Filter Array Action wrong?

In this video tutorial I’ll show you 3 practical ways to use the Filter Array action and how to use it properly.

1️⃣ Cross-Referencing Data

2️⃣ Filtering by Key

3️⃣ Substring Matching

Did you know that the Condition action has a limit of 10 conditions? Although it might look like the Filter Array action can only accept one condition—this is not true. By using the advanced mode you can enter multiple conditions into a Filter Array action with an expression.

IN THIS VIDEO:

✅ 3 Ways to Use the Filter Array Action

✅ How to use the Scope Action to Group Actions

✅ How to Check the Number of Items returned from a Filter Array Action

✅ How to Cross-Reference Data in Excel with a SharePoint List

✅ How the Filter Array Action Works

✅ How to Access the Dynamic Content from a Filter Array Action

✅ How to Filter Items by a Key

✅ How to Filter Items by Matching a Substring

✅ How to Use Multiple Conditions in a Filter Array Action

Hope this helps!