Power Apps Gallery Pagination

[@billakantikarthik]

Crystal clear explanation 👌. With all best practices. Learned a lot Reza.

[@RezaDorrani]

Thank you

[@livdawg17]

Your videos have been lifesavers. I was tasked with creating an app at work and I previously had ZERO Power Apps experience. With the help of your videos, I have a working app!

[@RezaDorrani]

So happy to hear that! Thank You for watching & learning from the videos.

[@Magayshibeo]

Reza! You just solved the delegation problem with a simplest way ever!!!!!! I couldn’t believe that I can find the solution for delegation issue in a video without even mentioning about this. You save my life!!!!

[@RezaDorrani]

Glad to know the video is helpful. Thank you for watching.

[@Magayshibeo]

@@RezaDorrani Just realize that the second gallery only can filter the first 100 items of the hidden gallery :(

[@RezaDorrani]

@@Magayshibeo That should not be the case. The hidden gallery will load data in batches of 100. If you need to apply queries then you should add it to the hidden gallery. The main gallery only references the hidden gallery.

[@justcoc1798]

Broooo You are such a saviour !!! I had no knowledge of powerapps and by this video I was able to implement pagination with ease . Thanks

[@RezaDorrani]

Glad it helped!

[@christerrussberg3059]

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

[@RezaDorrani]

Thank you for your kind words

[@battle_born]

Then again, Reza saves the day! You are awesome! Thanks for the great work and education!

[@RezaDorrani]

My pleasure!

[@TheMastermindgautam]

Hi Reza.. I was struggling to achieve pagination in my powerapps gallery for a week now & this video of yours helped me achieve the same in few mins.. you've saved me a lot of work & i learnt a lot from this video.. Thanks a lot. God bless you 🙌🏻

[@RezaDorrani]

You are most welcome and thanks so much for watching

[@nihar4713]

brilliant video, was confused initially but went through it again after going through all the gallery playlist of yours and it made it crystal clear

[@RezaDorrani]

Great to hear!

[@emmanuelmaceda2475]

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!

[@RezaDorrani]

Thank you 😊 Happy New Year to you as well

[@necdetsaritas8722]

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

[@RezaDorrani]

My pleasure!

[@silvandessouzacedrojunior9888]

Amazing Reza. you are the best ever. You save my life every single day. Thank you a lot

[@RezaDorrani]

wow! thanks

[@ShoaibHaseebNUST]

Shared the pagination in a simplest and yet effective manner.Kudos keep up the good work.😊

[@RezaDorrani]

Thank You!

[@olafoy]

Thank you Reza. Your videos are super! And your blog post is super also. Thank you!

[@RezaDorrani]

Glad you like them!

[@teresaagustin5191]

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

[@RezaDorrani]

Thank you Teresa. Let me know how it goes when you try it out.

[@PixelPerfectPowerApps]

That was brilliant. Using the gallery's default property to trigger the next 100 record fetch was 100 IQ stuff🔥.

[@RezaDorrani]

Thank you

[@shalom9234]

@@RezaDorrani What code did you use in the default property to trigger the next 100 record fetch. Please help

[@RezaDorrani]

@@shalom9234 Please check video again. I select last item of hidden gallery. Its shown in video.

[@gerfer6261]

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 🎂

[@RezaDorrani]

Thank you and glad to know the video is useful

[@patelbhargav]

This is exactly the solution I was looking for my use case. Thank you very much Reza for taking time to explain this 🙌🏼

[@RezaDorrani]

Glad it was helpful!

[@Botataung5]

Thanks!

[@RezaDorrani]

Thank You!

[@uiterlex]

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

[@RezaDorrani]

Thank you Sir

[@Abrekme]

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

[@RezaDorrani]

Thank you for your kind words

[@chikugerson5291]

​@@RezaDorrani Hi I am getting division by zero error on "Page " & varPageNumber & " of " & If( Mod( CountRows(galHidden.AllItems), 100 ) = 0, RoundUp( CountRows(galHidden.AllItems) / drpPaginationSize.SelectedText.Value ,0) & "+ pages", RoundUp( CountRows(galHidden.AllItems) / drpPaginationSize.SelectedText.Value,0) & " page(s)" )

[@RezaDorrani]

@@chikugerson5291 I have not experienced the mentioned issue and hence not sure what the cause for it could be. I will recommend posting your issue on forums in case someone has experienced something similar powerusers.microsoft.com

[@chikugerson5291]

@@RezaDorrani I figured it out turns out the gallHidden was giving 0 due to my filtering which was incorrect but I fixed it. Now I'm thinking what happens if the gallery indeed has no items from the data source

[@RezaDorrani]

@@chikugerson5291 if hidden gallery has no items, then main gallery also wont show any

[@danishislam692]

superb explaination. now I understood how pagination works. Thanks for sharing.

[@RezaDorrani]

Glad it was helpful.

[@truptinalnikar]

I am currently working on such business problem and this video was so helpful ! Thanks Reza! Very well explained and demonstrated ! :)

