Dataverse Delegable Paging in Power Apps
Vložit
- čas přidán 5. 07. 2024
- In this tutorial, I show how to use the Creator Kit DetailsList grid with both internal and external paging so that it is fully delegable inside a Power Apps model-driven app.
The Creator Kit DetailsList supports automatic paging if you are bound directly to a data source. Once you bind to a collection you need to then implement paging externally to the control and ensure that the sort and filtering are happening on the server.
This is part of a series of videos on building a model-driven custom page that shows a grid of accounts with fully delegable sorting, paging and filtering:
👉aka.ms/creatorkit
✅ Responsive Containers • Responsive containers ...
✅ Responsive Grid with adaptive columns • Dataverse Grid Control...
✅ Dataverse Delegable Paging in Power Apps
• Dataverse Delegable Pa...
✅ Multi-value filtering using a Tag Picker • How to create multi-va...
✅ Command Bar and model-driven navigation in custom pages
• Command Bar and model-...
#ModelDriven #PowerApps #CreatorKit
Contents:
00:00 Introduction
00:25 Review of the app we are building
01:07 Review of delegation
02:29 Delegation in a Gallery
05:13 Skip tokens with GetMoreRows network calls
06:04 DetailsList so far
06:32 Adding simple filtering
09:58 DetailsList TotalRecord & TotalPages properties
10:11 Adding paging controls
14:25 Large Dataset Paging
15:30 Using CountRows to get the total number of records with delegation
18:37 External Paging & Sorting
28:34 Delegable Sorting
35:37 Summary - Jak na to + styl
Grr... built one like this yesterday, now i have to go back and make improvements based on your video!
This is an amazing way to handle sorting data and handling delegation on galleries! Thank you for sharing!
Thank you so much Leonardo - and thank you for watching 😊
Next up is filtering Yaser 😉🚀
Thanks for sharing, it's very helpful.
Outstanding tutorials. Not only because of topic, but mostly because of way You explain this. Thanks a lot.
I wish only, that I cannot avoid delegation limit with AddColumns in source of gallery.
❤❤❤ love this very much, you save my day 😍😍😍
That is really awesome to hear - thank you for commenting - it is very encouraging. 🤩
Thanks for the amazing information.
Thank you for watching! Do you often need paging in your apps?
@@ScottDurow No, But I often learn amazing information from you
Great info. One of the missing features of the unified interface is the ability to sort by multiple columns. It would be great to see how you would tackle that issue with the Details List.
Thank you and thanks for watching and subscribing ☺️ Multi sort would need to be handled by adding some user interface that is alongside the details list that can be used to add sort columns - then use that in the Items expression. I’ll add that to the backlog for my videos! Thanks again!
Great video, Scott.
Maybe I missed it, but did you show how to filter the DetailsList on the click of the 'Apply Filters' button instead of it happening instantly?
Great video! I tried implementing this approach with a large dataset (dataverse table with 1700 records) but it seems like there is no server side paging going on with the details list. All the records are downloaded to the client regardless of the page that's being displayed. Using the monitor I can see that on every page change, all 1700 records are returned by the getRows call. Is this the expected behaviour for internal paging? Thanks!
Great video, Scott. One thing I don't understand is where the paging stack came from, you pasted it in I think - but I don't find a component like that in the creator kit, so I assume that you created this group of controls individually from a horizontal container, 3 x fluent ui icon and 1 label, in another app/page and pasted it in during the video?
Thank you and thanks for watching - yes - it's just a bunch of icons and a label in in a container. You could even create a canvas component for it! 😊
Great video!
My favorite part is the workaround for sorting on lookup and choice columns, do you have a video on how to create that flow?
Thanks!
Hi Mohamed - thank you for watching! That’s a great idea - I’ll be sure to include that in a future video!
@@ScottDurow Amazing!
Keep up the good work, Scott.
Scott, we really need more videos in support of the creator kit more advanced user cases also the last update of the kit was back in December 2022 when should we expect the new one?
Thank you and thanks for watching - I’ll definitely be doing more of these kind of videos! There should be a new release of the creator kit coming out soon!