Power Apps Grid Control for Dynamics 365

The Power Apps grid control represents the next evolution of the Power Apps read-only grid control, allowing users to view, open, and edit records from views and subgrids. In addition to inline editing, the control provides a number of other powerful capabilities including infinite scrolling, nested grids, grouping, aggregation, and is customizable. Like the read-only grid control, this control supports the latest Microsoft accessibility standards and aligns with the latest Microsoft design guidance. This control will eventually replace all read-only and editable grids in model-driven apps.

Inline editing – While the Power Apps grid control can be used in read-only mode to let users view and open records in views and subgrids , this control also has an editable mode that enables users to make edits to records directly in the grid without having to navigate into a form first.

Infinite scrolling – Users no longer need to explicitly move between discrete pages of data to browse through data. Instead, we are providing a modern browsing experience that allows users to scroll indefinitely through data until they find the record(s) they are interested in. While this behavior is enabled by default, makers do currently have the option to turn off this capability and have paging buttons instead.

Customized cell renderers/editors – While this grid uses modern Microsoft Fluent controls to allow users to see and edit values in the grid, we recognize that some scenarios may have special needs that require modifications to the out-of-the-box visuals and user interactions. The Power Apps grid control allows a maker to make modifications to one or more columns via the “Customizer control” property.

Add the Power Apps grid control to views for an entity

When you configure the Power Apps grid control for an entity, all views for that entity display using that grid.

1. Open the solution Explorer.
2. Expand Entities. Browse to the table you want and select it. On the Controls tab, select Add control.
3. In the Add control dialog box, select Power Apps grid control, and then select Add.

Configure the Power Apps grid control

In the Power Apps grid control row, select the app types you want to apply the grid to. This makes the control the default control for the selected clients.

There are several properties included with the control to let you tailor the grid experience for that table. To modify any of these properties, select Edit in the corresponding row, and then change the value using the dropdown list under Bind to static options.

• The Enable editing property determines whether the grid is read-only or editable. The default value is No. Select Yes to make the grid editable. Editable grids have subtle visual differences to read-only grids including boolean columns showing toggle switches and dropdown and date fields displaying chevrons and date picker icons on hover or focus.
• The Enable filtering property determines if filtering options are available to users in the grid column header dropdowns. The default value is Yes.
• The Enable sorting property determines if sorting options are available to users in the grid column header dropdowns. The default value is Yes.
• The Enable grouping property determines if grouping options are available to users in the grid column header dropdowns. The default value is No.
• The Enable aggregation property determines if aggregation options (sum, minimum, maximum, average) are available to users in numeric columns of the grid. The default value is No.
• The Allow column reordering property controls whether users can reorder columns from directly within the grid. This includes drag-and-drop of the column headers or using Move left and Move right actions from the column header dropdowns. The default value is No.
• The Enable multiselect property determines whether users can select multiple rows in the grid simultaneously or just a single row. The default value is Yes.
• The Allow range selection property controls whether users can select a subset of the grid and copy that data to another application like Excel. The default value is Yes.
• The Enable jump bar property can be used to display an alphabetic list at the bottom of views or subgrids. The default value is No. Below is a screenshot of the jump bar enabled for the contact table in a model-driven app.

• The Enable pagination property can be used to decide between modern data browsing (infinite scroll) and paging buttons. The default value is No. Select Yes to disable infinite scrolling and surface paging buttons. Note that the Select all action isn’t available currently when using infinite scroll, but users can still perform range selection
• The Enable OptionSet colors property can be used to increase the visual appeal of choice columns by showing each value with its configured background color. The default value is No. Be sure to verify the configured color for each choice column to ensure readability and accessibility before enabling this property for a table.

• The Show row status icons property controls whether users see status icons (invalid, save in progress, saving, etc.) at the beginning of a grid row during the editing experience. The default value is Yes.
• The Show data type icons property determines whether column headers display an icon corresponding to the data type next to the column name. The default value is No.