#PowerApps #PaginatedGallery
This video is a step-by-step tutorial on Power Apps Gallery Pagination. This technique for Pagination in Power Apps utilizes the LastN & FirstN functions along with supported delegation logic which allows the Gallery to work with large data sources in which Power Apps will automatically break down your data source query in an optimized and performant manner. We will also provide dynamic filters for paging Size and Gallery filtering. The gallery will load data in batches of 100 thereby optimizing query performance as the user paginates through the gallery pagination control.

Check out my blog post which contains all the formulas showcased in this video on Gallery Pagination : https://rezadorrani.com/?p=474

Video covers the following:
βœ… Pagination in Power Apps Galleries
βœ… Delegable queries for Paginating Gallery
βœ… Optimized load of data via Pagination in a Gallery
βœ… Dynamic page size and filters for Gallery

Delegation Playlist – https://www.youtube.com/playlist?list=PLTyFh-qDKAiE6ia-D94Qk5-AzpN4dqOmD

Table of Contents:
00:00 – Intro
00:43 – Gallery with Pagination Demo
02:57 – Optimized data loading in Power Apps Gallery control (Delegation)
05:50 – Delegation issue with FirstN and LastN functions
08:22 – Setting Gallery control for Pagination without a delegation warning
10:37 – Adding the Pagination controls
19:44 – Subscribe

28 Comments
  1. vinit chauhan 4 months ago

    Good explanation…had developed pagination earlier but got some best practice tips … thanks and keep it up

  2. Sundra Pillay 4 months ago

    Excellent video Reza! Thanks

  3. Naveen Kumar 4 months ago

    Awesome content.. Thanks Reza

  4. Ramesh Mukka 4 months ago

    Too much of intelligence applied. I got to watch another time :P. Honestly learned so many things here especially with the default property of the hidden gallery. Thanks Reza. Give a thought about sharing your students data πŸ˜€

  5. billakanti karthik 4 months ago

    Crystal clear explanation πŸ‘Œ. With all best practices. Learned a lot Reza.

  6. KK T 4 months ago

    WOW!!

  7. Fahad Imran 4 months ago

    Another fabulous topic.. Really helpful.. Thanks for sharing..

  8. Lex Uiterlinden 4 months ago

    Ji Reza, very clear explanation. I just became aware of the use of default function of a Gallery. Thanks. πŸ‘ Gr. Lex

  9. anjan chidige 4 months ago

    Simply stunning . Excellent explanation πŸ‘Œ

  10. Teresa Agustin 4 months ago

    Super clever solution Reza. Can’t wait to try it out. Thank you for all of your videos.

  11. Arijeet Chowdhury 4 months ago

    That was brilliant. Using the gallery's default property to trigger the next 100 record fetch was 100 IQ stuffπŸ”₯.

  12. Ger Fer 4 months ago

    Last year I was hunting for this- now saviour has come ( little bit late, but good for the next one)
    Very gooooooooodπŸ‘πŸ‘
    Best part is formula description is the cream of the πŸŽ‚

  13. Shriraj Gohil 4 months ago

    This was a very great video Reza! Got to know so many things..
    I was having one question, can we filter any people column in that hidden gallery?
    Thanks again for this video!

  14. Christer Russberg 4 months ago

    You live up to the idea of "sharing is caring". Thanks for a great video.

  15. PAS Foundation 4 months ago

    I appreciate your videos and explanations. I will make use of this technique right away. You are clearly knowledgeable and clever. Thank you. I wish I could help you as much as you have helped me–and others. One little thing, perhaps. (I know some may take exception to my mentioning this–not the correctness of what I say, but that I would dare offer a suggestion. So please, accept it, or not, as you wish. I will still learn from you.) The word "pagination" is pronounced like "PAJ INATION" rather than like "PAGE INATION". For what it's worth to you. Offered sincerely.

  16. Jagan V 4 months ago

    Hi Reza, very clear explanation. Keep it up, could you please start videos on SPFx, it will be very helpful us.

  17. Le Unknown 4 months ago

    The solution it self and the way you're explaining the logic is just awesome! Thank you, Reza!

  18. Emmanuel Maceda 4 months ago

    I feel like a kid again that was just handed a very beautiful gift by Santa after watching this. Thank you so much Reza and Happy New Year!

  19. Ryan Bond 4 months ago

    Hi Reza, you make something which is so complex seem so simple! From your use of referencing a hidden gallery, I see that it is a better option that utilising a collection, bec the collection is limited by the delegation limit, but the gallery is not. But it still acts as a 'middle man' so that you can use non-delegable formulas on large amounts of data. Have I got it right?

  20. Krutika Suchak 4 months ago

    Great solution and video! Thanks heaps.

  21. Christer Russberg 3 months ago

    Hi I have tried this with a SharePoint list with around 300 rows. But I get only 100 rows showing in my app. What can be wrong?

  22. Madiha Salman 3 months ago

    hi reza
    Last line in gallery item property . drpPaginationSize.Selected.Value . I have done same but getting error when in the last I added drpPaginationSize.Selected.Value. If I do like drpPaginationSize.Selected.Value * PageNumber then its fine. are we missing something here??

  23. Madiha Salman 3 months ago

    How to reset gallery ??

  24. justAcat meow 3 months ago

    thank you so much

  25. Soe Aung 3 months ago

    Sir, Can we use the PowerApps for offline?

  26. kiran katkar 3 months ago

    Totally Loved it❀️.
    I have gone through your blog and created similar but one issue is there, galHiddden gallery returns only 100 item's. I am not able to see/fetch other 400 items that I have in SharePoint list.

  27. Dan Maxwell 3 months ago

    So this is a paginated representation of delegated data. Got it

  28. N S 2 months ago

    I love all your video and blogs? Clear simple and understandable for everyone. Thanks Reza.

Leave a reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Β©2021 TDG - We Are Back Baby!

CONTACT US

We're not around right now. But you can send us an email and we'll get back to you, asap.

Sending
or

Log in with your credentials

or    

Forgot your details?

or

Create Account