Make model-driven app views editable using the editable grid control

By default, users can't enter data directly using the read-only view control for views and subgrids on forms. Users select the row in the grid to open a form, edit the data, and then save, which requires multiple steps. With editable grids, users can do rich in-line editing directly from views and subgrids whether they're using a web app or tablet. This editing experience is not available on phones.

Editable grid examples.

When editable grids are enabled through the editable grid control, users can edit the data inside most types of columns, including basic Lookup columns and choices. This avoids the need to navigate to a form.

Make main grids editable

  1. Sign in to Power Apps.

  2. Select Solutions, and then open the solution you want. If the item isn’t in the side panel pane, select …More and then select the item you want.

  3. On the toolbar select Switch to classic. This opens solution explorer in a new browser window.

  4. In the Entities list (these represent Dataverse tables), open the table you want, select the Controls tab, and then select Add Control.

    Add Editable Grids custom control.

  5. In the Add Control dialog box, select Editable Grid, and then select Add.

  6. In the Editable Grid row that's added, select the form factor(s) you want to apply the grid to. This makes the editable grid control the default control for the selected form factor(s). As a minimum in most instances, select Web. At runtime, users will be able to toggle between editable grids and read-only grids.

    Note

    Since the editing experience is not available on the Phone form factor, if this control is configured for phones, you will see a read-only version of the list control.

    Editable Grid row with form factor selection.

  7. To add a lookup, in the Editable Grid option group, select Add Lookup, and then in the Configure Property "Add Lookup" dialog box:

    1. In the Available Views list, select the view to add the lookup to (for example, select My Active Accounts).

    2. In the Available Columns list, select the lookup column to add (for example, select Primary Contact).

    3. In the Default View list, select the data source for the lookup column.

    4. If you want to limit the rows displayed, select the Only show rows where check box, and then select your criteria from the list, and then select OK.

      Add lookup in Editable Grid control.

  8. If you have a nested grid, select the pencil button for Nested grid view, and then select the table and view for the nested grid. For the Nested grid parent ID select the relationship for the tables. For example, the ParentAccountID column connects the Account and Contact tables.

    Note

    Nested grids are only available for phones and tablets, not the web.

  9. If you don't want to allow the user to group data by any column in the view (you want to save space, for example), in the Group by Column row, select the pencil button, and then in the Configure Property "Group by Column" dialog box, select Disabled, and then select OK.

    Tip

    This is mostly useful for sub-grids on forms.

  10. If you want to add JavaScript events, select the Events tab, and then select the appropriate tables, columns, and events. More information: Developer Documentation: Use editable grids

    Add events in Editable Grid control.

  11. To save your work, select Save on the action bar.

  12. When you're ready to make changes available to your team, select Publish on the action bar.

  13. To test your changes, go to the view you specified in the previous step, and then make some in-line editing changes.

Make a subgrid on a form editable

Note

  • To save an editable grid change within a sub-grid, the user must explicitly save before navigating out of the form.
  1. Sign in to Power Apps.

  2. Select Solutions, and then open the solution you want. If the item isn’t in the side panel pane, select …More and then select the item you want.

  3. Select the Table within the solution, and then select the Forms area. Select the Main Form that contains the subgrid.

  4. Select Switch to Classic. This will open a new tab in your browser.

  5. Select the appropriate control, and then select Change Properties on the ribbon.

    Editable subgrid - classic view

  6. In the Set Properties dialog box, select Controls.

  7. Select Add Control, select Editable Grid, and then select Add.

  8. In the Editable Grid row that's added, select the form factor(s) you want to apply the grid to. This makes the editable grid control the default control for the selected form factor. For most instances select Web.

    Editable Grid row with form factor selection.

  9. Select Save, and then select Publish.

Editable grids support

  • In-line editing of rows at the table or subgrid level (includes custom tables).

  • System views and personal views.

  • Web and mobile clients.

  • Navigation with a keyboard or mouse.

  • Grouping and sorting (you can group by/sort rows on the client-side by any column in the current view).

  • Filtering.

  • Moving and resizing columns.

  • Pagination.

  • Lookup configuration.

  • Calculated columns and rollup columns.

  • Business rules (Show error message, Set column value, Set business required, Set default value, Lock or unlock column).

  • JavaScript events.

  • Enabling or disabling of cells based on security role.

  • Users can continue to use search and charts, and can access the action bar as with read-only grids.

Supported standard tables

Web/tablet/phone Tablet/phone only Web only
Account

Appointment

Bookable Resource

Bookable Resource Booking

Bookable Resource Booking Header

Bookable Resource Category

Bookable Resource Category Assn

Bookable Resource Characteristic

Bookable Resource Group

Booking Status

Case

Category

Characteristic

Competitor

Contact

Email

Entitlement

Feedback

Invoice

Knowledge Article

Knowledge Article Views

Knowledge Base Record

Lead

Opportunity

Order

Phone Call

Price List

Product

Queue

Quote

Rating Model

Rating Value

SLA KPI Instance

Social Activity

Social Profile

Sync Error

Task

Team

User
Activity

Attachment

Channel Access Profile Rule Item

Competitor Address

Connection

Connection Role

Email Signature

Email Template

Expired Process

Invoice Product

Knowledge Article Incident

Lead To Opportunity Sales

Process

Mailbox

New Process

Note

Opportunity Product

Opportunity Sales Process

Order Product

Organization

Phone to Case Process

Price List Item

Queue Item

Quote Product

Sharepoint Document

Translation Process
Campaign

Campaign Activity

Campaign Response

Channel Access Profile

Channel Access Profile Rule

Contract

Entitlement Template

External Party

Fax

Letter

Marketing List

Position

Quick Campaign

Recurring Appointment

Sales Literature

SLA

Limitations

Data types that aren't editable in an editable grid

The following data types aren't editable in editable grids: Customer and Partylist Lookup columns; Composite (address) columns; State/Status columns; Lookup table-related columns (for example, the Account table includes a contact lookup, where the Contact column is editable but the EmailAddress(Contact) column is not editable).

Group by views work on client side only

Grouping behavior works only on the client side and does not span pages. Group by is a client only function and works only on one page of data. Group by does not show you all options based on your complete data set on the server. Group by shows grouping only on the current page. You can disable the grouping by using the property on custom control configuration. More information: Make main grids editable

Inline grid modifications are not persisted

Changes made to the structure of the editable grid from within the grid, such as column resizing, colum reordering, grouping, filtering, and sorting, will be reset the next time the user visits the page. These types of changes are not saved across sessions or within views.

Business rules work only if conditional column is a column on the grid

Business rules on an editable grid are supported only if the conditional column is also a column on the grid. If the column is not a column the business rules won’t work. Verify that each column referenced in the business rule is also included on the form. Note that business rules on an editable grid do not fire if the editable grid is configured on a dashboard.

Editable grids don't work on phones

Based on customer feedback, we have removed the editable grid experience from phones. When using a editable grid on a phone, you will see a read-only version of the list control.

Duplicate rows in a dataset might not be displayed in the grid

If the dataset displayed in the grid contains duplicate rows, the duplicates might not display in the grid. This can lead to the reported record count showing more records than are actually in the grid, or more records appearing when exporting the data to Excel or viewing the data in legacy Advanced Find.

Next steps

Setting managed properties for views

Keyboard shortcuts for editable grids (views)