cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
mayarnaldo15
Helper I
Helper I

Include checkbox in Filter

Hi,

Both codes are working properly separately. I just don't know how I combine the two.

 

I have filter function by Department

SortByColumns(
    Filter(
        QAOversightApp,
        Department = DeptDropdown.SelectedText.Result
      
    ),
    "Modified",
    Descending
)

 

After filtering the department, I have to show the list with Follow-up only. The column type of Follow-up in Sharepoint list is Boolean

If(Checkbox1.Value=true, Filter(QAOversightApp, 'Follow-up' <> false), QAOversightApp)

 

mayarnaldo15_0-1634199751858.png

 

Any help is appreciated! 🙂 

Regards,

May

 

1 ACCEPTED SOLUTION

Accepted Solutions
PG_WorXz10
Community Champion
Community Champion

Hi @mayarnaldo15 ,

 

Something like below code will work in your case ? 

 

If(Checkbox1.Value=true, SortByColumns(Filter(QAOversightApp, Department = DeptDropdown.SelectedText.Result && 'Follow-up' <> false),
    "Modified",
    Descending
), SortByColumns(
    Filter(
        QAOversightApp,
        Department = DeptDropdown.SelectedText.Result
      
    ),
    "Modified",
    Descending
))

 

 

 

If this post was helpful or you need more help please consider giving Thumbs Up and Tag me in your reply I'll be happy to help. If this post helped you solve your issue please click Accept as solution and provide Thumbs Up. This will help others find it more readily.

View solution in original post

1 REPLY 1
PG_WorXz10
Community Champion
Community Champion

Hi @mayarnaldo15 ,

 

Something like below code will work in your case ? 

 

If(Checkbox1.Value=true, SortByColumns(Filter(QAOversightApp, Department = DeptDropdown.SelectedText.Result && 'Follow-up' <> false),
    "Modified",
    Descending
), SortByColumns(
    Filter(
        QAOversightApp,
        Department = DeptDropdown.SelectedText.Result
      
    ),
    "Modified",
    Descending
))

 

 

 

If this post was helpful or you need more help please consider giving Thumbs Up and Tag me in your reply I'll be happy to help. If this post helped you solve your issue please click Accept as solution and provide Thumbs Up. This will help others find it more readily.

Helpful resources

Announcements
October Events

Mark Your Calendars

So many events that are happening this month - don't miss out!

Ignite 2022

WHAT’S NEXT AT MICROSOFT IGNITE 2022

Explore the latest innovations, learn from product experts and partners, level up your skillset, and create connections from around the world.

Power Apps Africa Challenge 2022

Power Apps Africa Challenge

Your chance to join an engaging competition of Power Platform enthusiasts.

Users online (3,551)