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?
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?
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
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 <>?
Check out new user group experience and if you are a leader please create your group
We are excited to announce that Demo Extravaganza for 2021 has started!
On-demand access to all the great content presented by the product teams and community members! #MSBizAppsSummit #CommunityRocks
Did you miss the call? Check out the recording here!