I am trying to chain two formulas together in a Gallery. Each of the filters works individually, but I can't seem to get them to work together. Like a lot of others, I have tried the ;; as well as Collect, but I still must be doing something wrong. Here are the formulas I'm trying to combine into one operation (not concurrent though):
Filter(
Users,
IsMatch(
'Full Name',
"#",
Contains
) <> true
)
and
SortByColumns(
Search([@Users],
TextSearchBox1.Text, "fullname"),
"fullname",
If(SortDescending1, Descending, Ascending))
Can someone please point me to how to do this? I must not be writing the Solutions I have found correctly.
Solved! Go to Solution.
SortByColumns(
Filter( Users, TextSearchBox1.Text in 'Full Name' && !("#" in 'Full Name') ),
"fullname", If(SortDescending1, Descending, Ascending)
)
SortByColumns(
Filter( Users, TextSearchBox1.Text in 'Full Name' && !("#" in 'Full Name') ),
"fullname", If(SortDescending1, Descending, Ascending)
)
User | Count |
---|---|
260 | |
110 | |
98 | |
56 | |
40 |