Filtering not working (YES/NO Column)

(0) Share

Report

Posted on by JimmyW

2,567

So I have a YES/NO column I like to filter with additional filters but it's not working, nothing is returned.

I get no warnings but nothing is returned.

Set(varMenu, "MyTickets");
 ClearCollect(
 TicketsCollection,
 Filter(
 DEViationsTickets,
 (YES/NO_Column = true)
 && (Status.Value = "Assigned") 
 )
);

Categories:

Building Power Apps

All responses (1)

Answers (1)

Verified answer

Nogueira1306 7,390 Super User 2024 Season 1 on at

Like
a
(1)

Report
Copy link

Link copied!
Try this:

Set(varMenu, "MyTickets"); ClearCollect( TicketsCollection, Filter( DEViationsTickets, YES/NO_Column = true, Status.Value = "Assigned" ) );

If you need additional help please tag me in your reply and please like my reply.
If my reply provided you with a solution, pleased mark it as a solution ✔️!

Best regards,
Gonçalo Nogueira

Check my LinkedIn!

Check my User Group (pt-PT)!