cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Frequent Visitor

Bug - Filter won't work using checkbox value unless mixed with non-delegable conditions

Filter(Task, Task_x0020_Status='Tasks View Type'.Value) won't work unless I mix it with any non-delegable conditions, like Id=Contact.ID. If I remove the non-delegable condition it doesn't properly work, but any non-delegable (no matter how irrelavent) will make it start filtering.

2 REPLIES 2
Highlighted
Community Support
Community Support

Re: Bug - Filter won't work using checkbox value unless mixed with non-delegable conditions

Hi @rainingtalent,

 

Is this Task_x0020_Status column a Yes or no column? If so, I just tested with this formula and I got the same result that no matter I check the check box or not, it will always filter with false.

 

Yet the issue could be workarounded by using below formula instead:

If(Checkbox1.Value=true,Filter(ListList,YesNo<>false),Filter(ListList,YesNo=false))

 

I have tested and this works for me. 

 

Regards,

Mona

Community Support Team _ Mona Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Highlighted
Frequent Visitor

Re: Bug - Filter won't work using checkbox value unless mixed with non-delegable conditions

Yes, it's a yes no column. I will try the workaround, as long as it doesn't make it non delegable then it should be fine. I'm glad it's confirmed as I spent way too long wondering what was going on.

Helpful resources

Announcements
August 2020 Community Challenge: Can You Solve These?

August 2020 Community Challenge: Can You Solve These?

We're excited to announce our first cross-community 'Can You Solve These?' challenge!

secondImage

Return to Workplace

Reopen responsibly, monitor intelligently, and protect continuously with solutions for a safer work environment.

secondImage

Super Users Coming in August

We are excited for the next Super User season.

secondImage

Community User Group Member Badges

FIll out a quick form to claim your community user group member badge today!

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Top Solution Authors
Top Kudoed Authors
Users online (8,759)