You’re offline. This is a read only version of the page.
104
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
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."
Share
Report
All responses (
Answers (
