Configure Nested Grid Controls in Power Apps for Entity Views

Nafzin A A's avatarWritten by

Posted on

The Power Apps grid control is an advanced version of the read-only grid, offering users the ability to easily view, open, and edit records within views and subgrids. Alongside inline editing, it boasts features like infinite scrolling, nested grids, grouping, and customization options.

In this blog post, we’ll guide you through the process of adding and configuring the nested grid control within entity views, empowering you to optimize your Power Apps experience effortlessly.

Here, the scenario involves displaying all projects (child entities) associated with their respective clients (accounts) in a nested grid format within the Account Views as depicted below (Fig 1).

Fig.1

Add the Power Apps Grid Control to Views for an Entity

1. Navigate to Power Apps > Advanced Settings, then open the Solution Explorer and select the solution containing the entities you want to configure.

Fig.2

2. Expand the Entities section, select the desired table(Client), and then navigate to the controls tab for additional configurations.

Fig.3

3. In the Add Control dialog box, select Power Apps grid control, and then select Add.

Fig.4

Configure the Power Apps Nested Grid Control

1. In the Power Apps grid control row, choose the app types to which you want to apply the grid(Fig 5).

Fig.5

The Child items property is used to configure the nested grid capability, which allows users to expand rows to see related records in a subgrid.

2. To set this up, you specify the Entity where the related records come from and the View that you want to show in the subgrid. In this case, we are selecting Projects(child entity) in the entity dropdown and view as “All Projects”(Fig 6).

Fig.6

3. Configure the Child items parent ID property and specify the field (lookup), which is used to link the parent and child entities together.

Fig.7

4. Once you are done with the configurations, select Save to save your changes and when you’re ready to make the changes available to app users, select Publish on the command bar.

Fig.8

Now, you can head over to the Entity (Accounts) Views section in your Power App to see how the Parent(Accounts) and Child(Projects) records are organized in the nested grid pattern.

Fig.9

In conclusion, by following this approach, you can effectively configure and view your parent-child-related entities using nested grid capabilities, enhancing the organization and accessibility of your data within Power Apps.

Hope this helps!