Improvements to the grid control

  • Article

Important

This content is archived and is not being updated. For the latest documentation, go to What's new or changed in Finance and Operations apps home page. For the latest release plans, go to Dynamics 365, Power Platform, and Cloud for Industry release plans.

Enabled for Public preview General availability
Users, automatically Feb 6, 2023 Apr 3, 2023

Business value

These enhancements increase grid user productivity and general usability of the grid.

Feature details

Grids are a critical component to ERP applications that are used extensively throughout all Finance and Operations applications and cater to a variety of user scenarios. In this release wave, a number of improvements have been made to the grid control to help users be more efficient and productive when interacting with the grid.

  • More robust fast data entry: In some situations, changes that users had made in the grid ahead of what the system had processed had to be discarded due to page logic refreshing the grid data. Improved tracking of records with edits (via RecIDs) is now available so that unsaved changes are retained after data refreshes for most scenarios. Unsaved changes may still be discarded for scenarios where records do not have persistent RecIDs (temp tables).

  • Be more efficient with the keyboard: For users who want to be as efficient as possible in the system using just their keyboard, a number of new keyboard shortcuts have been added to the grid control to help you be as productive as possible. These shortcuts include actions related to fast data entry, grouping, column pinning, and column aggregation.

  • Select a range of cells: When users need to extract specific information from a tabular grid, they no longer have to copy entire data rows. Instead, users can use the keyboard to select only the desired rows and columns, similar to Excel. The selected cells can then be copied and pasted into other applications, like Excel.

  • See aggregate values for selected rows: When columns are configured to show an aggregate value like a total, minimum, maximum, or average, the aggregated values are computed based on the entire dataset. If multiple rows are selected, no aggregate value is displayed. Based on customer feedback, this capability has been extended to compute and display the desired aggregate for the selected rows when more than one row has been selected.

See also

Grid capabilities (docs)

Use filtering techniques (learn)