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 Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Welcome Super Users.jpg

Super User Season 2

Congratulations, the new Super User Season 2 for 2021 has started!

Carousel 2021 Release Wave 2 Plan 768x460.jpg

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

Top Solution Authors
Top Kudoed Authors
Users online (1,638)