Why does my filter get no results?

[gardnerlhwrc]

I've set up this filter in my get items

CompletedDate ge '@{addDays(utcNow(),-10,'yyyy-MM-dd')}' and OData__x0033_MonthCheck_x003f_ eq 'true'

(tried without quotes on the true part as well)

CompletedDate ge '@{addDays(utcNow(),-10,'yyyy-MM-dd')}' - this part of the query works and get the 2 results, good.

Here is where I have the problem 

and OData__x0033_MonthCheck_x003f_ eq 'true'

So in my SP List I have a Yes/No column for 3 month check.

When I remove this part of the filter and run I see this as the output.

"OData__x0033_MonthCheck_x003f_":true, 

 So why when I put in the Boolean check I get no results. 

Not sure this has anything to do with it but the items in this list get created from another flow this SP list is basically an archive of completed jobs.

What's also strange is if I set it to 'false' I also get no results. 

[gardnerlhwrc · Accepted solution]

Sorted it myself...

So incase anyone else hits same problem. Needed to change the filter to the following.

OData__x0033_MonthCheck_x003f_ eq '1' 

Seems it checks for 1 / 0 rather than true / false

[v-LilyW-msft]

Hi @gardnerlhwrc 

Thanks for your posting here and sharing the solution in the forum as it would be helpful to anyone who encounters similar issues.

Yes, while SharePoint is displaying the values as ‘Yes’ or ‘No’ to the users, and as ‘true’ or ‘false’ on the background, to make a working filter query on Yes/No (boolean) column in Power Automate Get items action we need to use numbers, Yes = 1, No = 0.

Best Regards.