Scenario
If you have been using PowerApps apps with SharePoint list for a long time, then you might have come across a situation where data in the list has gone beyond 5000 items and you have started facing problems with your app. Yes, the ListView threshold has been met. At that point, your app will stop working. Let us see how to fix this problem.
Solution
On the below screen, you can see the error details which I am getting when my ListView threshold is reached.
The error states that, "The requested operation is invalid. Server Response: The attempted operation is prohibited because it exceeds the list view threshold enforced by the administrator."
This is my list with almost 5350 items.
So, to fix this issue, we need to create indexed columns in the SharePoint list. If you are not using any filter while pulling data, then you must start using that.
Make use of the Filter function to pull data from any data source in PowerApps. This function will pull only the required data.
So, whatever columns you are using in Filter function, those need to be indexed in SharePoint.
How to create indexed columns in SharePoint list?
Go to SharePoint site >> List Settings >> Indexed columns >> click on “Create a new index”. Select the column which is used in Filter function. Save the settings. Go back to PowerApps and check the function again. The error is gone now. Your app will start working again.