Unanswered

Get items filter query using boolean

(1) Share

Report

Posted on by russrimm Microsoft Employee

Hi all,

I'm trying to use a filter query to filter my Get Items (from Sharepoint) step. The column i'm trying to use for the filter is a Yes/No. I've tried Columnname eq false, Columnname eq 'false',

equals(item()?['Columnname'], json('false')), Columnname eq 0, tried a Filter array, etc. I'm struggling to get my filter to work no matter what I try. Any suggestions?

Thanks in advance

Categories:

General topics

I have the same question (0)

All responses (13)

Answers (0)

Sort by

AlanPs1 2,471 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @russrimm

Can you please post a picture of (or a C&P) of the JSON from Get Items and the value that relates to your " Columnname"?

If you find my posts helpful, please mark with thumbs up

Any questions, just ask.

Thanks, Alan

Was this reply helpful? Yes No
russrimm Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Thanks Alan, the column i'm trying to filter in is called "ClosedOut"

Was this reply helpful? Yes No
AlanPs1 2,471 on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @russrimm

I haven't tested this but at a glance, it looks as if it should be:

equals(item()?['ClosedOut'], 'false')

or

equals(string(item()?['ClosedOut']), string('false'))

Please give them a try and see if any improvement.

If you find my posts helpful, please mark with thumbs up

If this solves your issue, please click "Accept as Solution"

Any questions, just ask.

Thanks, Alan

Was this reply helpful? Yes No
russrimm Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Thanks again Alan,
One more confusion for me - i've got a couple of other filters with it which are working (Event Date gt and lt a specific date). How do I integrate this additional filter into that? Tried both of your suggestions a few different ways, with and without the and ClosedOut eq, with and without the ' ' around it, etc. I keep getting a lot of Column 'false' does not exist.
Thanks again

Was this reply helpful? Yes No
AlanPs1 2,471 on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @russrimm

Some of what I posted there wouldn't slot right into a filter query, please consider the below:

Where I have interested the dates above, please add your own using your adddays & utcNow with no single inverted commas.

Event_x00200_Date gt 2019-10-22T-00:00:00Z AND Event_x00200_Date lt 2019-10-29T-00:00:00Z AND ClosedOut eq 'false'

Please let me know how you get on?

If you find my posts helpful, please mark with thumbs up

If this solves your issue, please click "Accept as Solution"

Any questions, just ask.

Thanks, Alan

Was this reply helpful? Yes No
russrimm Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Thanks Alan,
I tried adding a new get items step and added only ClosedOut eq 'false' by itself and it ends up returning all records whether ClosedOut is true or false. I also tried it without the single quotes.

Was this reply helpful? Yes No
AlanPs1 2,471 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @russrimm .

From memory, it may be the case that Filter query doesn't handle the boolean very well (I may be wrong, been a while) so I'd advise for this one, filter query on your dates then add a condition to test ClosedOut after that.

In the mean time, I will look to recreate by creating a list with a boolean and some dates and report back but if it were I, and the filter query wasn't working, just pop a condition after the get items using the code I mentioned initially and it will only pass the condition in line with what you tell it to.

If you find my posts helpful, please mark with thumbs up

Any questions, just ask.

Thanks, Alan

Was this reply helpful? Yes No
Prafull 8 on at

Like
a
(1)

Report
Copy link

Link copied!

The Get Items action in flow does not work with filter query if you pass true or false for Yes/No column. You need to use Boolean value.
Try CloseOut eq '0'

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like
a
(7)

Report
Copy link

Link copied!

SOLUTION - Yes/No though display as "true/false" by PowerAutomate, but OData recognize as "1 and 0". 1 for Yes, 0 for No.

Was this reply helpful? Yes No
jbs_bs 25 on at

Like
a
(5)

Report
Copy link

Link copied!

Hi,

In oData, use 1 to true, and 0 to false...

e.g.: Columnname eq 0

Was this reply helpful? Yes No