Skip to main content

Notifications

Power Apps - Building Power Apps
Answered

Sort By Columns- Specific Date Value

(1) ShareShare
ReportReport
Posted on by

I was trying to follow the tutorial listed at: https://powerapps.microsoft.com/en-us/tutorials/function-sort/ 

 

However, I was having issues with sorting a specific column by a specific value. Similar to the tutorial, I wanted to sort my listings to only those that would have an "EventDate" equal to Today().

 

Here is my original code:

 

SortByColumns(Search(Table2, TextSearchBox1.Text, "EventName", "LastName", "FirstName"), "EventDate", If(SortDescending1, Descending, Ascending))

 

I would like it to be something like: "EventDate", [Today()] -- Not sure if it's supposed to be ["Today"] I tried both and couldn't get it working.

 

Thanks for all of your help!

Categories:
  • v-yamao-msft Profile Picture
    v-yamao-msft on at
    Re: Sort By Columns- Specific Date Value

    Hi Austinct,

     

    I am glad to hear that you have figured out a solution.


    And thanks for sharing it with us.

     

    Anytime you have issues when using PowerApps, please feel free post your issue at here, we are always ready to help.

     

    Best regards,
    Mabel Mao

  • Verified answer
    Re: Sort By Columns- Specific Date Value

    Sorry, I answered my own question. I used filter and it works properly.

     

    The app is for an event check in. So depending on the last name they enter into the search textbox, and if the event is today, it allows them to check in.

     

    If any one needs help, here's the code I used:

     

    Filter(Table2, LastName = TextSearchBox1.Text, EventDate = Today())

  • Re: Sort By Columns- Specific Date Value

    Should I try to use Filter instead of SortByColumns?

     

    Thank you!

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

Microsoft Kickstarter Events…

Register for Microsoft Kickstarter Events…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Announcing Forum Attachment Improvements!

We're excited to announce that attachments for replies in forums and improved…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 145,495

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 64,822

Leaderboard