[@RezaDorrani]

Great to hear!

[@simplevikram1]

Thankyou Reza for excellent article and video on pagination. You are a life saver. Best part which I love is you have clear cut explanation of code and also provide readymade app to use it. My best wishes to you. 🙏

[@RezaDorrani]

You're most welcome and thank you for the feedback.

[@krishnachaluvadi3268]

Awsome solution Reza, great explanation.

[@RezaDorrani]

Thank you! Cheers!

[@fahadimran4865]

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

[@RezaDorrani]

You are so welcome!

[@anjanchidige]

Simply stunning . Excellent explanation 👌

[@RezaDorrani]

Thank you so much

[@viswadevannair1260]

Nice video Reza. Just to check where are you implementing your varReset which in the galhidden?

[@RezaDorrani]

Oh its been a while and don’t remember much. Video description has link to formulas. Also I did another video whose description has link to download sample app. Check kzbin.info/www/bejne/mJ-maahpnMmKqdU

[@viswadevannair1260]

@@RezaDorrani thanks.

[@pasfoundation4927]

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.

[@RezaDorrani]

Thank you for your kind words. I welcome feedback of any kind. Thank you for pointing that out. I will make sure I pronounce it right the next time.

[@pasfoundation4927]

@@RezaDorrani You are a humble man. Not just smart. An excellent combination in any man but not a common combination, sadly. Seriously, I cannot tell you how much I've learned from you. Ciao!

[@RezaDorrani]

@@pasfoundation4927 Thank you and appreciate all your kind words.

[@vennaarjunprabhakar5834]

Thank You Reza sir, Very well explained!

[@RezaDorrani]

Thanks for watching

[@HareKrsn213]

Till now I found the best channel on KZbin for Power Platform...Thank you Reza!

[@RezaDorrani]

Wow, thanks!

[@sundrapillay6668]

Excellent video Reza! Thanks

[@RezaDorrani]

Glad you enjoyed it

[@vinitchauhan6265]

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

[@RezaDorrani]

Glad to hear that

[@vaishnav7679]

9:05 hello reza can you explain from where you have taken the variable varReset in the hidden gallery

[@RezaDorrani]

I did this video years ago and do not remember where and when in video I showed it. Please check the entire video.

[@vaishnav7679]

@@RezaDorrani you havent shown the varReset in the video,else everything you shared in the video completely

[@RezaDorrani]

@@vaishnav7679 Probably on click of reset button I had set that variable to false and then true. Simply Toggled state of variable.

[@vaishnav7679]

@@RezaDorrani thank you for your help,your videos are really great..!!

[@julijazas]

Really nice i just implemented it. Just a quick question i have an editable gallery so this means i need to save any changes made to records before i navigate to next gallery page. If i want to make changes after i made corrections to any of gallery pages i need to add the changes to collection and then push the collection to datasource?

[@RezaDorrani]

I would guess YES. I would have to try it out with editable gallery scenario to know more.

[@bsmlivingwater]

Thank for this video n lessons, you r great teacher.

[@RezaDorrani]

You are very welcome

[@prajwalkbhandary4995]

Great!!.. Works like a charm. Thanks a lot

[@RezaDorrani]

Great to hear!

[@prajwalkbhandary4995]

But found that we cannot apply sorting to that hidden gallery with a sorting column as a parameter. It shows delegation warning

[@RezaDorrani]

@@prajwalkbhandary4995 There are ways to make sort columns delegable. Check kzbin.info/www/bejne/bHzPemSfj8R-epI

[@prajwalkbhandary4995]

Yeah. Understood. It's a long way actually. Anyway Thanks again.

[@HareKrsn213]

Thank you Reza for always creating videos which encounter the challenges in Power Apps. Just a quick question - do you have any video for the data table shown in this video?

[@RezaDorrani]

Thanks so much. I do have a video on gallery designs in which I shared the App which has that table like experience.

[@ryanbond7144]

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?

[@RezaDorrani]

You are spot on Ryan! I wish I had used this as my video description :)

[@moyura2]

@18:18 When I used the default property and updated a record in the gallery, it triggered data to reload. I was wondering is there other way to load the next 100 rows in a gallery without using the default property and manually scroll to the bottom?

[@RezaDorrani]

There is no way to load the next 100 rows inside a gallery (delegable) without manually scrolling to bottom or setting default.

