Why does my filter get no results?

(0) Share

Report

Posted on by Community Power Pla...

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.

Categories:

Building flows

I have the same question (0)

All responses (2)

Answers (1)

Verified answer

Community Power Pla... on at

Like (1)

Report

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

Was this reply helpful? Yes No
v-LilyW-msft on at

Like (0)

Report

Hi @Anonymous

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.

Was this reply helpful? Yes No