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.
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
Sign in to Power Apps.
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.
On the toolbar select Switch to classic. This opens solution explorer in a new browser window.
In the Entities list (these represent Dataverse tables), open the table you want, select the Controls tab, and then select Add Control.
In the Add Control dialog box, select Editable Grid, and then select Add.
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.
To add a lookup, in the Editable Grid option group, select Add Lookup, and then in the Configure Property "Add Lookup" dialog box:
In the Available Views list, select the view to add the lookup to (for example, select My Active Accounts).
In the Available Columns list, select the lookup column to add (for example, select Primary Contact).
In the Default View list, select the data source for the lookup column.
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.
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.
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.
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
To save your work, select Save on the action bar.
When you're ready to make changes available to your team, select Publish on the action bar.
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.
Sign in to Power Apps.
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.
Select the Table within the solution, and then select the Forms area. Select the Main Form that contains the subgrid.
Select Switch to Classic. This will open a new tab in your browser.
Select the appropriate control, and then select Change Properties on the ribbon.
In the Set Properties dialog box, select Controls.
Select Add Control, select Editable Grid, and then select Add.
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.
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 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
Feedback
https://aka.ms/ContentUserFeedback.
Coming soon: Throughout 2024 we will be phasing out GitHub Issues as the feedback mechanism for content and replacing it with a new feedback system. For more information see:Submit and view feedback for