Powerapps sort by choice value

(0) Share

Report

Posted on by amko77

Hi,

I need help with sorting my data in powerapps. Can I sort my gallery data by choice column values in result?

My code in Item - Gallery is:

SortByColumns(Filter('MyList';TextSearchBox1.Text in 'NameColumn1'.Value || TextSearchBox1.Text in NameColumn2.Value || TextSearchBox1.Text in 'TextColumn' || TextSearchBox1.Text in 'TextColumn2.' || TextSearchBox1.Text in 'TextColumn3'
);"SomeColumn"; If(SortDescending1; Descending;Ascending))

I wont to sort gallery by 'NameColumn1'.Value

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (1)

Verified answer

timl 36,731 Super User 2026 Season 1 on at

Like (2)

Report
Copy link

Link copied!
Hi @amko77

It's possible to sort by a choice column, but not in a delegable way. This means that if your source data contains more than 2000 rows, it won't return all your expected results.

The formula would look like this:

Sort(Filter('MyList';TextSearchBox1.Text in 'NameColumn1'.Value ||
TextSearchBox1.Text in NameColumn2.Value ||
TextSearchBox1.Text in 'TextColumn' ||
TextSearchBox1.Text in 'TextColumn2.' ||
TextSearchBox1.Text in 'TextColumn3');
'NameColumn1'.Value
)

Was this reply helpful? Yes No
amko77 36 on at

Like (0)

Report
Copy link

Link copied!

Thank you very much.

Was this reply helpful? Yes No