[@dheerajtiwari8012]

Beautifully explained

[@RezaDorrani]

Thank You!

[@ResponsibleXI]

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 :D

[@RezaDorrani]

Thanks for the amazing feedback Ramesh.

[@wkrubon]

Hi Reza. Thank You so much for this video. I have a small query and was hoping if you could help. Let's say I'm on page 5 of the results and i search for an item. The search will return a single record and note that i did not press on Return. How do I intelligently navigate the user to page 1 so that he can view that single search result. Any help would be helpful!

[@RezaDorrani]

When user presses on button to search or filter on, you can always set the pagination index to 1.

[@krutikasuchak4302]

Great solution and video! Thanks heaps.

[@RezaDorrani]

Most welcome Krutika

[@89541315]

That is really an excellent video!! A question, is there any way to show loading spinner while filtering data? i am using variable to control the visible of loading image

[@RezaDorrani]

Check powerusers.microsoft.com/t5/Building-Power-Apps/Loading-Spinner-while-gallery-data-items-are-retrieved/td-p/683536

[@marlonjhonmonsanto5554]

As always, awesome video Reza! :-) How did you do the varReset?

[@RezaDorrani]

Its been a while since I did this video :) On click of reset button, I set resetvar to true which triggers the reset of all the filter controls and reloads the hidden gallery.

[@marlonjhonmonsanto5554]

@@RezaDorrani Thank you! Seems working fine now. Just to confirm if I got it correctly, I set Reset of dropdown as varReset, then OnSelect of Reset Button is Set(varReset, true). Is that correct?

[@RezaDorrani]

@@marlonjhonmonsanto5554 Form what I remember, Yes.

[@marlonjhonmonsanto5554]

@@RezaDorrani Thank you!

[@talsdaddy]

Great Video. Thanks Reza

[@RezaDorrani]

You are most welcome

[@VikasShankarMishra]

Hi Reza , thnx for wonderful explanation...my datasource is dataverse n I need to genrate serial no in gallery ...how can we do? I hv used sequence fun but for it we need to give it on gallery item property but my gallery is already connected with dataverse table . thnx

[@RezaDorrani]

In this video, I have showcased using 2 galleries. 1st gallery which is the main gallery that is connected to data source & 2nd is the gallery that is displayed to the user. You would need to use the sequence function and generate the sequence. Check out this post. May be it helps - powerusers.microsoft.com/t5/Building-Power-Apps/Add-Row-Number-to-Gallery-in-PowerApps/td-p/430856

[@stephaniacastillo4487]

Hi Reza, thank you very much for this video! I just want a basic question related to the Reset button, how did you set it up? and I watched you use the varReset, it was not clear to me how you set up this one...

[@RezaDorrani]

I simply change the variable value which in turn resets the gallery as gallery filter condition has that variable as a condition

[@stephaniacastillo4487]

ok great, which specific value do you change in the variable?@@RezaDorrani

[@RezaDorrani]

@@stephaniacastillo4487 I simply set that boolean variable to false and then true

[@gserrano1088]

Hi there! Thank you so much for this video. I am using an Oracle database and am not aware of how many records are currently available (I’ve been scrolling down and have gotten to 15k but it still doesn’t stop there) Is there any way I can actually display or show the total amount of records?

[@RezaDorrani]

I have not done any work with Oracle DB and hence not sure what the steps would be. I recommend checking on the forums at powerusers.microsoft.com/ in case someone has done something similar.

[@yipngasze2053]

Hi, Reza. Your video is amazing! Just want to ask how can the user back to a specific record which not on page 1 of the gallery after they edit it. Thank you!

[@RezaDorrani]

May be when user navigates to different screen, we store the page number in variable so when user comes back, we can use that variable to default to that specific page.

[@kishorjabegu4668]

Hi Reza, the tutorial was so helpful. I am new to powerapps and I have this doub is there any way we configure the initial load of items into gallery as currently we can only load and paginate 100 items right. I wanted to have at least load 500 items and paginate through those 500?

[@RezaDorrani]

You should ideally not load more than 100. 100 is optimized loading. I don't seen many users scrolling through 500 records and then paginating.

[@jhonatanorabadillo]

Hello, Reza! Thanks for share this tutorial. Please, Can you help me with the following question. Do you think there are problems if we use a Sharepoint list with around 25000 records? Thanks a lot!

[@RezaDorrani]

As long as delegation is handled, then answer is Yes.

[@jhonatanorabadillo]

@@RezaDorrani Thanks for your answer 😀

[@azimyasin9008]

Nice video. Thanks Reza

[@RezaDorrani]

Your most welcome

[@JosuLekaroz]

