Include checkbox in Filter

[mayarnaldo15]

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)

Any help is appreciated! 🙂 

Regards,

May

[PriyankaGeethik · Accepted solution]

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