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

active Customer

hi, I would like to filter the view of our customers for an underlying column "Active" in an extra customer SP list ...

The selection is in the taskboard list ....

How do I do that? if I reference filters (customers; active <> false) directly in the box, my filter of the catalog will not work anymore
     SortByColumns (
     Filter (Sort (task board; ID; Descending);
            ; Customers.Value = ComboBox_TaskAnsicht_Search_aktiveKunden.Selected.Value)

why is that? and what is a better solution?

Kind regards

1 REPLY 1
Super User III
Super User III

@testaccPA 

Did you leave out some code when posting to the forums? SORTBYCOLUMNS had only 1 argument and did not have a closing bracket.

 

SortByColumns (
    Filter(
        Sort(taskboard; ID; Descending);
        Customers.Value = ComboBox_TaskAnsicht_Search_aktiveKunden.Selected.Value
    )
   ???;
   ???
)

 

More questions:

What SP column type is Active?

What happens when you use this code only Filter(customers; Active = true)

What happens when you use this code only Filter(customers; Active = false)

Are you trying to filter by both this Customers.Value = ComboBox_TaskAnsicht_Search_aktiveKunden.Selected.Value and Filter(customers; Active = true)?

 

---
Please click "Accept as Solution" if my post answered your question so that others may find it more quickly. If you found this post helpful consider giving it a "Thumbs Up."

Helpful resources

Announcements
New Badges

New Solution Badges!

Check out our new profile badges recognizing authored solutions!

New Power Super Users

Congratulations!

We are excited to announce the Power Apps Super Users!

Power Apps Community Call

Power Apps Community Call: February

Did you miss the call? Check out the Power Apps Community Call here.

Top Solution Authors
Top Kudoed Authors
Users online (76,741)