Hi Reza, thanks for such great content! You are the top man for PowerAPPs. Would it be possible in your system to trigger the next page action automatically when the user scrolls down to the end of the current page?

[@RezaDorrani]

Thanks for your kind words. I dont think there is any action that can capture scrolling down to last item. Not aware of anything for it.

[@wen-chichang7399]

Great explanation. I learned a lot from this video thank you. I want to know how to ensure that all data sources are updated successfully when updating multiple data sources at the same time, and cancel as long as any one of them fails.

[@RezaDorrani]

When you Patch data, you can get a response from the Patch function. Example: Set(result, Patch(...)) result will give you the details. Success or failure.

[@wen-chichang7399]

@@RezaDorrani Thanks for your reply

[@shilpasprasanna3709]

Thanks for the video, It helped me a lot.. I am getting runtime error saying number divided by zero and I would like to know how are you resetting all the filters.

[@RezaDorrani]

I have not come across this issue and hence not sure what is the cause for your issue. I recommend posting your issue/query with screenshots on the forums at powerusers.microsoft.com

[@glennbullion9069]

@@RezaDorrani I am getting the same error. Still trying to dig. Everything works otherwise. From running a monitor, it looks to do with the formula behind the "Page # of X Pages" code.

[@glennbullion9069]

Okay, figured out my issue with "Divide by zero". Not sure if this is the same for the OP, but for me, I was using a modern dropdown control for pagination. If I hardcoded a pagination count, the error went away. So, figured it was something to do with the control. I replaced the modern dropdown with a classic (styled to "look" modern), and the error went away. Brilliant video.

[@paumason]

Hi Reza, thank you so much for this video, amazing!! I've a problem, my hidden gallery only show me the first 100 records, how can I collect all records in memory

[@RezaDorrani]

The idea of the video is that the hidden gallery will show 100 records (delegation) and as the move navigates through the set of records in the main gallery, the hidden gallery keeps loading data in batches of 100. Check the whole video in action.

[@NaveenKumar-lm7qj]

Awesome content.. Thanks Reza

[@RezaDorrani]

Glad you enjoyed it

[@pranavlakshmikanth8638]

Hello Reza, very good explanation Would you help us to create a daily audit checklist app in power apps? The audit checklist has 30 different check points

[@RezaDorrani]

If you need help with issues then post your query at powerusers.microsoft.com/ Looks like you need consulting help.

[@shrirajgohil5987]

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!

[@RezaDorrani]

The hidden gallery is just like a regular gallery. You can add any filters of your choice. I did a video long back on filtering on people column - kzbin.info/www/bejne/qoHbdpJjeciKock

[@UlisesFerrero-x8r]

Thank you so much, Reza, for another amazing tutorial! I have a quick question: I'm working with two sets of data that need to be displayed in two galleries, where one is embedded within the other. Specifically, I want to filter the second dataset based on a specific field from the first dataset. For each record in gallery 1 (which has 700 records), I have approximately 30 records in the embedded gallery 2, a lot. Do you think this approach is achievable using a hidden collection?

[@RezaDorrani]

I have no clue about this. I do not have a video reference on this scenario and would have to try it out to provide guidance. I recommend checking on the forums at powerusers.microsoft.com/ in case someone has done something similar.

[@tejaswadkar4651]

Hello @Reza, We followed same steps for our gallery, which list item count is more than 28000, so for that how we can achieve this pagination functionality? It will work only upto 100 records with search.

[@RezaDorrani]

It should work with any list size. I dont see any user paginating through 28000 items though.

[@gserrano1088]

If for example, I have a gallery with employee records and it contains employee division, as well as other fields like systems, roles, etc…and every division has unique roles (so there will be duplicates since there are many different roles for each division) is there anyway I can get rid of the duplicates and like group them so that my gallery only shows the divisions (so that someone can choose it in the first screen) and then another screen will appear will all the info of the division chosen?

[@RezaDorrani]

I do not have a video reference on this scenario and would have to try it out to provide guidance. I recommend checking on the forums at powerusers.microsoft.com/ in case someone has done something similar.

[@brianlabarre1]

If I am using two lists do you think I could bring in two invisible galleries and combine them in my gallery for the user?

[@RezaDorrani]

I’m not sure as that is not a scenario I have tried

[@brianlabarre1]

@@RezaDorrani this is a game changer either way!

[@darasat]

Hi Reza this is great tutorial, congratulions! I have one question how we can export in an excel all the elements inside on a paged gallery, with a flow even if they are in different pages? thank you very much.

[@RezaDorrani]

Since delegation would be a challenge, not all data would be loaded in memory. I would recommend to export data to excel by calling flow and let flow do the query. Check kzbin.info/www/bejne/qoKmc4qDh5yHbJY

