CODEWITHSUNDEEP
powerapps
vishnu
vishnu

Reputation: 347

Apply search and filter in power Apps

Here I am getting the searching results. But I want to Apply filter on Searching Results.

Here I am getting the searching results. But I want to Apply filter on Searching Results.

I have a another column name Sale Order Created. I want to show results only if this column value is 0.

How to achieve this?

I am new to power Apps. This is my First Application.

Any Help would be appreciated.

Thank you

Upvotes: 1

Views: 7212

Answers (2)

carlosfigueira
carlosfigueira

Reputation: 87228

In PowerApps most functions that operate on tables (such as Search, SortByColumns and Filter) return the searches / sorted / filtered table, so you can compose them together, by applying one function to the result of the other. For example, in your case, you can Filter the result of the Search, by using the latter's result as the first parameter of the former, as shown below.

SortByColumns(
    Filter(
        Search(
            '[dbo].[Efftronics Systems Pbt Ltd_,$Sales Header]',
            TextSearchBox1.Text,
            "No_"),
        'Sale Order Created' = 0),
    "No_",
    If(SortDescending1, Descending, Ascending))

Upvotes: 3

aozk
aozk

Reputation: 418

Use Filter

Search(Filter('[dbo]...', column_name = 0),...

Upvotes: 0

Related Questions