Answered

PowerApps Search and Sort Gallery

(0) Share

Report

Posted on by tjestesjr

145

I have a PowerApps application that I have implemented sorting on columns of a gallery, but now the requirement is to also be able to search across the columns in the gallery. How do I add "Search" to the code below?

Switch(
locSortColumn,
"DataSource", Sort( Filter(KED_DistributorItems,KED_BrandItemId=Blank()), DataSource, If(locSortAscending, SortOrder.Ascending, SortOrder.Descending)),
"MfgrName", Sort(Filter(KED_DistributorItems,KED_BrandItemId=Blank()), MfgrName, If(locSortAscending, SortOrder.Ascending, SortOrder.Descending)),
"MfgrItemCode", Sort(Filter(KED_DistributorItems,KED_BrandItemId=Blank()), MfgrItemCode, If(locSortAscending, SortOrder.Ascending, SortOrder.Descending)),
"ProductNumber", Sort(Filter(KED_DistributorItems,KED_BrandItemId=Blank()), ProductNumber, If(locSortAscending, SortOrder.Ascending, SortOrder.Descending)),
"ProductDescription", Sort(Filter(KED_DistributorItems,KED_BrandItemId=Blank()), ProductDescription, If(locSortAscending, SortOrder.Ascending, SortOrder.Descending)),
"Created", Sort(Filter(KED_DistributorItems,KED_BrandItemId=Blank()), Created, If(locSortAscending, SortOrder.Ascending, SortOrder.Descending)),
"LastTrans", Sort(Filter(KED_DistributorItems,KED_BrandItemId=Blank()), LastTransactionDate, If(locSortAscending, SortOrder.Ascending, SortOrder.Descending)),
"LastSpend", Sort(Filter(KED_DistributorItems,KED_BrandItemId=Blank()), Last12MonthSpend, If(locSortAscending, SortOrder.Ascending, SortOrder.Descending)),
Sort(Filter(KED_DistributorItems,KED_BrandItemId=Blank()), Created, SortOrder.Descending)
)

Categories:

Building Power Apps

I have the same question (0)

All responses (8)

Answers (1)

jlk1 88 on at

Like (0)

Report
Copy link

Link copied!

Not fully sure if it would work but putting a text input and then adding "StartsWith(Title, TextSearchBox1.Text)" to the filters should work?

Was this reply helpful? Yes No
tjestesjr 145 on at

Like (0)

Report
Copy link

Link copied!

The requirement is to have 1 text box to search across all columns.

Was this reply helpful? Yes No
madlad 2,637 Moderator on at

Like (0)

Report
Copy link

Link copied!

You likely want to use the Search function, probably wrapped around your current statement, with one text input and all necessary columns specified.

Was this reply helpful? Yes No
tjestesjr 145 on at

Like (0)

Report
Copy link

Link copied!
So I wrapped my Sort function in a Search function and the Search works by itself but then causes the Sort function to fail.

Search( Switch( locSortColumn, "DataSource", Sort( Filter(KED_DistributorItems,KED_BrandItemId=Blank()), DataSource, If(locSortAscending, SortOrder.Ascending, SortOrder.Descending)), "MfgrName", Sort(Filter(KED_DistributorItems,KED_BrandItemId=Blank()), MfgrName, If(locSortAscending, SortOrder.Ascending, SortOrder.Descending)), "MfgrItemCode", Sort(Filter(KED_DistributorItems,KED_BrandItemId=Blank()), MfgrItemCode, If(locSortAscending, SortOrder.Ascending, SortOrder.Descending)), "ProductNumber", Sort(Filter(KED_DistributorItems,KED_BrandItemId=Blank()), ProductNumber, If(locSortAscending, SortOrder.Ascending, SortOrder.Descending)), "ProductDescription", Sort(Filter(KED_DistributorItems,KED_BrandItemId=Blank()), ProductDescription, If(locSortAscending, SortOrder.Ascending, SortOrder.Descending)), "Created", Sort(Filter(KED_DistributorItems,KED_BrandItemId=Blank()), Created, If(locSortAscending, SortOrder.Ascending, SortOrder.Descending)), "LastTrans", Sort(Filter(KED_DistributorItems,KED_BrandItemId=Blank()), LastTransactionDate, If(locSortAscending, SortOrder.Ascending, SortOrder.Descending)), "LastSpend", Sort(Filter(KED_DistributorItems,KED_BrandItemId=Blank()), Last12MonthSpend, If(locSortAscending, SortOrder.Ascending, SortOrder.Descending)), Sort(Filter(KED_DistributorItems,KED_BrandItemId=Blank()), Created, SortOrder.Descending) ),txtDistItemsSrch.Text,"DataSource")
Any ideas on how to get both functionalities to work?

Was this reply helpful? Yes No
madlad 2,637 Moderator on at

Like (0)

Report
Copy link

Link copied!

Maybe try wrap a search() around each sort, to avoid having the switch within a search?

Was this reply helpful? Yes No
Verified answer

mfvelazquez 17 on at

Like (1)

Report
Copy link

Link copied!
Use the SortByColumns function instead.
You can also use the With function to improve the readability of the formula.
The following formula should work.

With( { wLocSortColumn:locSortColumn, wFilteredData: Filter(KED_DistributorItems,KED_BrandItemId=Blank()) } SortByColumns( Search( wFilteredData, txtDistItemsSrch.Text, "DataSource", "MfgrName", "MfgrItemCode", "ProductNumber", "ProductDescription", "Created", "LastTransactionDate", "Last12MonthSpend", ), wLocSortColumn, If(locSortAscending,SortOrder.Ascending,SortOrder.Descending) ) )

Was this reply helpful? Yes No
tjestesjr 145 on at

Like (0)

Report
Copy link

Link copied!

I have implemented sorting by each column in the application within the gallery using a chevron icon (see screenshot above). I am not sure how to implement the SortByColumns with these control, can you explain further?

Was this reply helpful? Yes No
mfvelazquez 17 on at

Like (1)

Report
Copy link

Link copied!

Use the formula as I wrote it. It should work.

The SortByColumns is using the wLocSortColumn dynamic value that is getting value from your LocSortColumn variable I think you're setting up using the Chevron icon.

Was this reply helpful? Yes No