You’re offline. This is a read only version of the page.
Announcements
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/
Hi @xsg13
can the data query be tweaked to as below
Share
Report
All responses (
Answers (
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.
