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

Power Apps connected to large data - Issues while viewing content

We have created an app which is connected to On-Premise SQL Table having approx. 600000 records. 

I have used Vertical Gallery Control to display and scroll through the records.

 

Issue : 

If you continue to scroll through the records after some time, the browser page is refreshed automatically and the app gets closed.

This issue happens after i scroll down to 1000 to 1500 records.

I have tried this on both Internet Explorer and Google Chrome.

In Internet Explorer : Page gets refreshed automatically.

In Google Chrome : It says Browser is out of memory.

NOTE:  I have not used collections for data. All the data is coming from server at run time.

Below is the screen shot of the issue.

PowerApps Loading issue.png

 

 

 

 

 Anyone faced similar issue ? Or any suggestions for this issue ?

Thanks

 

 

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
PowerApps Staff EvanChakiMSFT
PowerApps Staff

Re: Power Apps connected to large data - Issues while viewing content

I would recommend against trying to page through 600k records in your app.  Maybe add a search box and filter the gallery based on that search information entered.  

View solution in original post

2 REPLIES 2
Administrator
Administrator

Re: Power Apps connected to large data - Issues while viewing content

adding in @EvanChakiMSFT to review this SQL question

 

@TopShelf-MSFT

Highlighted
PowerApps Staff EvanChakiMSFT
PowerApps Staff

Re: Power Apps connected to large data - Issues while viewing content

I would recommend against trying to page through 600k records in your app.  Maybe add a search box and filter the gallery based on that search information entered.  

View solution in original post

Helpful resources

Announcements
firstImage

Microsoft Business Applications Virtual Launch Event

Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

firstImage

Watch Sessions On Demand!

Continue your learning in our online communities.

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

FirstImage

Power Platform World Tour

Coming to a city near you

thirdimage

PowerApps Community User Group Member Badge

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

FourthImage

Join PowerApps User Group!!

Connect, share, and learn with your peers year-round

Top Kudoed Authors
Users Online
Currently online: 389 members 4,516 guests
Please welcome our newest community members: