HI,
I have a program I just did to track all the airports of the world. there are over 75,000 Airports and the most is over 3,500 airports in Dallas. now I set the data row limit to 2,000 in Powerapps. in the case of Dallas this is still going to miss 1,500 records. so, I do clear collects on all the regions to pull and filter. on the type of airport which is less then 2,000 of each time. I create the different lists and add them all together to get the result I want.
The process runs in less than 3 seconds from start to finish and display.
The first section clears the variable, the second section loops through the main dataset to filter out all the airports in the region and the specified type., then I add all the variables together to make the final dataset that is used in the Gallery display. Please note there is a concurrent statement this allows the different loops to run at the same time. but the final step is outside this statement to make sure all the datasets are pulled.
Here is the code I use:
Clear(APt);
Concurrent(
ClearCollect(
SA1,
(Filter(
Airport1_1,
iso_region = DataCardValue27.Text && Type1 = "Small_airport"
))
),
ClearCollect(
cl1,
(Filter(
Airport1_1,
iso_region = DataCardValue27.Text && Type1 = "closed"
))
),
ClearCollect(
he1,
(Filter(
Airport1_1,
iso_region = DataCardValue27.Text && Type1 = "heliport"
))
),
ClearCollect(
ma1,
(Filter(
Airport1_1,
iso_region = DataCardValue27.Text && Type1 = "medium_airport"
))
),
ClearCollect(
la1,
(Filter(
Airport1_1,
iso_region = DataCardValue27.Text && Type1 = "large_airport"
))
),
ClearCollect(
sb1,
(Filter(
Airport1_1,
iso_region = DataCardValue27.Text && Type1 = "seaplane_base"
))
),
ClearCollect(
ba1,
(Filter(
Airport1_1,
iso_region = DataCardValue27.Text && Type1 = "Balloonport"
))
)
);
ClearCollect(
APt,
SA1,
cl1,
he1,
ma1,
la1,
sb1,
ba1
)
