web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / sort by ascending orde...
Power Apps
Answered

sort by ascending order in gallery

(0) ShareShare
ReportReport
Posted on by 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:
I have the same question (0)
  • zmansuri Profile Picture
    6,048 Super User 2024 Season 1 on at

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

  • turnerj3 Profile Picture
    2,039 on at

    Try this:

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

  • Matt383 Profile Picture
    407 on at

    Matt383_0-1682566961093.pngMatt383_1-1682566991659.pngMatt383_2-1682567022241.png

    Thanks for getting back to me turnerj3, results above

  • Verified answer
    turnerj3 Profile Picture
    2,039 on at

    @Matt383 , 

    Make sure you put the filter inside of Sort().

    See @zmansuri response as well. It should work also.

  • Matt383 Profile Picture
    407 on at

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

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Users!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 93 Most Valuable Professional

#2
Haque Profile Picture

Haque 81

#3
Valantis Profile Picture

Valantis 49

Last 30 days Overall leaderboard