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
thirdimage

Power Automate 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

fifthimage

Microsoft Learn

Learn how to build the business apps that you need.

Top Kudoed Authors
Users Online
Currently online: 387 members 6,116 guests
Please welcome our newest community members: