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 / Issue with Condition o...
Power Automate
Unanswered

Issue with Condition over Multiple Strings/Text

(0) ShareShare
ReportReport
Posted on by

Hey everyone,

 

I am a complete newbie when it comes to this stuff. I'm trying to build my first flow. As part of it, there is a part with a Condition, where an excel row cannot contain certain words to be considered true. I am trying to find the best way to go about this. I was initially using if "Excel Row" does not contain "string('text1','text2','text3'), however realized that string cannot contain more than 1 parameter.

 

What is the best way to do this? Can I just say if "Excel Row" does not contain: text1,text2,text3 in order to have multiple parameters for what exists in an Excel row?

 

Here's a screenshot of part of my flow. The two areas in question are the Excel Rows "NOTE" and "EMPSTAT" pulled from an excel file/table.

image.png

 

The second question goes hand-in-hand with the first. Similar, except I want a condition based on if an excel row is "empty". For this should I be using the expression "null" or something else?

 

I hope I'm being clear in what I am trying to accomplish. Any help whatsoever would be welcomed! Thank you in advance!

Categories:
I have the same question (0)
  • Verified answer
    PrasadAthalye Profile Picture
    on at

    For Question 1 -->

     

    • Declare a string array with all the possible values like below. 

    PrasadAthalye_0-1626725263466.png

     

    • Then inside if condition check if Array does not contain your NOTE from excel.

     

    For 2nd question --> Null check is correct to check if its empty.

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 522 Super User 2025 Season 2

#2
Tomac Profile Picture

Tomac 364 Moderator

#3
abm abm Profile Picture

abm abm 243 Most Valuable Professional

Last 30 days Overall leaderboard