Hi @john john ,
You could try to add index column as a workaround to solve this issue.
List settings > Columns > Indexed columns > Create a new index
Note: Automatic index creation when sorting in the modern experience is limited to lists and libraries with less than 20,000 items.
For Reference:
https://support.microsoft.com/en-us/office/add-an-index-to-a-list-or-library-column-f3f00554-b7dc-44d1-a2ed-d477eac463b0
https://www.softlanding.ca/blog/overcoming-5000-item-list-view-threshold-sharepoint-online/
Note: Microsoft is providing this information as a convenience to you. The sites are not controlled by Microsoft. Microsoft cannot make any representations regarding the quality, safety, or suitability of any software or information found there. Please make sure that you completely understand the risk before retrieving any suggestions from the above link.
If an Answer is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.