Hi All,
I have a collection, which is grouped by fruit name on the source. and I've implemented nested galleries and trying to implement search functionality on order ID.
Fruit | Order Date | Orders Data | ||||||
Apple | 11-Nov-22 |
| ||||||
Banana | 12-Nov-22 |
|
I've tried the below function on items property. I tried the below formula however its not giving desired output.
SortByColumns(
Filter(
GroupBy(
Search(
Ungroup(
colTotalConflicts,
"gConflicts"
),
TextInputSearch_5.Text,
"RequestID"
),
"EquipmentID",
"RequestDate",
"gConflicts"
),
CountRows(gConflicts) > 1
),
"RequestDate",
If(
SDvSort.vDir = Descending,
Ascending,
Descending
)
)
User | Count |
---|---|
250 | |
105 | |
82 | |
51 | |
43 |