Unanswered

Total rows in SP which can be loaded in PowerApps

(0) Share

Report

Posted on by keihimekawa

Hi everyone,

I'm in the process of creating an app and after my demo, I was just informed that they are planning to load around 100k rows of data in a SP list. If my filtering is in place, around 8k data will be loaded at one time. I'm worried that if I pull everything in one go, the app might freeze and it might cause some performance issue. I know I should be testing this but I don't have the data currently.

Some questions I have in mind:

Is there a number of rows PowerApps can pull in a particular gallery? I read somewhere that it's 500 but just in case I have 8k rows in a gallery and did a "Search" formula, will I still be able to get the data I need considering, for example, said data is in row 5,678.
If I load the SP List initially in a collection, what's the total number of row it can retrieve? Will it still be 500?
Can I load multiple SP List in a collection? I'm thinking of separating 100k rows into different SP lists based on a particular column.
Is there any other way around so that the app won't freeze in initial load? I'll be displaying 20+ fields per item.

Would greatly appreciate it if anyone can share some references, sources or readings regarding this matter.

Thanks!

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (0)

Drrickryp Super User 2024 Season 1 on at

Like (0)

Report

Hi @keihimekawa

To use very large lists in SharePoint efficiently, you must use delegatable functions only: https://powerapps.microsoft.com/en-us/blog/sharepoint-delegation-improvements/ . When you reach an impass because there are functions that you want to use that are not delegatable, my suggestion would be to move to SQL or CDS to store your data.

Was this reply helpful? Yes No
FlowMohit 64 on at

Like (1)

Report
Hi,
Please find below my inline comments -

Is there a number of rows PowerApps can pull in a particular gallery? I read somewhere that it's 500 but just in case I have 8k rows in a gallery and did a "Search" formula, will I still be able to get the data I need considering, for example, said data is in row 5,678.[yes power apps will load the first 500 records in the gallery but as will scroll down it will start to show more. Search function is not delegable to SharePoint which means it cannot work with large data set so you need to use the combination of filter function along with startwith]
If I load the SP List initially in a collection, what's the total number of row it can retrieve? Will it still be 500?[by default its 500 but you can set it up to 2k. Just go to Your App Setting > Advanced Setting > Data row limit to nondelegable query.]
Can I load multiple SP List in a collection? I'm thinking of separating 100k rows into different SP lists based on a particular column.[If the lists have same schema then you can use collect. Loading a large amount of data in collections is not a good idea. ]
Is there any other way around so that the app won't freeze in initial load? I'll be displaying 20+ fields per item. [Try using concurrent function while fetching the data from the data source - https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/functions/function-concurrent ]

here is a nice video about how to work with large data in sharepoint - https://www.youtube.com/watch?v=gwiErbYtRdA

Was this reply helpful? Yes No