cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Nitecon
Frequent Visitor

Building Access App - SharePoint list 5k limit error

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 errorDesk 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?

1 ACCEPTED SOLUTION

Accepted Solutions
zmansuri
Super User
Super User

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

 

 

View solution in original post

1 REPLY 1
zmansuri
Super User
Super User

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

 

 

Helpful resources

Announcements
Power Apps News & Annoucements carousel

Power Apps News & Announcements

Keep up to date with current events and community announcements in the Power Apps community.

Community Call Conversations

Introducing the Community Calls Conversations

A great place where you can stay up to date with community calls and interact with the speakers.

Power Apps Community Blog Carousel

Power Apps Community Blog

Check out the latest Community Blog from the community!

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