web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / Condition recognizes t...
Power Automate
Unanswered

Condition recognizes text in Excel cell as false when it should be true

(1) ShareShare
ReportReport
Posted on by 44
I am using Dynamic Content to send an email based on the cell under the table header 'status' if it is Equal to Level 1 it should send an email, if Level 2 another email, and None another email. I have the condition set to "Status" is equal to Level 1, which it indeed is. As you can see in the attached screenshots the Status is Level 1 as required in the condition yet it is returning false. I tried to make it contains Level 1 and that gave me an error and the flow failed. Any help is greatly appreciated. Thank you so much. 
 




Categories:
I have the same question (0)
  • creativeopinion Profile Picture
    10,502 Super User 2025 Season 2 on at
    To troubleshoot your condition action, ensure the values being compared are exact matches. The is equals to operator looks for an exact match, so any trailing spaces or case differences will cause the condition to return false. Add a Compose action before the condition action, insert the dynamic content you are using in your Compose action, and run a test to review the outputs.
     
     
    In this Power Automate tutorial, I explore 5 frequently asked questions that pop up when troubleshooting a flow. If you’d like to to level up your Power Automate flow skills and learn how to troubleshoot your Power Automate flow—this tutorial is for you!
     
    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!

    Consider giving me a ❤️ if you liked my response!

    👉 Level up your Power Automate skills by checking out my tutorials on YouTube
    👉 Tips and Tricks on TikTok and Instagram
     
     

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 501 Super User 2025 Season 2

#2
Tomac Profile Picture

Tomac 323 Moderator

#3
abm abm Profile Picture

abm abm 237 Most Valuable Professional

Last 30 days Overall leaderboard