Filter OData query with not contains

[gmaasz]

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?

[mahoneypat]

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....

Pat

[gmaasz · Accepted solution]

Solved this one by using the filter array action after the get items function