Answered

filter gallery by date

(0) Share

Report

Posted on by Matt383

407

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:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (1)

Jagadeeshk 457 on at

Like (0)

Report
Copy link

Link copied!

Use DOE coulmn in place of title in sort function

Was this reply helpful? Yes No
Verified answer

v-albai-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!
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

Was this reply helpful? Yes No
v-albai-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi @Matt383 ,
How are things going? Have you solved your issue?
Best regards,
Allen

Was this reply helpful? Yes No