Microsoft Lists begins general availability roll out to Microsoft 365

Hello Mark-Kashman thanks for the reply. Both articles you mentioned are interesting and contain very useful information for handling and planning large lists. Thanks for sharing!

What I would like to have however is for end users and developers to be able to access SharePoint Lists and Libraries without having to worry about these best practices that are very important given the 5000 itens list view threshold.

This is what I would like:

• End users be able to see all items in a List or Library without ever the List View Threshold being an issue
• Developers and solution architects as my self to be able to design solutions that don't have to be more complex because we know the 5000 list view threshold exists. All APIs, namely CSOM and Rest APIs or any other APIs that access SharePoint data should be able to query Lists with 30 millions (not returning this amount of data but querying it)

I don't know any enterprise solution that has this limitation. With SharePoint Lists being the best Back-office I know for custom solutions and SharePoint libraries be part of one of the most complete document management systems I know, this limitation should simplify not exist at all. Because of this limitation, many times we must store information elsewhere or implement more complex solutions (that customers have to pay for) to workaround the 5000 list view threshold. 

I love SharePoint, I really do but I always see new amazing features being rolled out at an incredible pace but this limitation is part of SharePoint for more than 10 years and Microsoft despite some good efforts to address the limitation was not yet able to solve the problem at it's heart. 

I know this is a huge undertaking but  end users, developers and solution architects would thank you If this limitation was completely removed because it doesn't makes sense. I believe this can only be achieved by changing the way SharePoint stores and queries data in SQL Server since having all data from a site collection stored in the same table (AllUserData) is not the best architectural design.

Please solve this limitation for good! We love SharePoint and this is the single most annoying limitation that the product has!

I hope you can understand where I am coming from!

Is what I am asking possible and in Microsoft roadmap for the product? If yes, when can we expect these changes?

The solution can be completely different from what I am suggesting, the important thing would be to have this limitation completely removed from this amazing platform.

Edit: where do Microsoft Lists fit with the announcements of Data Flex for Power Platform + Teams? It seems to me that MS is going very fast towards Teams and Power Platform and would like to know in which cases solutions using Lists and SharePoint as a developnent platform should be considered after this annoucements? When to use Lists and SharePoint and when to use  Power Platform + Teams + DataFlex? So many options, so much more difficult to choose from :).

Thanks