Showing results for 
Search instead for 
Did you mean: 
Level: Powered On

Data Loads Slowly

I have an app with 2 screens each has a gllaery nested inside another gallery. There are labels that do sum calculations. There is one data source that is located in Sharepoint so the Data is all contained within the cloud. I am having an issue getting the data to load quickly. Is this a limitation within Powerapps, or am I doing something wrong?

Community Support Team
Community Support Team

Re: Data Loads Slowly

Hi Hockeyman9474,


How many data are there in your SharePoint list?

Do you have any other complex codes within your app?

Do your other apps that based on SharePoint also load data slowly?

Are you using desktop studio or Web player?

How about the Networking on your side?


Best regards,
Mabel Mao


Community Support Team _ Mabel Mao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Level: Powered On

Re: Data Loads Slowly

Probably about 3,00 rows of Data

My app is made up of 2 screens each with 1 nested gallery

Each Gallery contains a bunch of labels that calculate sums i.e. the most complicated being::

     Sum(Filter(table,carline<>"0" && Dealer = ThisItem.result),DailySales)

Data loads fine ni Sharepoint no other apps using this data

This Data is loading slow on my mobile app as well as browser from anywhere

Level: Powered On

Re: Data Loads Slowly

One thoughtI had was with my filtering. Each row has a carline, a district, a dealer etc.. I mentioned that I have nested galleries.  So say there are 6 districts and I want my gallery to show each of them once. I would type distinct(filter(table,District<>"0"),District). There are no records with the district being 0, however Iam under the impression that to filter, there needs to be filter criteria such as <>"0". Can I filter simply by filtering for a District or Carline, or Dealer without having criteria such as = or <>?

Helpful resources

New Ranks and Rank Icons in April

'New Ranks and Rank Icons in April

Read the announcement for more information!

Better Together’ Contest Finalists Announced!

'Better Together’ Contest Finalists Announced!

Congrats to the finalists of our ‘Better Together’-themed T-shirt design contest! Click for the top entries.

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020


Community Summit North America

Innovate, Collaborate, Grow - The top training and networking event across the globe for Microsoft Business Applications

Top Solution Authors
Top Kudoed Authors
Users online (4,783)