Grid control support for grouping, aggregation, nested grids

Important

Some of the functionality described in this release plan has not been released. Delivery timelines may change and projected functionality may not be released (see Microsoft policy). Learn more: What's new and planned

Enabled for Public preview Early access General availability
Users by admins, makers, or analysts Oct 2022 - -

Business value

You can be more productive in the grid by being able to access related records without leaving the grid and by getting meaningful insights into your data through grouping and aggregation capabilities.

Feature details

The Power Apps grid control for model-driven apps entered a public preview stage during the last release wave and featured the following capabilities:

  • Infinite scrolling: Users no longer need to page to see more records. Instead, users can continue scrolling to get to the row(s) they are interested in. The grid can be configured to use paging buttons instead by the maker if desired.
  • Inline editing within views and subgrids: In addition to being available for read-only scenarios, this control can also be used as an editable grid. When editing is enabled by the maker, users can be more productive by making edits directly in the grid instead of having to make changes in the corresponding form.
  • Customizable cells: If the default visualization for the cells in one or more columns doesn't meet your needs, makers can create custom cell renderers and editors to modify how cells look when showing data and when users are editing data.

Building on this effort, the Power apps grid control is now being extended in the following ways to not only reach parity with the legacy read-only and editable grids but also provide even more advanced functionality. It's important to note that these capabilities are available regardless of whether the grid is being used in read-only or editable mode.

  • Nested grids: Expand a row to see a grid of related records. Multiple rows in the grid can be expanded simultaneously.
  • Grouping: Organize tabular data in interesting ways by grouping the data based on one column. Each group of rows can then be expanded and collapsed as desired.
  • Aggregation: Get meaningful insights into tabular data by enabling aggregation on one or more numeric columns in a grid. For each column, users can choose to see the total, minimum value, maximum value, or average of values from that column. If grouping has been applied to the group, then this aggregate value will also be displayed for each group.

Screenshot of a grouped grid with one column showing totals.

Screenshot of nested grids open for two rows in the main grid.