Answered

sort by ascending order in gallery

(0) Share

Report

Posted on by Matt383

407

Hi, having some issues trying to get my gallery to sort a field by ascending order. I currently have my galley filtered,

Filter(ProcedureCollect, Arrangement = Label77.Text && Engine = Label86.Text)

but would also like to have it show the gallery results in ascending order from a field in the gallery called 'Sequence', something like below.
Filter(ProcedureCollect, Arrangement = Label77.Text && Engine = Label86.Text),Sort(Sequence,SortOrder.Ascending)
(The collection is from a sharepoint library and the sequence field is a number field). I have tried a few variations without luck, any assistance would be much appreciated

Categories:

Building Power Apps

I have the same question (0)

All responses (5)

Answers (1)

zmansuri 6,048 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

SortByColumn(Filter(ProcedureCollect, Arrangement = Label77.Text && Engine = Label86.Text),"Sequence",Ascending)

Was this reply helpful? Yes No
turnerj3 2,039 on at

Like (0)

Report
Copy link

Link copied!

Try this:
Sort(Filter(ProcedureCollect, Arrangement = Label77.Text && Engine = Label86.Text),Sequence,Ascending)

Was this reply helpful? Yes No
Matt383 407 on at

Like (0)

Report
Copy link

Link copied!

Thanks for getting back to me turnerj3, results above

Was this reply helpful? Yes No
Verified answer

turnerj3 2,039 on at

Like (1)

Report
Copy link

Link copied!

@Matt383 ,
Make sure you put the filter inside of Sort().
See @zmansuri response as well. It should work also.

Was this reply helpful? Yes No
Matt383 407 on at

Like (0)

Report
Copy link

Link copied!

Thanks turnerj3, i missed that 😉 Added the missing sort and worked with Sequence,SortOrder.Ascending

Was this reply helpful? Yes No