Add and configure a subgrid component on a form
A form that displays the details of a table record can use a subgrid component to display a list of related or unrelated rows in a tabular format. Makers can add and configure a subgrid component using the form designer.
Add a subgrid component
Sign in to Power Apps.
Expand Data, select Tables, select the table that you want, select the Forms tab, and then edit the form you want.
Note
Customizations to a table should take place within a solution. To update a table within a solution, open your solution from the Solutions area, select the table, select the Forms tab, and then edit the form you want.
Select +Component on the command bar. This can also be selected from the left pane.
Drag a 1 column section from the layout area of the components menu onto the form.
Select Subgrid from the Related Data area of the components menu.
On the Select subgrid views pane:
- Typically app users want to view related records. When Show related records is selected, only tables with a relationship are displayed.
- Select the Table you want.
- Select the Default view from the table. When an existing view is not suitable for the app, create or edit a view for the table.
Select Done.
Select Save, and then select Publish.
Configure a subgrid component
These are the properties available to configure when using a subgrid component on a form using the form designer.
| Area | Name | Description |
|---|---|---|
| Display options | Label | The localizable label for the subgrid visible to users. This property is required. |
| Display options | Name | The unique name for the subgrid that is used when referencing it in scripts. The name can contain only alphanumeric characters and underscores. This property is required. |
| Display options | Hide on phone | The subgrid can be hidden to render a condensed version of the form on phone screens. |
| Display options | Show related rows | When selected, the subgrid displays only rows related to the current row that is displayed on the form. The Table drop-down list is also filtered to only list tables that are related to the current table. |
| Display options | Table | The table whose rows you want to display in the subgrid. When Show related rows is selected, the list of tables is filtered to show only tables that are related to the current table. In addition to the table name, the name of the lookup column is also displayed in parentheses. |
| Display options | Default view | The view of the table selected in the Table property that will be used to get and display the list of rows in the subgrid. |
| Display options | Allow users to change view | When selected, app users can change from the Default view to another view of the table selected in the Table property. |
| Display options | Show all views | When selected, app users can change from the Default view to all other views of the table selected in the Table property. This property is only available when Allow users to change view is selected. |
| Display options | Selected views | A list of views of the table selected in the Table property that app users can change from the Default view. This property is only available when Allow users to change view is selected and Show all views is cleared. |
See also
Overview of the model-driven form designer
Create, edit, or configure forms using the form designer
Add, configure, move, or delete columns on a form
Add, configure, move, or delete components on a form
Add, configure, move, or delete sections on a form
Add, configure, move, or delete tabs on a form
Configure header properties in the form designer
Add and configure a quick view component on a form
Configure a lookup component on a form
Using the tree view in the form designer
Create and edit columns