Power Platform CommunityForums Power Automate - Building Flows What is wrong with thi...

What is wrong with this odata filter?

(0) Share

Report

Posted on by AM-28112221-0

Hello, I am building a flow where the list rows action has an odata filter in the filter rows field:

daysuntilmovein eq 3 and city eq 5 and (access ne 2 or access ne 1) and (stage eq 1 or stage eq 4) and type ne 1

It pulled me a record where access is 2 even though it's clear it shouldnt happen. Is it a bug or is the filter incorrect?

Categories:

Business Process Flows

All responses (1)

Answers (0)

Suggested answer

eetuRobo 2,374 on at

Like (1)

Report

What is wrong with this odata filter?

I think the problem is: (access ne 2 or access ne 1)
I think that will always be true. The or access ne 1 will find access that has value 2.
So if you have row that has access being 2 then (access ne 2 =false or access ne 1 = true) -> true

Change it to this:
daysuntilmovein eq 3
and city eq 5
and access ne 2
and access ne 1
and (stage eq 1 or stage eq 4)
and type ne 1