web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Automate Filter OData query wit...

Power Automate

Unanswered

Filter OData query with not contains

(0) Share

Report

Report

Posted on by Community Power Pla... Microsoft Employee

Hi,

Trying to create a filter on my get items to filter out results that don't fit the below criteria.

Entries need to have a ship date (Field9) of yesterday (-1 day)

Entries doesn't contain C-EXV in field 2

This is my query so far which isnt working

field_9 eq '@{formatDateTime(addDays(utcNow(),-1), 'dd-MM-yyyy')}' and not(contains(item()?['field2'], 'C-EXV'))

The query to filter out all items where the ship date wasnt yesterday works by its self (field_9 eq '@{formatDateTime(addDays(utcNow(),-1), 'dd-MM-yyyy')}') but when i add in the latter part this doesnt work.

Any help would be appreciated.

Categories:

I have the same question (0)

All responses Img

All responses (2)

Answers Img

Answers (0)

RobElliott 10,426 Super User 2026 Season 1 on at

Like (1)

Report
Copy link

Link copied!

@hodgson41 you can't use not(contains) in a filter query. Have a look at the blog post by Tom Riha here which shows what you can do instead.

Was this reply helpful? Yes No
mvn 32 on at

Like (0)

Report
Copy link

Link copied!
not contains doesn't work with odata filter query but can use 'not' like this:

$filter=not(startswith(fieldName,'text to search'))

Was this reply helpful? Yes No

Join the conversation