Sort Function Stopped working

[DMillner]

I made a bonus database about 5 months back and recently it stopped working. The data source is a sharepoint list that has 5500 records, but it filters the results before displaying. Here is what I have as the code. I do not think that its an issue with the size of the list since its filtering based on the File number. There are no errors, but if I remove the Sort function it brings up all the searched data like before, but we need a way to sort from newest to oldest as shown below. Any input would be appreciated as I would think there's a way to fix this. If the issue is indeed based on the amount of records we can make additional lists to accommodate, but I'm at a loss.

Sort(
   Filter('Bonus Database',      
      (
         Len(SearchBox.Text) = 0 ||
         StartsWith(
            'File Number',
            SearchBox.Text
         )
      )&&
      'Pay Date' >=STARTDate.SelectedDate &&
      'Pay Date' <= ENDDate.SelectedDate
   ),
   'Pay Date',
   If(
      SortDescending1, 
      Descending,
      Ascending
   )
)

[KeithAtherton]

Hi @DMillner,

Are results if you use the following code, where the SortByColumns function is used (instead of the Sort function)?

SortByColumns(
   Filter('Bonus Database',      
      (
         Len(SearchBox.Text) = 0 ||
         StartsWith(
            'File Number',
            SearchBox.Text
         )
      )&&
      'Pay Date' >=STARTDate.SelectedDate &&
      'Pay Date' <= ENDDate.SelectedDate
   ),
   'Pay Date',
   If(
      SortDescending1, 
      Descending,
      Ascending
   )
)

Sort and SortByColumns functions in Power Apps reference: https://learn.microsoft.com/en-us/power-platform/power-fx/reference/function-sort

---

If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.

[DMillner]

Here is what I get when I do it verbatim. I know the SortByColumn likes to have the column title, but I found that doesnt work and throws errors.

I used the Monitor to see whats going on and even though Im filtering though the records and its returning  235 it looks like it will not actually display them. So is there another way to word this beyond making another list? 

[KeithAtherton]

Yes, the error message is useful as it suggests which column name to use (e.g. PayDate), as I'm unable to see your data source. Try updating the code to see if it has an effect.

---

If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.

[DMillner]

It says the sort can not deal with the size of the table being over 5500 items. So Im going to try and use the Switch function to see if it gets around that.

[DMillner · Accepted solution]

I was able to Index the columns of the two that we use to Filter and Sort with and this fixed the issue. Does this fix it for the foreseeable future or is there a limit to the Indexed columns as well?

[KeithAtherton]

This sounds like it's fixed it for the foreseeable future, I'm not aware of any limit to indexed columns.