SharePoint Online & Power Apps performance improvments..

john john Pter 405 Reputation points
2025-02-02T23:19:51.3233333+00:00

Hi , I have a power apps canvas application with a gallery that sort SharePoint list items by Modified & Created Date, where i can dynamically chose the sort field. the SharePoint list contain around 1,250,000 items, And around 3 years ago when i built the app, showing the items when the app loads was taking around 5-6 seconds, i tired this today and it loads the data in less than 2 seconds. so has SharePoint online and power apps performance improved in the last 3 years? is there any graph ?

Second question, also 3 years ago when i tried to add an index column to the list i got an error that i can not add an index on a large list, but today i were able to add a new index to the list which contain more than 1 million items .. so has this improved also?

Thanks

SharePoint Development
SharePoint Development
SharePoint: A group of Microsoft Products and technologies used for sharing and managing content, knowledge, and applications.Development: The process of researching, productizing, and refining new or existing technologies.
3,265 questions
0 comments No comments
{count} votes

1 answer

Sort by: Most helpful
  1. RaytheonXie_MSFT 38,646 Reputation points Microsoft Vendor
    2025-02-03T07:13:34.1633333+00:00

    Hi @john john Pter

    The max number of index has been increased to 20 million items as default and you could increase the number by contact Microsoft Support. You could refer to the document

    User's image

    https://learn.microsoft.com/en-us/sharepoint/search-limits

    While I don't have a graph about sharepoint and power app improved display large data list, I can confirm that Microsoft has been consistently working on enhancing the performance and scalability of their cloud services like SharePoint Online and Power Apps.


    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.


Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.