Answered

Sort / Search in data table not working

(0) Share

Report

Posted on by stefansc

Hi,

I'm a newbie with Powerapps. I've just created a data table from an Excel file but I'm not able to sort columns or search the data table.

In the onSelect Action of the sort button for CompanyCode I entered the formula

SortByColumns(Costcenters,"CompanyCode",Ascending)

On the search button I set the following formula in the onSelect action:

Search(Costcenters,SearchBar.Text,"Company","CompanyCode","Cost center no","Department","Description")

Neither the sort nor the search function is working.

Categories:

Building Power Apps

All responses (4)

Answers (1)

Sort by

timl 37,355 Super User 2026 Season 2 on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @stefansc

With PowerApps, we apply the data source formulas to the Items property of the control that displays the data, rather than the OnSelect property of a button.

Therefore, if you apply this formula to the Items property of your data table control, you should have more success.

Search(Costcenters, SearchBar.Text, "Company","CompanyCode","Cost center no","Department","Description" )

You can also nest these formulas. To sort the items in your data table, you can use this syntax.

SortByColumns(Search(Costcenters, SearchBar.Text, "Company","CompanyCode","Cost center no","Department","Description"), "CompanyCode", Ascending )
stefansc 89 on at

Like
a
(0)

Report
Copy link

Link copied!
Hi timl,

I've added the formula
SortByColumns(Search(Costcenters, SearchBar.Text, "Company","CompanyCode","Cost center no","Department","Description"), "CompanyCode", Ascending )
to the items property.
The search works fine but I'm not able to sort the columns.
Verified answer

stefansc 89 on at

Like
a
(0)

Report
Copy link

Link copied!

Ok, got it.
Just added
UpdateContext({Sortfield:"CompanyCode"})
UpdateContext({Sortfield:"Company"}) ....
to the onSelect action in the column header buttons and changed the items property of the data table to

SortByColumns(Search(Costcenters, SearchBar.Text,
                     "Company","CompanyCode","Cost center no","Department","Description"),
              Sortfield,
              Ascending
)

referring to the Sortfield variable.
Drrickryp Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @stefansc,
If you have the answer to your issue, please mark the discussion as solved so that others can find it.