Power Apps With Large Data Sets

Here's my vBlog about Power Apps performance with large data sets with 44K+ rows/items. I then tested functions & the results pleasantly surprised me. I'm confident this will clear some doubts & concerns you might have.

Important Link-

Here's the link to the Xrm Tool Box which is free -

Interested in my blogging gear? Then take a look at them on Amazon:

[AISHWAR]

This is really a great video. Today I worked with around 100k rows of data on on prem sql server and the app behaved fairly that too without any filtering. Filtering definitely going to optimise it.

[kevwlew]

Man...this is awesome! Pulling data from a SharePoint list that currently has 192, 807 records. Added a ComboBox & Text Input Box, and wow! Thanks Daniel.

[jigsaw]

Great content, should be great if you show us how you built the App, the hidden fields showing by clicking the edit button in each row looks interesting to get. Thank you.

[rsaikrishna]

Very nice demo Daniel. I recommend App makers to index the columns in the data source. Indexing improves the filter and search functionality. Data sources like SharePoint will NOT let you perform Filter or Search operations on the the data after it reaches 20K items if we do not index the columns. Power Apps just passes the commands such as Filter, Search to the data source. Its data source capability whether it can perform it or not. During app creation process, we must consider the delegation while creating the type of columns.

[sushichow]

It’s like gold mine as I keep on digging I am able to find amazing content in Daniel videos.

[WillCooper]

This helped a lot! I am getting ready to run up against a situation with a customer app where the SharePoint list is growing and I need to adjust the search and filters. Thanks for the great ideas.

[NelsonYYZ]

Daniel, this is such a great video. Thank you SO MUCH for putting this together. So informative

[austinleedavisTeaches]

"Import Spreadsheet" app. You get a like for that alone! :) Thank you also for showing an AND in the Filter function for SharePoint.

[manikyakotni]

This is what am looking for. Great video Daniel. Appreciate your knowledge sharing.

[ajitdas]

Thanks Daniel for awesome session, my doubt go clear

[radiosonicfan]

What formula did you use for the drop down filter with counties? I am trying to recreate tried distinct(data source, column) but I couldn't get to work.

[andrewsmalley]

Thanks Daniel, brilliant video - just what I needed!

[MrAfzalaziz]

I never saw this major con of Power apps discussed anywhere that multiple users cannot work on the same app at same time.

[FamEkin]

Hello Daniel, love your videos and easy to understand explanations. But I have a question, that is also asked by other people here, that's about the filter County (26:00), you don't show what query you use? Because of the large dataset, not all rows will return, so how did you fixed that in the demo?
I had also a large Sharepoint database and I distinct one row and copied these items in a new Sharepoint-list with only one column, added this datasource to my PowerApp and used that dataset on the filter as u use County filter.
But how did you filter County with only one large Sharepoint Dataset?

[seegeat]

Great Content, Daniel....very clearly and hope you always productive to create another power apps content

[anandasuresh]

Amazing this is solution I'm looking for, thank you so much

[ShyamKumar-rlrw]

Thank you. Very informative. Can you please make detailed video of how CDS should be created? And bring in to power app from scratch? And azure SQL table also. I am aware of sharepoint. Thank you 🙏

[jhoncarlospenaarias]

i need some help. I am doing a lookup search in a CDS database with more than 200k records, but if I search for a record that is in row 200k it does not give me a result, I must first do a search for a record that is in row 198k and then do the search for the 200k row so that I get the result.

[dragonjad]

This is such a good video - I have been trawling through endless forums trying to figure this out and you managed to save me in just 30 minutes. Thank you!

Just as a question, what is your patch() formula for the Save button on the CDS screen? Are you able to share this in another video?

[PravinGumgaonkar-br]

Its nice article and very explain in short and simple. Thanks You so much.