- Tubelator AI
- >
- Videos
- >
- Science & Technology
- >
- How to Load More Than 2000 Rows in PowerApps: A Step-by-Step Guide
How to Load More Than 2000 Rows in PowerApps: A Step-by-Step Guide
Learn how to exceed the default limit of 2000 rows in PowerApps to optimize performance. Discover strategies for loading large datasets efficiently and handling specific use cases that require processing more than 2000 lines.
Install Tubelator On Chrome
Video Summary & Chapters
No chapters for this video generated yet.
Video Transcript
Hello everyone, today I will share with you
how to load more than 2000 lines in PowerApps
As we know, to improve the performance of PowerApps
Microsoft always sets a limit of 500 lines per download
and a maximum of 2000 lines
But in some specific cases, we will need to have more than 2,000 lines.
For example, in the case of the screen I shared,
normally in an organization, I have a customer care unit.
In customer care, at the end of the month, there will always be a monthly summary.
In a hospital, the number of patients is from 200 to 400 per day.
I will calculate a bit. For example, if I set the maximum to 400, for example, I multiply by the month,
I will calculate that a month is 30 days. The number will be about 12,000. This is the maximum I am calculating.
So, of course, if the report summary is fully accurate, I will have to go over that 2,000 number.
Here I will share a beautiful example of drawing
Now I will summarize the report
For example, I take the number of the closest to 1
from February 1st to February 29th.
Then I continued to scroll through the data.
In this process, I will leave it in the form of a time to follow
so that you can know how much time it takes to download this data.
it takes about how much
because the process of
we load data over 2000 data
it takes a lot of time
Similarly
for example, 4,000, 5,000, 6,000
the time continues to increase
I will take a watch to measure
I will take a watch to measure
I will have a time button
I will continue
I will continue
then I will press start
to let you know how much time it takes to load a large amount of data
and see if this method is really necessary and in what cases
I will continue, then I will press start
The time it takes is not worth much
I will set real time, that is, I will not tour my video
so that you can see the length of the process of data generation
We can see the number of 1047 is increasing
It is increasing from 200 to more than 200
Normally, I have created a loop
and each time I loop, I will get data of more than 200
I will share with you how to loop
We can see that the number is more than 2000
The method I'm going to share will help us to download all the data
and we won't worry about the wrong report
But this problem is limited and we usually have to find other solutions
I will try another way
During the process of disassembly, I see that my machine is very noisy
Video Summary & Chapters
No chapters for this video generated yet.
Video Transcript
Hello everyone, today I will share with you
how to load more than 2000 lines in PowerApps
As we know, to improve the performance of PowerApps
Microsoft always sets a limit of 500 lines per download
and a maximum of 2000 lines
But in some specific cases, we will need to load more than 2000 lines.
For example, in the case of the screen I shared,
normally in an organization, I have a customer care unit.
In customer care, at the end of the month, there will always be a monthly summary.
In a hospital, the number of patients is from 200 to 400 per day.
I will calculate a bit. For example, if I set the maximum to 400, for example, I multiply by the month,
I will calculate that a month is 30 days. The number will be about 12,000. This is the maximum I am calculating.
So, of course, if the report summary is fully accurate, I will have to go over that 2,000 number.
Here I will share an example of my drawing.
Now I will summarize the report.
For example, I took the date of February 1st, February 1st to the last day of February, February 29th.
Then I continued to start.
I will leave it in the form of time for you to know how much time it takes to download this data.
Because the process of downloading data over 2000 data takes a lot of time.
Similarly, for example, if you load 4000, 5000, 6000, the time will continue to increase.
Here I will take a watch to measure.
Here I will have a time button.
Now I will continue.
Continue and then I will press start to let you know how much time it will take to load a large amount of data.
And see if this method is really necessary and in what cases.
The time it takes to upload is not much
I will set real time, that is, I will not tour my video
so that you can see the length of the process of uploading data
We notice at this angle
The number is increasing gradually from 1047
Every time it goes up to about 200, a little more than 200
Normally, I have created a loop
and each time it is read, it can read about 200 data
And how to read it?
I will share with you the way
We can see it is over 2000
The way I will share will help us
to download all our data
and we will not worry that we will have a wrong report
But this problem is limited
and we often have to find other solutions
During the process of disassembly, I see that my machine is
very much increasing
It is possible due to the processing process
We are starting to assemble
After that, I will press the stop button
Here we will stop
Here we see that we have downloaded a data amount of 5000 lines
And the number of minutes we download is about 2 minutes 22 seconds
If this number goes up again, for example
