Sort number

(0) Share

Report

Posted on by JoseC12

390

Good afternoon,

I have a gallery which I want to sort it by planned hours. I put this:

SortByColumns(
 Filter(
 SERVICIO;
 StartsWith(
 DESCRIPCIÓN;
 TextSearchServicio.Text
 );
Value("HORAS_x0020_PLANEADAS");
 If(
 Btn_OrdenarServicioHorasPlan;
 Ascending;
 Descending
 )
)

I put Value("Horas..."), but it returns an error that it requires Text type.

How can I fix it?

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (1)

WarrenBelz 154,481 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

Hi @JoseC12
Have you tried without the Value().
If it already numeric, you do not need this.

Please click Accept as solution 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 Thumbs Up.

Was this reply helpful? Yes No
Verified answer

timl 36,715 Super User 2026 Season 1 on at

Like (2)

Report
Copy link

Link copied!
Hi @JoseC12

The SortByColumns requires us to pass a string column name.

In order to sort by a formula, we would use the Sort function rather than SortByColumns.

Sort( Filter( SERVICIO; StartsWith( DESCRIPCIÓN; TextSearchServicio.Text ); Value("HORAS_x0020_PLANEADAS"); If( Btn_OrdenarServicioHorasPlan; Ascending; Descending ) )

Was this reply helpful? Yes No
JoseC12 390 on at

Like (0)

Report
Copy link

Link copied!

@timl
Alright it works, but how about if I want to sort twice or more in the same gallery, I mean not only sort hours, also title, or more columns. Thanks

Was this reply helpful? Yes No
WarrenBelz 154,481 Most Valuable Professional on at

Like (2)

Report
Copy link

Link copied!

@timl is correct on the bit missing - you should accept his solution.
Have you solved your original error you referred to - I was focused on that in my response.

Was this reply helpful? Yes No