Table filter formula vs 'normal' formula discrepancy

Hi all. I’m trying to use the gmail pack to sync 1000s of emails and then add a filter based on sender. I’ve been racking my head trying to implement a seemingly straightforward filter that excludes all the senders I specify.

So far, this formula works outside a table:

However, the same doesn’t work as a filter within the table:

Is this a bug or am I doing something stupid?
Cheers!

Edit: I’d like to add that I’ve tried a few different iterations in the table like:
Name.Contains(1, 2).Not()
thisRow.Name.Contains(1, 2).Not()

1 Like

For the filters inside a table you need to omit the Table.filter() part, imagine that’s already written :slight_smile:

2 Likes

Thanks! I ended up having to use this:

thisRow.Name.Contains(List(1, 2)).Not()

Not sure why it didn’t work without the List() constructor.

1 Like

Awesome! Oh that’s odd, but you can try ContainsText instead perhaps

1 Like

This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.