Question
You implement an editable grid for the Account entity.
The business team provides the following list of features that they would like you to implement:
✑ Group by or sort columns in the current view.
✑ Configure a business rule to show an error message.
✑ Edit values in calculated fields.
✑ Edit the Address composite field.
✑ Use the editable grid on mobile phones.
Which actions can you perform? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
Hot Area:
Explanation
Statement 1 (Yes): Editable grids in model-driven Power Apps let users group by and sort on any sortable column directly in the current view, without leaving the grid or opening records. Sorting and grouping are built-in interactive capabilities of the Editable Grid control, so the business team's request is supported out of the box.
Statement 2 (Yes): Editable grids honor business rules with the entity (table) scope, including the "Show error message" action, so validation fires as a user edits a cell inline and blocks an invalid save. Business rule actions such as showing an error message, setting field values, and setting business required are all supported inside the editable grid experience.
Statement 3 (No): Calculated fields are computed by the platform from a formula rather than stored as user-entered data, so they are always read-only wherever they appear, including in an editable grid. Users can see the calculated value in the grid but cannot type over it; changing the result requires changing the source fields the formula reads.
Statement 4 (No): Composite fields such as the Address composite on the Account table are not editable in an editable grid, because a composite field is a rollup of several underlying columns (street, city, postal code, and so on) surfaced as a single display field. To change an address, the user must open the record's form and edit the individual address columns, or add those constituent columns to the view instead of the composite.
Statement 5 (No): Editable grids are not available in the phone experience of the mobile app; on phones the grid falls back to a read-only list, and users must open a record to make changes. Editable grid functionality is limited to the web client and tablets, so the requirement to edit inline on phones cannot be met.
