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

Re: Data Table stuck on "Loading Data"

Same experience.

 

  1. I created a blank PowerApp
  2. Added three data tables
  3. Pointed the data tables all to the same data source in our SQL Database
    (different than what the other app uses)
  4. Scrolled each one until it stopped

They all stopped at the same point.

When I interacted with the first table (clicking on an item), it began loading results again.  I was then able to scroll further down, but it still stopped.

I then tried again, using SortByColumns to sort ascending on one of our integer columns so that I could easily identify how many had loaded.

I repeatedly scrolled on the first item until it hung, clicked on an item, and repeated.

  • Hung @100 items
  • Hung @200 items
  • Hung @400 items (pausing briefly somewhere between)
  • Hung @600 items (pausing briefly somewhere between)
  • It's not continuing from there.

I tried the same with the remaining two tables and found that they pause and hang in different spots.
It's looking like it will hang after either 100 or 200 items.  I've yet to see it scroll past 200 without me having to take some action to loosen it up.

Where I'm at now:
Table1 is stuck showing "Loading data" after 600 items have been loaded.

Table2 was stuck showing "Loading data" after 600 items.  After several failed attempts to loosen it up, it is now stuck at the 600 item mark and is no longer showing "Loading data"
Table3 is stuck showing "Loading data" after 700 items have been loaded.

 

pitr
Level: Powered On

Re: Data Table stuck on "Loading Data"

And update:
I triggered a refresh and it loaded the remaining items without issue.

Total item count: 947.

 

I also noticed that clicking refresh does eventually restore my scroll position in the data table, but that's after several seconds of everything jumping around.

Power Apps Staff Mr-Dang-MSFT
Power Apps Staff

Re: Data Table stuck on "Loading Data"

@pitr, it is by design that the data table only shows 100 at a time as you scroll to fetch more.

 

I have forwarded your session id to someone who can look at it, but if you know how to get a fiddler trace of the data tables as you scroll, and PM that to me, that will help.

pitr
Level: Powered On

Re: Data Table stuck on "Loading Data"

Thank you for forwarding that along.

In the meantime the users of the app have been instructed on the workaround.

 

I'll see if I can get a Fiddler trace for you, but it might be little bit before I can get it reinstalled.

ajyendra24
Level: Powered On

Re: Data Table stuck on "Loading Data"

@pitr ,

 

Did u find the exact solution for that. also get same issue the loading data stuck after some records. it would be great help for me if you provide solution. Thanks in advance.

 

Thanks

Ajyendra

Helpful resources

Announcements
thirdimage

Power Apps Super User Class of 2020

Check it out!

thirdimage

Power Apps Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

sixthImage

Power Platform World Tour

Find out where you can attend!

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

SecondImage

Difinity Conference

The largest Power BI, Power Platform, and Data conference in New Zealand

Top Solution Authors
Top Kudoed Authors (Last 30 Days)
Users online (2,944)