[@lanuevacafro]

HELLO, I have written you, by all the comunication neting

[@akshay._.solanki]

Hi reza when I am patching any item from the paginated gallery, it goes back to the first selected item in gallery by default since we have If(drpPaginationSize.Selected.Value * varPageNumber >= CountRows(Self.AllItems),Last(Self.AllItems)) for the default for hidden gallery How can I make sure that the gallery default selection remains the same item after patching/editing a particular item from the gallery? I was thinking to store the ID value in a variable and checking if the variable is empty then go to first item from that page as your code does for the default but when it the variable is not empty it should select the id from the variable but its not working do you have any other suggestions?

[@RezaDorrani]

Im not sure of how to do that. Something I would have to revisit and try.

[@iansanders1075]

Hi Reza, thanks for providing these fantastic videos. I was wondering if you have ever had a case of combining GroupBy / Nested Galleries with pagination to create printable reports?

[@RezaDorrani]

I have not come across this scenario. I just did a video on nested galleries though - kzbin.info/www/bejne/aGbCk5ebrcqpfc0

[@iansanders1075]

@@RezaDorrani thanks Reza, I looked through that and found it very useful for some other parts of various apps I've created. The reason behind the pagination request was because I've got a Time Attendance app that integrates with a lot of other things, and thought it would be nice to have a nested report (Staff Name and various calculations in the 'top' gallery, then all the individual entries for that user as a sub gallery - which I can do, but I can't get it to paginate dynamically - as I have done with single galleries (after viewing your other videos!). Not too important, but I'm sure it would be useful for others too - if I find a way of doing it, I'll drop you a message.

[@RezaDorrani]

@@iansanders1075 Give a try. Let me know if you are able to achieve it.

[@hitakshigupta7193]

Hi Reza, what an amazing content! I’m also working on the pagination but in case I want to view the last 5 previous page records what will be the change I’ll have to introduce any suggestions?

[@RezaDorrani]

Not sure why you would not want user to paginate to those records instead of updating logic to show 5 previous page records. This is not something I have tried and would need to try it out to know the steps. I recommend posting your query on forums in case someone has done something similar powerusers.microsoft.com

[@bat_mobile7545]

Thank you for your tutorial of PA pagination, but i have a question? is it possible to create page pagination with filter embeded to the gallery instead of create seperate input box for filter.

[@RezaDorrani]

I did not understand the question about filter embedded to gallery.

[@bat_mobile7545]

@@RezaDorrani Thank you for your reply and sorry for my misused sentences The issue i'm facing is i'm trying to show my filtered sharepoint list by table value _on start_ with this formula " Filter(, Title in )" However it returns 0 matching records because of delegation due to my SP list contains over 7000 records . even though there is matching value on DB table and i'm trying to reuse this formula on different SP list with record below 100 it shows matching value on PowerApps. so it is possible to use pagination to minimalize filtered records on start? if not is there any possible solution to filter SPlist on start? Thank you.

[@RezaDorrani]

@@bat_mobile7545 I am not so sure about that. Something that I would have to try. I will recommend to post your query with screenshots on the forums at powerusers.microsoft.com

[@chinnu525]

Thanks for the vedio Reza.I tried implementing the same,but my gallery is showing only 100 items though i have 8000 plus records in my DB.Can you please help on this.

[@RezaDorrani]

Gallery loads data in batches of 100 (delegable gallery - as shown in video). To load more data, key is to use concept of hidden gallery and setting its default value. Shown at 18:00 in video.

[@chinnu525]

i have implemented the same way in the hidden gallery and filter queries are working fine , when the page navigation reaches to 10th page it is getting disabled and not loadind next set of records

[@RezaDorrani]

@@chinnu525 10 page meaning you have loaded 1000 records. Make sure your hidden gallery is not running into delegation issues. You filter query has to be delegable. If it is delegable and still not loading then it means your default formula set for hidden gallery may not be right. I will have to look at your App in action to provide further guidance. I would recommend posting your issue/query with screenshots on the forums at powerusers.microsoft.com

[@chinnu525]

Thanks for the prompt help Reza.Yes I missed the default value.

[@limychelseafc]

Hi Reza, with lookup and addColumns, is it possible to define the pagination as well? Thank you.

[@RezaDorrani]

Should be possible

[@sarathsubramaniam7991]

@Reza - Why does the formula not show delegation warning if we use FirstN or LastN or both?

[@RezaDorrani]

Because we are using those formulas against gallery items which is data loaded in memory in app.

[@sarathsubramaniam7991]

@@RezaDorrani got it! Thats a new info for me. Thought the formula would behave the same irrespective of where its written. Thank you Reza.

[@RezaDorrani]

@@sarathsubramaniam7991 The hidden gallery is what needs to be filtered.

[@sarathsubramaniam7991]

@@RezaDorrani Yes, tried otherwise, failed, your video saved. Short story 😁

[@RezaDorrani]

@@sarathsubramaniam7991 If issue persists, then post on forums.

[@smbasha]

Hi Reza, What is formula for reset button On select property bcoz u used varReset variable

[@RezaDorrani]

Here is the sample App - github.com/rdorrani/PowerApps/blob/master/PaginatedGallery_20210201175854.zip Download it and check the code please.

[@wojciechjaniszewski9086]

Great Stuff!!

[@RezaDorrani]

Thanks so much

[@wojciechjaniszewski9086]

Hi@@RezaDorrani, I have just implemented your pagination mechanism and it works well but I came across one issue. When I go and edit an item from a gallery and execute SubmitForm(myEditForm) it goes back to my DisplayForm but defaults to the first item on the page I selected an item from rather than the item I selected for editing (I hope it makes sense). Having investigated an issue, the problem seems to be with hiddenGallery.AllItems method under Items property in my visible gallery. When I choose an item from my visible gallery the hidden gallery always points to the top item on the active gallery page. I will try to fix, but if you know a solution on top of your head I would appreciate it :)

[@RezaDorrani]

@@wojciechjaniszewski9086 I don’t think I have understood the scenario. I would recommend posting your issue/query with screenshots on the forums at powerusers.microsoft.com

[@jaganv8343]

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

[@RezaDorrani]

I plan to keep my focus around the Power Platform. I have done very little work with SPFx.

[@remorse7405]

hi reza, how did you manage to create hovering effect for your gallery? do you have a tutorial on how did you create this whole page?

[@RezaDorrani]

Gallery has a property called Transition. It gives 2 hover effect options Push & Pop. Check my gallery design videos - kzbin.info/www/bejne/Y6m2m6yVp9yEfJo & kzbin.info/www/bejne/mJ-maahpnMmKqdU

[@remorse7405]

@@RezaDorrani thanks! i manage to create the hovering but im having trouble figuring out how to add color to the hovered item when hovering

[@remorse7405]

what does your lblStyle do reza?

[@RezaDorrani]

@@remorse7405 Its a label that displays the text "Style" in filter. Has nothing to do with App styling.

[@RezaDorrani]

@@remorse7405 check for hover properties on control. I will also recommend posting your query with screenshots on the forums at powerusers.microsoft.com

[@vaithikarthi7380]

Hello Reza.is there a way can we change the count which gallery is loading by default after optimisation. In this video it’s 100. I understand it’s oob just want to check if we can change it?

[@RezaDorrani]

Cannot be changed

[@thirumaleshm2137]

Hi Reza, As always impressed with your clean and detailed explanation with all similar examples which makes easier for us. Thank you. I came across a question. I would like to have a search bar on the top to display the record I want. But the record I want is not in the first batch load. Any thoughts how I would get this functionality. Thank you so much again :)

[@RezaDorrani]

You are most welcome! The search bar should perform searching on the hidden gallery which loads the paginated gallery.

[@thirumaleshm2137]

@@RezaDorrani Yes, Is there any way that we can search for an item that is not in the loading batch? Thanks again

[@RezaDorrani]

@@thirumaleshm2137 Not that Im aware of

[@raymondsmith8319]

Hey Reza how do you combine the pagination code with the filtering code in your main Gallery?

[@RezaDorrani]

Filter logic is on the hidden gallery. The main gallery simply paginates the information in hidden gallery.

[@raymondsmith8319]

@@RezaDorrani Got it! Thanks for the quick response!

[@bansaripandya2635]

Hi Reza, no one can better explain this topic like this. Quick question here. we create hidden gallery to replace delegation issue. I saw when you add hidden label for Count Rows you received 300 as output, in my case I just add data source [contain 400 records] as item of gallery. and Count Rows I received 100. Should be okay or Output should be 400?

[@RezaDorrani]

Gallery loads data in batches of 100. As you move through the items, it will load the next dat set in optimized manner.

[@bansaripandya2635]

@@RezaDorrani Thanks for your response. Can you do one favor please? In my paginated gallery there is one checkbox field, and I put one checkbox outside the gallery called CheckALL. So when I click on CheckALL. It checks all the checkbox. But I want to check the record based on pagination. How can we achieve that?

[@RezaDorrani]

@@bansaripandya2635 I will have to try it out to let you know the steps. I will recommend you post your query on the forums at powerusers.microsoft.com

[@hitan4673]

hi, i have a question.... Is it possible to do multi selection with checkboxes between the pages on the gallery??

[@RezaDorrani]

That Im not sure.

[@hitan4673]

@@RezaDorrani oohhh :c any way thank you so much for the video. It helps me a lot

[@rashichandel4197]

Hey Reza , can you explain the significance of Reset button and what code is there behind that logic?

[@RezaDorrani]

Reset button is to reset the filters on the top to their default values.

[@nivinilvlogs]

This is awsum!!!!

[@RezaDorrani]

Thanks

[@VamsiKrishnaManikantaBatchu]

HI Reza, Superb Explanation. I implemented the same and working perfect. I have a requirement to Connect different lists (with same columns) to the same paginated gallery. Can you help me on the same. Thanks in advance.

[@RezaDorrani]

I will have to try our your use case to provide any guidance. I will recommend you check on the forums at powerusers.microsoft.com

[@VamsiKrishnaManikantaBatchu]

@@RezaDorrani Thanks for you Response

[@christos-spyridonmoschofid3978]

Hi Reza. If we want the search filter to work for example on the second or third page respectively? How can we achieve that?

[@RezaDorrani]

Filter will work on all records at once, not page by page.

[@ludipforagic]

hi reza, thank you for this video... i'm trying to implement this on my app but the hidden gallery won't show more than 100 records.. It only shows more than 100 records if i scroll it... what should i do to make it work?

[@RezaDorrani]

The video has the logic that scrolls the hidden gallery by design. Not sure why its not working in your case. I would recommend posting your issue on forums in case someone has experienced something similar powerusers.microsoft.com/

[@sonalijain2811]

Hi Rezza, Thank you so much for the session. I have more than 1 lac records, will pagination work for 1lac records efficiently, or it is not recommended to load large dataset in gallery, Thank you in advance. I mean is it okay if store 100000 records in hidden gallery

[@RezaDorrani]

As long as your hidden gallery items property is delegable, Yes

[@ricci.hidalgo]

Excellent tutorial Reza and thanks for sharing. I suppose that only galleries handles automatically blocks of 100 rows and not collections (which is not a visual object).

[@RezaDorrani]

That is correct. Galleries that are delegable will load data in batches of 100 (optimized loading). Collections are local memory that's held in App.

[@ricci.hidalgo]

@@RezaDorrani Yes, but galleries should even load in batches of 100 if no delegable and have no functions or filters, because in that case, there's nothing to delegate to the data source.

[@RezaDorrani]

@@ricci.hidalgo In that case, its still considered a query with no criteria and it is delegable. So it will load data in batches of 100.

[@ricci.hidalgo]

@@RezaDorrani Yes, I meant "non-delegable data source", so the query in that case is delegable because it has no criteria or filters and can load infinite rows in batches of 100 for example from Fin & Ops, even if it is a non-delegable data source. I think that is it important to distinguish between delegable data source and delegable functions.

[@RezaDorrani]

@@ricci.hidalgo Correct.

[@LilCheez]

This is very helpful, but I'm having a problem. I am able to use my hidden gallery's default property to automatically set the selected item to the last item in the gallery (as shown in the video). But this does not trigger the gallery to load additional items from SharePoint. In troubleshooting, I made my hidden gallery visible and scrolled to the bottom of it. Even that did not trigger the gallery to load additional items. Is there a setting that controls whether the gallery loads additional items once the user accesses the last item?

[@LilCheez]

I resolved this issue. The problem turned out to be in the Items property of the hidden gallery. Despite using delegable functions and not getting any delegation warnings, I was encountering a delegation issue because the SortByColumns() was inside the Filter(). I resolved this putting the Filter() inside the SortByColumns().

[@RezaDorrani]

Looks like you got it to work based on response comment

[@miguelsierra7379]

Hi, I have the Hidden Gallery and the Not Hidden Gallery, then in the Not HIdden Gallery I call the Hidden Gallery but just show me 100 rows and my backend have 200 rows, did I something wrong? Thanks for everything!

[@RezaDorrani]

A gallery only loads 100 records at a time. When you reach the last item in the gallery, it will load the next 100. This is known as optimized loading. Its the default behavior of a gallery. Check the video in which I set the default value of hidden gallery.

[@miguelsierra7379]

