Search, Filter, Sort on Gallery

(1) Share

Report

Posted on by serviceflow2

Hello!

Stuck on adding search feature to gallery of items. Have filter and sort in place with filter based on hard coded choices as seen here.

If(
    Dropdown1.Selected.Value = "On Order",
    Sort(
        Filter(
            ToolingAndSuppliesEntries,
            OnOrder = true
        ),
        Created,
        SortOrder.Descending
    ),
    Dropdown1.Selected.Value = "Not on Order",
    Sort(
        Filter(
            ToolingAndSuppliesEntries,
            OnOrder = false
        ),
        Created,
        SortOrder.Descending
    ),
    Dropdown1.Selected.Value = "All",
    Sort(
        Filter(
            ToolingAndSuppliesEntries,
            OnOrder = false Or OnOrder = true
        ),
        Created,
        SortOrder.Descending
    )
)

Need to add search based on some controls in the gallery like the following:

PONum-TextInput1

CommonName-Label1

MachineName-Label2

PartNum-Label3

Plant-Label4

Need help with where to put the search code in the above code snippet.

Have a text input in place for entering search text but stuck on how to format the code etc.

Thanks all!

Categories:

Building Power Apps

I have the same question (0)

All responses (1)

Answers (0)

Suggested answer

WarrenBelz 154,799 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!
Structure would be something like this
Search( Sort( Filter( ToolingAndSuppliesEntries, ( Dropdown1.Selected.Value = "On Order" && OnOrder ) || ( Dropdown1.Selected.Value = "Not on Order" && !OnOrder ) || Dropdown1.Selected.Value = "All" ), Created, SortOrder.Descending ), YourSearchBoxHere, YourSearchFieldsHere )

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