web

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

News and Announcements icon

Power Platform CommunityForums Power Automate "Not" Operator in oDat...

Power Automate

Answered

"Not" Operator in oData Filter not working

(0) Share

Report

Report

Posted on by xsg13

30

Hi,

I'm trying to use the "Not" operator in a filter query on a Get Items for Sharepoint list and I get the following error:

I've also tried simplifications with just a single statement and these also fail so it seems like there is something Power Automate doesn't recognize about "not".

Is there an alternate syntax in Power Automate for this?

"Not" is a key logical operator and in the oData spec. I acknowledge that in the simple shared example there is a solution you can use to avoid "not", but in more complex examples "not" will likely be necessary.

https://www.odata.org/documentation/odata-version-2-0/uri-conventions/

Categories:

I have the same question (0)

All responses Img

All responses (1)

Answers Img

Answers (1)

Verified answer

Shujaath_Khan 1,111 Super User 2024 Season 1 on at

Like (1)

Report
Copy link

Link copied!
Hi @xsg13
can the data query be tweaked to as below

IMD ne null and IMD ne '100000' or if it's a number column IMD ne null and IMD ne 100000

Thanks
Please click Accept as Solution on this reply if it helped to solve your issue, and thumbs-up if you feel this is useful or important in other ways as a boost.

Was this reply helpful? Yes No

Join the conversation