Showing results for 
Search instead for 
Did you mean: 
Frequent Visitor

Problem sort/filtering a gallery by date...

Hi there,


I wonder if you can help, i recently got some help with filtering and searching a gallery and the problem was solved for me except for one thing. The Sort option i wanted was to ascend and descend by Date but i also wanted to allow my team to search for a date, i can't currently get it to work, here is what i have.


My gallery is called 'BrowseGallery1_2', my data is 'BillableUtilisation' my field for the Date is called 'DateRecord' but due to the american format, i had to amend the field to the following: 'Text(ThisItem.DateRecord, "[$-en-US]dd/mm/yyyy")'.


Here is the code for the sort/filter for the Gallery:


SortByColumns(Filter(Search(BillableUtilisation,TextSearchBox1_2.Text,"ClientNameRecord","ProjectTitleRecord","VoucherPotRecord") ,StaffNameRecord = BrowseGallery1_1.Selected.b_CategoryName), "VoucherPotRecord",If(SortDescending1,Descending,Ascending))


This works fine, but if i add in "DateRecord" into that formula it will not work, is there a way i can get round this so that we can sort and search by Date?


Appreciate your help.


Thanks, Aaron




Helpful resources

PA User Group

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group

PA Community Call

Power Apps Community Call

Next call is happening on April 21st at 8a PST.


Experience what’s next for Power Apps

See the latest Power Apps innovations, updates, and demos from the Microsoft Business Applications Launch Event.

Power Platform ISV STudio

Power Platform ISV Studio

ISV Studio is the go-to Power Platform destination for ISV’s to monitor & manage applications post-AppSource publish.

Top Solution Authors
Top Kudoed Authors
Users online (95,305)