Efficient Data Management using New Enhanced Grid Features

The 2024 Wave 2 release includes a noteworthy update in the form of new grid features in Power Apps.

What is it all about?

These improvements are meant to make it easier for users to view and use data. Users will find it easier to manage massive datasets with the new grid's better data filtering, sorting, and inline editing features. These features improve user productivity by enabling speedy information retrieval and updating, while also streamlining and simplifying data management. Businesses that primarily rely on data-driven decision-making and require effective tools to manage their data may especially benefit from this update.

Model-driven applications now have new grid features that make it easier for users to view and interact with data. You may easily accomplish various jobs with the capabilities, such as grouping and aggregating data, rearranging columns, and setting column width.

What are it's features?

Numerous functional and aesthetic enhancements to the Power Apps grid control enhance users' out of the box experience.

Grouping and aggregation

Users of the Power Apps grid control have the option to organize data according to a particular column. Users can choose to extend (and re-collapse) groups, although they are collapsed by default. Regardless of whether the grid is set to be editable or read-only, this feature is accessible.

Users can also combine one or more of the grid's numerical columns. Users have the option to view the average, minimum, maximum, or sum of the numbers in each column. This aggregate value will also be shown for each group if grouping has been used.

When an entity is set up to use the pipeline view or the read-only grid component by default, these features are activated.

You must enable this behavior for other instances that require manual configuration by utilizing the Enable grouping and Enable aggregation options.

Column headers allow users to aggregate and combine columns. Only column types that support these operations have options.

Simple column rearranging

The ability of users to rearrange columns directly within the grid is determined by the Allow column reordering property. This includes using the Move left and Move right actions from column header dropdown menus, as well as the ability to drag and drop column heads.

Redesigned list mode style

The Power Apps grid control's list mode has been modified to conform to Fluent styling, with adjustments made to the font size and weight to denote the relative importance of each field in the list.

List mode sorting is supported

Users notice a new header row with a sort icon at the top of the list when using the Power Apps grid control in list mode. By clicking on this button, the user can select the sort direction and column from a menu. If column sorting is not supported by the grid, this option is suppressed.

Command bar for nested grid

When a row in the nested grid is chosen in the Power Apps grid control with configured nested grids, the correct command bar is now displayed.

Column width can be set to a specific value

Now, using the column settings, you may adjust the column width to a certain pixel value. This makes it possible to set column width with just the keyboard.

The ability to scroll endlessly while selecting every record

On all contemporary grids, the option to choose all records will be present by default. This option will select up to 1000 records when used with infinite scroll.

Conclusion:

So now users will have more privilege while working with columns and data in grids and views. Now, you can adjust the column widths, aggregate the data, group the data, and more. A feature that greatly simplifies working with fields for average users.