@@RezaDorrani It is not working. :( But, thanks for your patience :D

[@RezaDorrani]

@@miguelsierra7379 If you repeat all the steps in the video, it will work.

[@pranavpatel7925]

Hi Reza, Thank you for the amazing video tutorial, I am having one issue if you can help it will be much appreciated Issue is I am moving to 3rd page, applying search criteria and result is only 1 record, is it not moving back to 1st page automatically. Please help. Thank you

[@RezaDorrani]

I would have to look at your App in action or recreate your issue to provide any guidance. I would recommend you post your issue/query with screenshots on the forums at powerusers.microsoft.com

[@pranavpatel7925]

​@@RezaDorrani let me try to explain, in your demo app, put textbox and in hidden gallery use it to filter using StartsWith. now when page load, there are total 100 records with pagesize 10, I move to 2nd page onwards, not try to search value in textbox which must have less then 10 records, so, it will be on 2nd page as blank because first page is sufficient enough to display data. the issue is if so, it is not moving back to first page automatically. Please have a look, Thank you

[@RezaDorrani]

@@pranavpatel7925 You will need to ensure to set default property of hidden gallery. This is shown in the later part of the video.

[@prernasingh262]

I would like to know , if this issue is resolved or not and if it is then how 😊

[@RezaDorrani]

@@prernasingh262 Set(varPageNumber,1) is the key whenever you need to reset.

[@limychelseafc]

Hi Reza, this certainly solved my use case! Thanks for sharing this! One question, is it possible to show the number of total pages and total returned rows instead of using the + sign? Thank you.

[@RezaDorrani]

CountRows is not a delegable query, so it will not give accurate results. Hence, I have avoided it in video.

[@limychelseafc]

@@RezaDorrani does that mean that there is not any way to get the total count of data other than using Power Automate?

[@RezaDorrani]

@@limychelseafc Not without running into delegation warnings.

[@valmikiarjun782]

Hi Reza, the video is amazing with crystal clear explanation👌👌 . I only have one challenge when filtering the data with pagination data selected. For example, when we launch on to the home screen the data will be displayed with the set of records from the number that we have in the pagination dropdown. Consider that we have the pagination number as 5. When we navigate to the next page, the next set of records will get displayed from (i.e) 6-10. Now, my challenge is that when we navigate to the page 2 and change the pagination from 5 to 10 in the second page, then instead of listing the next 10 set of records (i.e) from 6-15 items it loads the data which falls from 11-20. Can you give me some inputs that can help to achieve my requirement to display items that are from 6-15 ? Thanks in advance.

[@RezaDorrani]

When pagination size changes, then reset the hidden gallery. Set(varReset, false);Set(varReset, true) And use varReset as a filter criteria in hidden gallery.

[@valmikiarjun782]

Can you please elaborate how to use the condition ?

[@RezaDorrani]

@@valmikiarjun782 The previous comment was the simplest explanation I could give. I would recommend posting your query on forums at powerusers.microsoft.com

[@fakharahmedkhan5157]

Could not have better than this, simply amazing. Understood every single point. But I have a question, If I am trying to search anything in the search box on Page 2/3/4, results are appearing in Page number 1 and I need to navigate to page 1 to see results. What we want is; Result should appear in the current page. How can I achieve that? Please help !!!

[@RezaDorrani]

There are 2 galleries in play here. One which is hidden - where all searching and filtering logic should be applied to. The one which is visible is only demonstrating the info in hidden gallery. So when you search and filter on hidden gallery, the visible gallery will show the filter results (gallery is reloaded with filtered data) and results will start from page 1 itself.

[@fakharahmedkhan5157]

@@RezaDorrani So there is no way we can show results on the current page.(Page 2,3 or 4)?

[@RezaDorrani]

@@fakharahmedkhan5157 Gallery reloads with new data. So keeping user on current page does not add value. User should see reloaded data since a query was performed against the data source.

[@fakharahmedkhan5157]

@@RezaDorrani Understood, you are a life saver brother. God bless you 😃

[@fun2222sss]

Very helpful video. I have merged pagination in editable grid but when I search or moving to next, whatever we have done changes is lost.

[@RezaDorrani]

I will have to look at your App in action to provide any guidance. I would recommend you post your issue/query with screenshots on the forums at powerusers.microsoft.com

[@ajisharavind6937]

Save my life Reza 😊

[@RezaDorrani]

👍

[@tfibestshorts603]

Thanks mate 👍👍

[@RezaDorrani]

Any time!

[@shilpasprasanna3709]

Hi Reza, Can you please tell me if this will work on 1 million of records in SharePoint as datasource as well?

[@RezaDorrani]

Why 1 million? Let's say 1 billion :) Yes, it will work as long as the query is delegable.

[@satishkumar-or2dp]

How do I filter of some text fields like first name, lasrname,city, app I'd and I have choice columns and date column in my database as dataverse along with pagination.

[@RezaDorrani]

You just apply your filter logic on that hidden gallery. Multiple filters on gallery - kzbin.info/www/bejne/a5W2nGifhMyHbJo

[@ECERaagulLD]

You are amazing.

[@RezaDorrani]

Wow, thank you!