Answered

Adding NOT condition in a filter query

(0) Share

Report

Posted on by Jason Yeung

Hi,

I want to add a "not" clause in my filter query. This is to exclude certain statuses of the records I'm trying to obtain. The filter I have is the following:

Strategic_Customer__c eq TRUE and (VAR_Domain__c eq 'test.com') and not (Krow__Project_Status__c eq 'Canceled' or Krow__Project_Status__c eq 'Complete')

I want to exclude any records that have the status 'Canceled' or 'Complete. But when I ran the flow, I got a bad request error. When I removed the "not", the flow worked fine. I was wondering is the syntax above correct for using "not"?

Jason

Categories:

General topics

I have the same question (0)

All responses (3)

Answers (1)

Sort by

Verified answer

SudeepGhatakNZ 14,396 Most Valuable Professional on at

Like (2)

Report
Copy link

Link copied!
Will this work? I replaced the combinator of "NOT and OR" with "AND and ne"

Strategic_Customer__c eq TRUE and (VAR_Domain__c eq 'test.com') and Krow__Project_Status__c ne 'Canceled' and Krow__Project_Status__c ne 'Complete'

Was this reply helpful? Yes No
ScottShearer 25,290 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

@JasonYeung

I don't believe that the not operator is supported in Power Automate OData filters for SharePoint.

Was this reply helpful? Yes No
Jason Yeung 53 on at

Like (0)

Report
Copy link

Link copied!

Hi @SudeepGhatakNZ ,

Thanks! I tried this and it works.

Sincerely,

Jason

Was this reply helpful? Yes No