cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Anonymous
Not applicable

Table Pagination in Canvas App vs infinite scroll

I have been designing a table in PowerApps with a Canvas app. The table is not responsive currently and only fits about 10 rows by default. 

 

The data in the table come from the DB. My engineers are suggesting to fetch list and have the user scroll through the 10 rows and have the BE fetch the next set of results. My UI design called for a pagination. They seem concerned about data retrieval that way and wanted to get people's opinion of this? 

 

The reason I am going for the pagination route is that currently the table is "not" responsive and so with large data sets of 100+ records, when you scroll inside the table it is very clunky currently in our dev environment as it takes awhile to get the records and then you see white space until the table loads the new data set. 

Annotation 2020-03-09 131801.png

1 ACCEPTED SOLUTION

Accepted Solutions
v-xida-msft
Community Support
Community Support

Hi @Anonymous ,

Do you want to display your table records using Pagination functionality?

 

Based on the needs that you mentioned, I think the Gallery could achieve your needs. The user @hpkeong has provided a detailed solution for this scenario, please check the solution within the following blog:

https://powerusers.microsoft.com/t5/News-Announcements/Pagination-Features-Esp-for-PC-or-Tablet-Mode/ba-p/24077

 

Please consider take a try with above solution, check if it could help in your scenario.

 

Best regards,

Community Support Team _ Kris Dai
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

4 REPLIES 4
PowerAddict
Super User
Super User

What exactly are you doing to implement pagination? I dont see any issue with this. Also, what are the concerns they have with this logic?

---
If you like this reply, please give kudos. And if this solves your problem, please accept this reply as the solution.

Thanks!
Hardit Bhatia
The Power Addict
https://thepoweraddict.com
BrettR
Advocate IV
Advocate IV

If performance when getting data from the DB is slow. If suggest getting your 100+ records onstart of the app and put it into a collection.

Then you could paginate data from the collection instead of calling the DB every 10 rows.

You could also speed up the responsiveness of the table/DB call by restricting the columns you are pulling back.

To improve performance of the table being displayed, Galleries are slow when you've got lots of labels and text boxes in each row and have hundreds of rows. So if you can reduce the amount of labels/boxes/buttons that will also speed it up.

Lastly, if performance is still a drag. You could use a Data Table instead of a Gallery. They are much more limited in terms of look/feel, but dang are they faster than Galleries.
paulbeck1
Advocate I
Advocate I

There are basically two approaches to paging: Pull large data sets and manage the paging with the locally cached data or use the query  to do the paging on each request.

 

As a general rule, option 1 is better.  The amount of data does not significantly cause performance issues, the heavy lift is generally the query not the amount of data over the wire.  Assuming your dataset isn't over 2000 thousands of rows, option 1 is the way to  go.  If it is taking a few seconds, look for a point to load the data perhaps on app initialization.

 

Option 2 works well for extremely large data that needs to be sliced and/or HTTP API's.  If you data is dynamic (i.e. could be anything from a big data set), you want to query specifically so the user doesn't need to page or scroll.  

 

Summary, it depends.  Basically map of the data-set and requirement and pick the best options.  For instance, on a data-set of 4 million rows, I don't allow paging, if the user can't narrow it down, I doubt they are going to page around to find the data.

v-xida-msft
Community Support
Community Support

Hi @Anonymous ,

Do you want to display your table records using Pagination functionality?

 

Based on the needs that you mentioned, I think the Gallery could achieve your needs. The user @hpkeong has provided a detailed solution for this scenario, please check the solution within the following blog:

https://powerusers.microsoft.com/t5/News-Announcements/Pagination-Features-Esp-for-PC-or-Tablet-Mode/ba-p/24077

 

Please consider take a try with above solution, check if it could help in your scenario.

 

Best regards,

Community Support Team _ Kris Dai
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

Announcements
Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

May UG Leader Call Carousel 768x460.png

June User Group Leader Call

Join us on June 28 for our monthly User Group leader call!

PA Virtual Workshop Carousel 768x460.png

Register for a Free Workshop

This training provides practical hands-on experience in creating Power Apps solutions in a full-day of instructor-led App creation workshop.

PA.JPG

New Release Planning Portal (Preview)

Check out our new release planning portal, an interactive way to plan and prepare for upcoming features in Power Platform.

Top Solution Authors
Users online (1,528)