Gallery with multiple filters sort by date range

(0) Share

Report

Posted on by Matt383

407

Hi,

In my gallery, i have two textinputs that filters the gallery by name and jobnumber. If nothing is entered in the textinputs, the date range sorts in descending order, however once they filter by name and or jobnumber, the dates are all over the place. Any ideas on how i can get the gallery to filter by descending date regardless of what search's are entered in the textinputs? Any help would be much appreciated.

This is what i have on the onselect of the gallery

Sort(Filter(TimeSheetCollect,StartsWith(Name, UserName.Text),
StartsWith(JobNumber,TextInput5.Text)) ,Date,SortOrder.Descending)

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (1)

Verified answer

Nogueira1306 7,390 Super User 2024 Season 1 on at

Like (1)

Report
Filter( Sort(TimeSheetCollect, Date, SortOrder.Descending), StartsWith(Name, UserName.Text), StartsWith(JobNumber,TextInput5.Text) )

If you need additional help please tag me in your reply and please like my reply.
If my reply provided you with a solution, pleased mark it as a solution ✔️!

Best regards,

Gonçalo Nogueira

Check my LinkedIn!

My website!

My blog!

Was this reply helpful? Yes No
Matt383 407 on at

Like (1)

Report

Thanks Goncalo

Was this reply helpful? Yes No