Answered

Filter OData query with not contains

Like (0) Share

Report

Posted on 21 May 2021 10:07:33 by Community Power Pla...

Hi, I would like to filter my 'Get Items' function with a "Does not contain" type of filter but I am unsure of the syntax. Can somebody please assist me with the correct syntax?

Categories:

Process Advisor

All responses (5)

Answers (1)

mvn 32 on 22 Feb 2024 at 14:34:31

Like (1)

Report
Re: Filter OData query with not contains

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

$filter=not(startswith(fieldName,'text to search'))
papsoc 4 on 07 Dec 2023 at 15:54:24

Like (0)

Report

Re: Filter OData query with not contains

That should make the trick:
It will bring all records, excluding the ones having abcdefg in their Fieldname.
?$filter=not substringof('abcdefg', Fieldname)
Community Power Pla... on 02 Dec 2022 at 20:54:09

Like (2)

Report

Re: Filter OData query with not contains

Apparently, it is now possible to do not()-notation (know from workflow definition language, you do expressions in) to reverse a contains statement:

@mahoneypat
Verified answer

Community Power Pla... on 24 May 2021 at 06:20:47

Like (0)

Report

Re: Filter OData query with not contains

Solved this one by using the filter array action after the get items function
mahoneypat 1,720 on 22 May 2021 at 02:04:47

Like (0)

Report

Re: Filter OData query with not contains

You can use substringof in the Filter Query of your Get Items action, but it looks like you can't do the "not" version of that. This post shows another way to do it.
Solved: Syntax for ODATA filter substringof to not contain... - Power Platform Community (microsoft.com)

Pat