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

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / Issue with Condition o...
Power Automate
Answered

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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Users!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Congratulations to the March Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Automate

#1
Haque Profile Picture

Haque 573

#2
Valantis Profile Picture

Valantis 407

#3
11manish Profile Picture

11manish 387

Last 30 days Overall leaderboard