Skip to main content
Community site session details

Community site session details

Session Id : KaFMr/h/bF4li75Jp5vcEm
Power Apps - Building Power Apps
Answered

Opposite of "IsMatch" function?

Like (0) ShareShare
ReportReport
Posted on 6 Mar 2020 22:52:01 by Microsoft Employee

Hello I am trying to filter a dataform connected to a database with a dropdown. I am specifically attempting to filter a column that has multiple values (or tags) separated by a comma. I want to filter this source by multiple conditions, including entities that do NOT contain the word "Global". I cannot do a straight 1 to 1 comparison using "<>" since this column has multiple tags separated by commas. 

 

The function "IsMatch" works when i attempt to only filter to those values in the column. I am curious how i would filter by the inverse of this? Showing ALL results in my dataform for entities that do NOT contain the keyword. The code looks something like this:

 

Dropdown1.Selected.Value = "PM", Filter('Activities', Or(state_label = "Open", stage= "Six"), And(IsMatch(tsatags, "Global", Contains & IgnoreCase)

 

Meaning= When dropdown "PM" is selected, filter data source "Activities" with state = Open, Stage = Six and Tags to all rows that do NOT contain the word "global"

 

Can anybody help me here?

  • mdevaney Profile Picture
    29,987 Super User 2025 Season 1 on 09 Mar 2020 at 12:35:31
    Re: Opposite of "IsMatch" function?

    @moelhag 

    I have no idea why @v-yutliu-msft feels the need to repeat what I have already said 2 days earlier 😒

     

    This is the solution...

    !(IsMatch(tsatags, "Global", Contains & IgnoreCase))

     

    ---
    Please click "Accept as Solution" if my post answered your question so that others may find it more quickly. If you found this post helpful consider giving it a "Thumbs Up."

  • v-yutliu-msft Profile Picture
    on 09 Mar 2020 at 09:28:13
    Re: Opposite of "IsMatch" function?

    Hi @moelhag ,

    Do you want to get the inverse value of IsMatch(tsatags, "Global", Contains & IgnoreCase)?

    It can be easily implemented by using Not or ! Operator:

    Not(IsMatch(tsatags, "Global", Contains & IgnoreCase))

    or

    !(IsMatch(tsatags, "Global", Contains & IgnoreCase))

    Ive made a similar test for your reference:

    1\ Add a dropdown control(DropDown1) and Set the controls items property to:

     

     ["PM","PP","MM"]

    2\ Add a gallery control and set the controls items property to:

    If(
    
     Dropdown1.Selected.Value = "PM", 
    
     Filter(
    
     Activities,
    
     Or(
    
     state_label = "Open",
    
     stage = "Six"
    
     ) && !(IsMatch( /*get the inverse value of ‘IsMatch(tsatags, "Global", Contains & IgnoreCase)’*/
    
     tsatags,
    
     "Global",
    
     Contains & IgnoreCase 
    
     ))
    
     )
    
    )

       398.png

     

    If you still have any question please dont hesitate to let us know.

     

     

    Best Regards,

  • Verified answer
    mdevaney Profile Picture
    29,987 Super User 2025 Season 1 on 06 Mar 2020 at 22:56:37
    Re: Opposite of "IsMatch" function?

    @moelhag
    I think you can take this section code that you’ve already written...

     

    IsMatch(tsatags, "Global", Contains & IgnoreCase)

     

    ...and make this simple change.

     

    !(IsMatch(tsatags, "Global", Contains & IgnoreCase))

     

    ---
    Please click "Accept as Solution" if my post answered your question so that others may find it more quickly. If you found this post helpful consider giving it a "Thumbs Up."

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

Paul Stork – Community Spotlight

We are honored to recognize Paul Stork as our July 2025 Community…

Congratulations to the June Top 10 Community Leaders!

These are the community rock stars!

Announcing the Engage with the Community forum!

This forum is your space to connect, share, and grow!

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 791 Most Valuable Professional

#2
MS.Ragavendar Profile Picture

MS.Ragavendar 410

#3
mmbr1606 Profile Picture

mmbr1606 275 Super User 2025 Season 1

Loading complete