Skip to main content

Notifications

Power Apps - Building Power Apps
Answered

Sort SharePoint List!

Posted on by 109

Hello,

I have a SP list which is sorted by date with the code (is greater than [Today]). But unfortunately then you can't see the past events.

My wish would be if I could sort by date and (is greater than [Today]) so that the most recent event is at the top, but all past events should slide to the bottom.

How can I do that? Thanks a lot!

Categories:
  • Verified answer
    Heidi04 Profile Picture
    Heidi04 109 on at
    Re: Sort SharePoint List!

    Too bad - thank you anyway!

  • Re: Sort SharePoint List!

    Hi @Heidi04,

    Hope you could check my reply one more time.

    I repeat it one more time, that you could only display limitted records in the SharePint view based on your condition.

     

    If you want to display records in your custom sort order, I am sorry that the answer is no, it is not possible to achieve this in SharePoint view.

     

     

  • Heidi04 Profile Picture
    Heidi04 109 on at
    Re: Sort SharePoint List!

     

    Yes, I would like to always see the current date with the events at the top and then have all past events slide to the bottom.

    However, it is not displaying it correctly for me.

    Heidi04_0-1687155570168.png

     

  • Re: Sort SharePoint List!

    Hi @Heidi04,

    That's depends.

    We could set two conditions, one for records is greater than today, the other for records is less than today, combining them using an "Or" operator. 

    However, if you only have records that is less than today, you could only get the records that is less than today, not sure if it is what you want to achieve.

     

    vqiaqimsft_0-1687154633560.png

    vqiaqimsft_1-1687154705573.png

     

     

  • Heidi04 Profile Picture
    Heidi04 109 on at
    Re: Sort SharePoint List!

    Hi,

    I already had that, but then you don't see the past events. But I would like it so that you can still see them.

     

    Start
    06/28/2023 This is the current event
    08/11/2023
    09/17/2023
    09/10/2024
    05/01/2023 These are the past events
    07/02/2023

  • Re: Sort SharePoint List!

    Hi @Heidi04,

    Please create a view and edit the view as below:

    vqiaqimsft_3-1687153253765.png

     

    vqiaqimsft_1-1687153183579.png

    vqiaqimsft_2-1687153225914.png

     

     

     

  • Heidi04 Profile Picture
    Heidi04 109 on at
    Re: Sort SharePoint List!

    But I don't need this in PowerApp but in he SP list directly.

  • Re: Sort SharePoint List!

    Hi @Heidi04,

    Could you please checked my reply one more time?

    I have mentioned all the details on how you locate your error and how to troubleshoot it, please replace the List with your real list name.

     

    Try and believe in yourself.

    Good luck.

  • Heidi04 Profile Picture
    Heidi04 109 on at
    Re: Sort SharePoint List!

    Good morning,

    I need it to sort the SP list itself.

     

    Thank you so much for your help.

  • Heidi04 Profile Picture
    Heidi04 109 on at
    Re: Sort SharePoint List!

    Good morning,

    I need it to sort the SP list itself. 

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

November 2024 Newsletter…

November 2024 Community Newsletter…

Community Update Oct 28…

Power Platform Community Update…

Tuesday Tip #7 Community Profile Tips…

Welcome to a brand new series, Tuesday Tips…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 143,591

#2
RandyHayes Profile Picture

RandyHayes 76,308

#3
Pstork1 Profile Picture

Pstork1 64,090

Leaderboard