fbpx
  1. Tubelator AI
  2. >
  3. Videos
  4. >
  5. Science & Technology
  6. >
  7. 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

Available In Following Subtitles
English
Variant 1 Variant 2
Posted on:
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.
tubelator logo

Instantly generate YouTube summary, transcript and subtitles!

chrome-icon Install Tubelator On Chrome

Video Summary & Chapters

No chapters for this video generated yet.

Video Transcript

0:01
Hello everyone, today I will share with you
0:05
how to load more than 2000 lines in PowerApps
0:11
As we know, to improve the performance of PowerApps
0:19
Microsoft always sets a limit of 500 lines per download
0:25
and a maximum of 2000 lines
0:27
But in some specific cases, we will need to have more than 2,000 lines.
0:35
For example, in the case of the screen I shared,
0:40
normally in an organization, I have a customer care unit.
0:46
In customer care, at the end of the month, there will always be a monthly summary.
0:51
In a hospital, the number of patients is from 200 to 400 per day.
1:01
I will calculate a bit. For example, if I set the maximum to 400, for example, I multiply by the month,
1:12
I will calculate that a month is 30 days. The number will be about 12,000. This is the maximum I am calculating.
1:22
So, of course, if the report summary is fully accurate, I will have to go over that 2,000 number.
1:28
Here I will share a beautiful example of drawing
1:32
Now I will summarize the report
1:34
For example, I take the number of the closest to 1
1:38
from February 1st to February 29th.
1:44
Then I continued to scroll through the data.
1:51
In this process, I will leave it in the form of a time to follow
2:00
so that you can know how much time it takes to download this data.
2:04
it takes about how much
2:06
because the process of
2:09
we load data over 2000 data
2:11
it takes a lot of time
2:13
Similarly
2:14
for example, 4,000, 5,000, 6,000
2:18
the time continues to increase
2:20
I will take a watch to measure
2:28
I will take a watch to measure
2:29
I will have a time button
2:30
I will continue
2:32
I will continue
2:33
then I will press start
2:35
to let you know how much time it takes to load a large amount of data
2:41
and see if this method is really necessary and in what cases
2:46
I will continue, then I will press start
2:51
The time it takes is not worth much
2:56
I will set real time, that is, I will not tour my video
3:01
so that you can see the length of the process of data generation
3:19
We can see the number of 1047 is increasing
3:24
It is increasing from 200 to more than 200
3:31
Normally, I have created a loop
3:34
and each time I loop, I will get data of more than 200
3:42
I will share with you how to loop
3:46
We can see that the number is more than 2000
3:55
The method I'm going to share will help us to download all the data
4:03
and we won't worry about the wrong report
4:07
But this problem is limited and we usually have to find other solutions
4:30
I will try another way
4:37
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

0:01
Hello everyone, today I will share with you
0:05
how to load more than 2000 lines in PowerApps
0:11
As we know, to improve the performance of PowerApps
0:19
Microsoft always sets a limit of 500 lines per download
0:25
and a maximum of 2000 lines
0:27
But in some specific cases, we will need to load more than 2000 lines.
0:35
For example, in the case of the screen I shared,
0:40
normally in an organization, I have a customer care unit.
0:46
In customer care, at the end of the month, there will always be a monthly summary.
0:51
In a hospital, the number of patients is from 200 to 400 per day.
1:01
I will calculate a bit. For example, if I set the maximum to 400, for example, I multiply by the month,
1:12
I will calculate that a month is 30 days. The number will be about 12,000. This is the maximum I am calculating.
1:22
So, of course, if the report summary is fully accurate, I will have to go over that 2,000 number.
1:28
Here I will share an example of my drawing.
1:32
Now I will summarize the report.
1:34
For example, I took the date of February 1st, February 1st to the last day of February, February 29th.
1:45
Then I continued to start.
1:47
I will leave it in the form of time for you to know how much time it takes to download this data.
2:07
Because the process of downloading data over 2000 data takes a lot of time.
2:13
Similarly, for example, if you load 4000, 5000, 6000, the time will continue to increase.
2:21
Here I will take a watch to measure.
2:28
Here I will have a time button.
2:30
Now I will continue.
2:33
Continue and then I will press start to let you know how much time it will take to load a large amount of data.
2:41
And see if this method is really necessary and in what cases.
2:52
The time it takes to upload is not much
2:54
I will set real time, that is, I will not tour my video
3:01
so that you can see the length of the process of uploading data
3:18
We notice at this angle
3:21
The number is increasing gradually from 1047
3:24
Every time it goes up to about 200, a little more than 200
3:31
Normally, I have created a loop
3:34
and each time it is read, it can read about 200 data
3:41
And how to read it?
3:43
I will share with you the way
3:46
We can see it is over 2000
3:56
The way I will share will help us
4:01
to download all our data
4:03
and we will not worry that we will have a wrong report
4:07
But this problem is limited
4:10
and we often have to find other solutions
4:37
During the process of disassembly, I see that my machine is
4:40
very much increasing
4:42
It is possible due to the processing process
4:44
We are starting to assemble
4:46
After that, I will press the stop button
5:12
Here we will stop
5:13
Here we see that we have downloaded a data amount of 5000 lines
5:18
And the number of minutes we download is about 2 minutes 22 seconds
5:23
If this number goes up again, for example
shape-icon

Download extension to view full transcript.

chrome-icon Install Tubelator On Chrome

YouTube First AI Assistant

chrome-icon Install On Chrome

AI Art For This Video No image generated for this video yet but here is the example.

ai art
0:09
Prompt
spider man in aladdin style, bright colors, hyper quality, high detail, high resolution, --video --s 750 --v 6. 0 --ar 1:2
ai images

Explore more in Science & Technology