cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
marcosmedeiros
New Member

How to filter specific word with OData

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.

 

InkedCaptura da Web_17-11-2022_151512_make.powerautomate.com.jpg

 

Thanks in advance.

1 ACCEPTED SOLUTION

Accepted Solutions
PowerAppsWizard
Resolver III
Resolver III
3 REPLIES 3
PowerAppsWizard
Resolver III
Resolver III

Hi

What does the error message return?

The statement looks correct.

What column type is the email column?

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
Resolver III
Resolver III

Helpful resources

Users online (3,852)