News and Announcements icon

Power Platform CommunityForums Power Apps - Building Power Apps Collection orderby spe...

Power Apps - Building Power Apps

Answered

Collection orderby specific column

(0) Share

Report

Report

Posted on by Flashback

124

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:

General Questions

All responses Img

All responses (5)

Answers Img

Answers (1)

timl 35,189 Super User 2025 Season 1 on at

Like (0)

Report

Re: Collection orderby specific column

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.
Flashback 124 on at

Like (0)

Report

Re: Collection orderby specific column

Yes this works 🙂

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

Thanks you!
Verified answer

timl 35,189 Super User 2025 Season 1 on at

Like (0)

Report
Re: Collection orderby specific column

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 ) )
Flashback 124 on at

Like (0)

Report

Re: Collection orderby specific column

Hello @timl
i receive this
Thank you very much
Jakub
timl 35,189 Super User 2025 Season 1 on at

Like (0)

Report
Re: Collection orderby specific column

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 ) )