web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Apps Collection orderby spe...

Power Apps

Unanswered

Collection orderby specific column

(0) Share

Report

Report

Posted on by Flashback

145

Hello,

i need the collection order by column "CupNumber" but i have a problem with values higher than 10...

This is my formula

ClearCollect(colSamplesForExport1,SortByColumns(Filter(FTIR_samples,Run=Value(varRun),Valid=true),"CupNumber",SortOrder.Ascending))

Thank you very much

BR

Jakub

Categories:

Building Power Apps

I have the same question (0)

All responses Img

All responses (5)

Answers Img

Answers (1)

timl 36,383 Super User 2025 Season 2 on at

Like (0)

Report
Hi @Flashback

Something like this should work better for you.

ClearCollect(colSamplesForExport1, Sort(Filter(FTIR_samples,Run=Value(varRun),Valid=true), Value(Last(Split(CupNumber, "_"))), SortOrder.Ascending ) )

Was this reply helpful? Yes No
Flashback 145 on at

Like (0)

Report

Hello @timl
i receive this
Thank you very much
Jakub

Was this reply helpful? Yes No
Verified answer

timl 36,383 Super User 2025 Season 2 on at

Like (0)

Report
Hi @Flashback

Can you try this instead?

ClearCollect(colSamplesForExport1, Sort(Filter(FTIR_samples,Run=Value(varRun),Valid=true), Value(Last(Split(CupNumber, "_")).Value), SortOrder.Ascending ) )

Was this reply helpful? Yes No
Flashback 145 on at

Like (0)

Report

Yes this works 🙂

Delegation warning i received but my collection can contain max 100 records so there is no problem right?

Thanks you!

Was this reply helpful? Yes No
timl 36,383 Super User 2025 Season 2 on at

Like (0)

Report

If FTIR_samples contains more than 2000 rows, this could be a problem. In that case, you might want to populate an initial collection without the sort, and to then sort on the initial collection.

Was this reply helpful? Yes No

Join the conversation