I am facing a List threshold view limit (5000 limit) with my sharepoint. my powerapp is not loading due to this, please help to resolve.

Hi @Sowmya Mahajanam Somayajula 

Thank you for posting your question in the Microsoft Q&A forum. 

You're likely encountering the issue with this message The requested operation is invalid. Server Response: The attempted operation is prohibited because it exceeds the list view threshold enforced by the administrator. This typically happens when a Power Apps function tries to retrieve more than 5,000 items from a SharePoint list, exceeding the list view threshold. 

To avoid this issue, ensure that any columns used in filtering or sorting within Power Apps are indexed in SharePoint. This allows queries to run efficiently without hitting the threshold limit. 
To create indexed columns in SharePoint, you can follow these steps: 
Go to SharePoint site > Open your List > Gear icon > List Settings > Indexed columns > Create a new index > Select the column which is used in Filter function > Save the settings. 
Once the index is created, return to Power Apps and test your function again. The error message should no longer appear, and your app should function as expected. 
You can read more at Overview of large lists and libraries - Microsoft Support. 

I hope this helps. 

If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".   

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.