Pagination in Gallery

[Sharuk]

Hi

I'm trying to achieve pagination inside gallery. and I'm following this video https://www.youtube.com/watch?v=aKsNOsGj72A by @RezaDorrani.

I'm having a data source with 2000 records. and when I tried to run, the countrows(gal_hidden) is showing 100 records only but I'm not able to navigate to next page as shown below

and then I've opened the hidden gallery and scrolled down till 400 items then I tried running it again then now I'm able to see upto 400 records and again I'm not able to click on next

do we need to scroll down the hidden gallery till end to load all the items like this ? @RezaDorrani  can you please help me out here!

[Pstork1]

Review the last 2 minutes of the video.  That is where @RezaDorrani covers how to scroll the hidden gallery to get the next 100 records by selecting the last record in the hidden gallery.  The formula is at 18:56 in the video.

[Sharuk]

Thanks @Pstork1 , I missed it. but after applying that formula, I've observed strange behavior as it is showing 100 series after 500 series as shown below. I think it shouldn't be the behavior. Am I doing anything wrong here ?

[Pstork1]

That all depends on how the data source you are loading into the gallery is sorted.  If its not sorted by the series number then seeing them out of order is perfectly normal.

[Sharuk]

Hi @Pstork1 , But I'm able to see the same records in 11th page as well. is there a chance which we get the records again in another chance ? and I'm not using any sort

]

[Pstork1]

Even if you aren't using a sort in Power Apps, there is some kind of a default sort.  But if you are seeing the same records again then something about your paging isn't setup correctly.  Make sure you look at the way the last set of records when paging are accessed.  That may be where the duplicates are coming from.