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

Answered

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)

Sort by

timl 36,813 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!
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
Copy link

Link copied!

Hello @timl
i receive this
Thank you very much
Jakub

Was this reply helpful? Yes No
Verified answer

timl 36,813 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!
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
Copy link

Link copied!

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,813 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

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