Answered

Searching in multiple columns when already filtering based on selection on other gallery.

(0) Share

Report

Posted on by RS-29110619-0

Hi,

I'm working in the asset checkout template, and want the search to search in more than one column. The gallery is filtering on the selection from another gallery and what's in the search box, but is only searching in one column (ProductName). I would also like it to search in 'ModelNo'. Here's my code, please help!

SortByColumns(Filter(Products, And(CategoryId = CategoriesGallery.Selected.CategoryId,SearchBoxText.Text in ProductName
        )
    ),
    If(
        category = "Reviews",
        "Comments",
        "Available"
    ),
    If(
        category = "Reviews",
        SortOrder.Descending,
        SortOrder.Ascending
    )
)

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (1)

Verified answer

WarrenBelz 154,488 Most Valuable Professional on at

Like (1)

Report
Copy link

Link copied!
Hi @RS-29110619-0

Probably something like this
SortByColumns( Filter( Products, And ( CategoryId = CategoriesGallery.Selected.CategoryId, ( SearchBoxText.Text in ProductName Or SearchBoxText.Text in ModelNo ) ) ), If( category = "Reviews", "Comments", "Available" ), If( category = "Reviews", SortOrder.Descending, SortOrder.Ascending ) )

Please click Does this answer your question if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it a Like.
MVP (Business Applications) Visit my blog Practical Power Apps Buy me a coffee

Was this reply helpful? Yes No
RS-29110619-0 11 on at

Like (0)

Report
Copy link

Link copied!

Perfect, works like a dream, thank you!

Was this reply helpful? Yes No