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
Power Platform Call June 2022 768x460.png

Power Platform Community Call

Join us for the next call on August 17, 2022 at 8am PDT.

Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

Users online (3,956)