Skip to main content

Notifications

Power Apps - Building Power Apps
Answered

filter gallery by date

(0) ShareShare
ReportReport
Posted on by 395

Hi, have an app generated from a sharepoint list. In the gallery the items is set to,
SortByColumns(Filter([@JobRegister], StartsWith(Company, TextSearchBox1.Text)), "Title", If(SortDescending1, Descending, Ascending))

I have a date field named DOE and want the sort icon to show most recent date

The sort icons Onselect is set to UpdateContext({SortDescending1:true})

 

Categories:
  • v-albai-msft Profile Picture
    v-albai-msft on at
    Re: filter gallery by date

    Hi @Matt383 ,

    How are things going? Have you solved your issue?

    Best regards,

    Allen

  • Verified answer
    v-albai-msft Profile Picture
    v-albai-msft on at
    Re: filter gallery by date

    Hi @Matt383 ,

    As @Jagadeeshk suggested, if you want to sort by DOE column, you should use this column inside your Sort formula. So try to use this formula of your gallery:

    SortByColumns(Filter([@JobRegister], StartsWith(Company, TextSearchBox1.Text)), "DOE", If(SortDescending1, Descending, Ascending))

    Best regards,

    Allen

     

  • Jagadeeshk Profile Picture
    Jagadeeshk 457 on at
    Re: filter gallery by date

    Use DOE coulmn in place of title in sort function 

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,434

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 64,722

Leaderboard