Search on grouped values

[Krishna_R]

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	Order ID Ordered By 1 MR. X 4 MR. Z
Banana	12-Nov-22	Order ID Ordered By 9 MR. A 12 MR. C

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
    )
)