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

Announcements
Power Automate News & Announcements

Power Automate News & Announcements

Keep up to date with current events and community announcements in the Power Automate community.

Community Calls Conversations

Community Calls Conversations

A great place where you can stay up to date with community calls and interact with the speakers.

Power Automate Community Blog

Power Automate Community Blog

Check out the latest Community Blog from the community!

Users online (5,345)