cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
gardnerlhwrc
Helper II
Helper II

Why does my filter get no results?

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. 

1 ACCEPTED SOLUTION

Accepted Solutions
gardnerlhwrc
Helper II
Helper II

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

View solution in original post

2 REPLIES 2
gardnerlhwrc
Helper II
Helper II

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

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.

Helpful resources

Announcements
Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

MPA Virtual Workshop Carousel 768x460.png

Register for a Free Workshop

Learn to digitize and optimize business processes and connect all your applications to share data in real time.

Power Automate Designer Feedback_carousel.jpg

Help make Flow Design easier

Are you new to designing flows? What is your biggest struggle with Power Automate Designer? Help us make it more user friendly!

Top Solution Authors
Top Kudoed Authors
Users online (4,327)