cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
JimmyWork
Power Participant
Power Participant

Filtering not working (YES/NO Column)

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") 
            )
);

 

 

1 ACCEPTED SOLUTION

Accepted Solutions
Nogueira1306
Community Champion
Community Champion

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)!

View solution in original post

1 REPLY 1
Nogueira1306
Community Champion
Community Champion

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)!

View solution in original post

Helpful resources

Announcements
PA_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

secondImage

Power Apps Community Call

Please join us on Wednesday, October 20th, at 8a PDT. Come and learn from our amazing speakers!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Welcome Super Users.jpg

Super User Season 2

Congratulations, the new Super User Season 2 for 2021 has started!

Carousel 2021 Release Wave 2 Plan 768x460.jpg

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

Top Solution Authors
Top Kudoed Authors
Users online (1,576)