Skip to main content

Notifications

Community site session details

Community site session details

Session Id : 7R3SISnXw3cLDKq3dwrvjj
Power Apps - Building Power Apps
Answered

Default Sorting from Newest to Oldest

Like (0) ShareShare
ReportReport
Posted on 24 Oct 2017 14:52:17 by 20

Hi Experts, 

 

I am creating an announcement list. Currently, the list is sorting from oldest to newest by default. 

List sorting.png

 

How can we set the default sorting of the lits from Newest to Oldest? What formula should be used?

 

Many thanks!

 

Best regrads, 

Tom

Categories:
  • rseiler Profile Picture
    116 on 17 Jun 2020 at 06:19:50
    Re: Default Sorting from Newest to Oldest

    Items. You could even incorporate something like the above into a filter:

     

     

    Sort(Filter(ImageLib,ID=BrowseGallery1.Selected.ID,ItemType="Image"),Modified,Descending)

     

     

  • Courtney Profile Picture
    261 on 16 Jun 2020 at 07:23:33
    Re: Default Sorting from Newest to Oldest

    Hi, I'm trying to implement the same solution and can't figure out where to insert this formula in the gallery. Could you point me in the right direction?

  • javierz Profile Picture
    186 on 12 May 2020 at 20:48:10
    Re: Default Sorting from Newest to Oldest

    Thank you

  • Channah Profile Picture
    205 on 19 Dec 2019 at 11:36:08
    Re: Default Sorting from Newest to Oldest

    Hi Mona, 

     

    I have a similar issue for data table. 

     

    Can't seem to find the "sort" function you mention from the left drop down menu on power apps. 

     

    Can you help with this? 

     

    Thanks

  • TomLU123 Profile Picture
    20 on 25 Oct 2017 at 15:49:36
    Re: Default Sorting from Newest to Oldest

    Hi Mona, 

     

    It works perfectly! 

    Many thanks for your great support!!

     

    Best regards,

    Tom

  • Verified answer
    v-monli-msft Profile Picture
    on 25 Oct 2017 at 09:56:23
    Re: Default Sorting from Newest to Oldest

    Hi @TomLU123,

     

    Find the formula on this gallery and change the sorting order from Ascending to Descending. Here's an example on how to sort by the most recent date:

    Sort(datasource,CreatedOnDateTime,Descending)

     

    Regards,

    Mona

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

Understanding Microsoft Agents - Introductory Session

Confused about how agents work across the Microsoft ecosystem? Register today!

Warren Belz – Community Spotlight

We are honored to recognize Warren Belz as our May 2025 Community…

Congratulations to the April Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 146,731 Most Valuable Professional

#2
RandyHayes Profile Picture

RandyHayes 76,287 Super User 2024 Season 1

#3
Pstork1 Profile Picture

Pstork1 66,079 Most Valuable Professional

Leaderboard
Loading started