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?
@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."
WarrenBelz
791
Most Valuable Professional
MS.Ragavendar
410
Super User 2025 Season 2
mmbr1606
275
Super User 2025 Season 2