Announcements
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?
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
Solved this one by using the filter array action after the get items function
Apparently, it is now possible to do not()-notation (know from workflow definition language, you do expressions in) to reverse a contains statement:
@mahoneypat
That should make the trick:
It will bring all records, excluding the ones having abcdefg in their Fieldname.
?$filter=not substringof('abcdefg', Fieldname)
not contains doesn't work with odata filter query but can use 'not' like this:
$filter=not(startswith(fieldName,'text to search'))
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
Congratulations to our 2026 Super Users!
Congratulations to our 2025 community superstars!
These are the community rock stars!
Stay up to date on forum activity by subscribing.
David_MA 77 Super User 2026 Season 1
Haque 68
Expiscornovus 56 Most Valuable Professional
