Please help with formula to sort BrowseGallery1 by 'Date of Service'

[JPeter]

Hello,

I've watched several tutorial videos and read through a few web sites but can't figure this out.

I'd like to sort the List entries in the App interface by the Date of Service column with the newest at the top and sort to the oldest.

Any help would be appreciated!

[WarrenBelz]

Hi @JPeter ,

Just replace the Title Sort

SortByColumns(
   Filter(
      [@'SALS Demo'], 
      StartsWith(
         Title, 
         TextSearchBoxl.Text
      )
   ), 
   "Date of Service",
   SortOrder.Ascending
)

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

MVP (Business Applications)   Visit my blog Practical Power Apps

[JPeter]

Thanks, @WarrenBelz. I think I understand what you're telling me. While I did try inputting that function as is into my BrowseGallery1, it broke the app. Since I'm trying to sort by the date that's in the Body1 object, I did try editing your function for that, but it didn't work either. I'm hopeful the following screenshots help to further clarify my app.

[WarrenBelz]

@JPeter ,

There is no error on the Items code - what is the error on the labels ?

[JPeter]

@WarrenBelz 

I hope these screenshots provide you with the information you need.

[WarrenBelz]

@JPeter ,

If it is saying ThisItem is not recognised, that makes no logical sense to me. I assume 'Date of Service' is a Date/Time field and you are using SharePoint.

[JPeter]

@WarrenBelz 

Yes to both.

[WarrenBelz]

@JPeter ,

Just noticed you are missing a comma after the sort field name.

[JPeter · Accepted solution]

@WarrenBelz , I found the solution!

And I can't believe how easy it was. What I've learned from working with you is what to search for, so a fresh google search found the solution that I need, and it was in this video: https://youtu.be/KIaQE3sA55U?si=lve_jW_iThbSBW6i

Here's the solution. I'm feeling like a goof that it was easier than I believed it to be. While you can't see the older items in  the list, it does sort them all in the correct order.

[WarrenBelz]

@JPeter ,

Where has the filter on Title gone ? That is not actually the answer to the question you posted (what I posted was) - also Sort/SortByColumns are interchangeable