How to filter specific word with OData

[marcosmedeiros]

How can I get only specifics itens from a list with OData, I want to get any e-mail domain but not a specific one. So, in this list I have some e-mails but I wanted to filter with OData to not get the people with certains domains.

I tried this but had no success.

Thanks in advance.

[PowerAppsWizard]

Hi

What does the error message return?

The statement looks correct.

What column type is the email column?

[marcosmedeiros]

Hi!

The type of the column is a Single line of text.

After testing again, the error doesn't seems to appears again... 

But what I am trying to do is not get a specific e-mail domain. When I add the operator not before the statement (not substringof('@example.com.br',EMAIL_x0020_RESPONSAVEL)) an erro occurs. 

This is the error:

Fetching items failed. Possible invalid string in filter query.
clientRequestId: 3364b922-3971-4df7-9bbc-344a3474a2c2
serviceRequestId: 3364b922-3971-4df7-9bbc-344a3474a2c2

[PowerAppsWizard · Accepted solution]

I believe that "not" will not work in a odata filter

Look here:

Solved: Syntax for ODATA filter substringof to not contain... - Power Platform Community (microsoft....