Building Access App - SharePoint list 5k limit error

[Nitecon]

We've been using one of the earliest versions of the Building Access App that Microsoft released (https://github.com/OfficeDev/microsoft-teams-apps-buildingaccess) and we have encountered an error on the app - see below:

Desk booking error

I believe this app is linked to the SharePoint list limit of 5000 records. It doesn't break the functionality of the app, but we want to avoid users reporting an "issue" when they see the error.

Does anyone have any thoughts on how to fix the error?

[zmansuri · Accepted solution]

Simple thing would be to set a Power Automate flow that archives your list entries. That way you don't exceed 5000. Another thing is Create an index for that list. Indexing column should be the one you are filtering in PowerApps. And you can only create an index when list items are less than 5000.  So delete some item, and create indexes.

https://www.c-sharpcorner.com/blogs/if-list-view-threshold-exceeds-then-how-to-handle-it-in-powerapp...