Nested Grids – as the name suggests is a grid-within-a-grid (or rather, Grid-ception!). Nested Grids will let you expand a sub-grid entry to look at another grid of the expanded record. This depends on how you configure it.
Be aware, Nested Grids work with Editable Grids and only for Tablet, Phones and Unified Interface. This is not available for the classic Web UI.
Configuring Nested Editable Grid
Here’s my entity structure – I have Account, having multiple Contacts and each Contact, having Opportunities under them. Like in the below diagram –
Now, I have a Contact grid on my Account form (just like we usually do).
- I now will have to choose the grid to be a Editable Grid Control as follows. Also, click on the Nested grid view control as pointed
- On clicking the Nested grid view pencil, the next dialog box will let you select what entity you want the Nested Grid to be for. Note that this is with respect to the Contact entity and not the Account entity. For this example, I chose Opportunities.
- On selecting the entity, I have to make sure my View is also correctly set to show the records
- Now, my dataset will populate from the selected Entity and View. next we will need to select what should be bound as a key. Going back to the Nested grid parent ID pencil this time
- Select what should be the field to bind the data. In this case, I want to show the one that is related to the Contact expanded.
- Now, click OK for everything and your configuration should look like below.
Finally save and Publish all customization.
Using Nested Editable Grid
Now, if you look at the Contact grid on the Account form. You’ll see an arrow on each record which indicates that it can be expanded.
And when you click on it, you’ll see the Nested Grid for Opportunities we configured in the section above
And yes, Opportunity too is editable in-line!
Hope this helps!!
[…] Nested Editable Grids in D365 CE v9 UCI […]
LikeLike
Thanks for this article Priyesh, this functionality will really come in useful for an upcoming project I’ll be working on.
LikeLike
Thanks a lot Paddy!! 🙂 Yes, it’s pretty useful. Clients from a practical standpoint do expect something like this to be available. Good that this is available now!
LikeLike
[…] Quick guide on how you use Nested Editable Grids in D365 v9 Unified Interface — Read on d365demystified.com/2019/07/25/nested-editable-grids-in-d365-ce-v9-uci/ […]
LikeLike
Can we achieve this level of grid binding?
https://community.dynamics.com/crm/f/microsoft-dynamics-crm-forum/376510/dynamics-365-online-3rd-level-grid
LikeLike
No, unfortunately, this is only restricted to Level 2.
LikeLike
Reblogged this on Nishant Rana's Weblog.
LikeLike
Reblogged this on Phani Rajasekhar.
LikeLike
[…] D365 Demystified […]
LikeLike