Events
Power BI DataViz World Championships
Feb 14, 4 PM - Mar 31, 4 PM
With 4 chances to enter, you could win a conference package and make it to the LIVE Grand Finale in Las Vegas
Learn moreThis browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
Model-driven apps use views to define how a list of records for a specific table are displayed in the application.
A view defines:
Once a view is available to the app, the user can select it.
When makers design an app, they decide which of the public views to make available to app users. These decisions are typically based on the type of user, such as sales or marketing, that use the app.
Views can be developed through the table designer or the app designer.
There are three types of views: personal, system, and public.
Users might want to view data in relation to a table in a range of ways. A drop-down list of views is frequently displayed in the application so these can be selected.
Personal views are included above the list of system or public views that are available in the app. This makes it easier for users to find the data that is important to them.
The records that are visible in views are displayed in a list. Views frequently provide options for users to change the default sorting, column widths, and filters to more easily find the data that's important to them.
Views aren't only used by users within model-driven apps. Views can also be used to define the data source in, for example, charts that are used in the application.
Personal views can be created by following these steps:
Note
While you can create a new personal view based on a system or public view, you can't create a system or public view based on a personal view.
Personal views can be created by users who have at least User level access to actions for the Saved View table.
As system administrator, you can modify the access level for each action in the security role to control the depth to which people can create, read, write, delete, assign, or share personal views.
System views | Description |
---|---|
Quick Find | The default view used when searches are performed using Quick Find. This view also defines which columns are searched when using search capabilities of Quick Find and Lookup column views. |
Advanced Find | The default view used to display results when using Advanced Find. This view also defines the columns used by default when new custom public views or personal views are created without defining a view to use as a template. |
Associated | The default view that lists the related tables for a record. |
Lookup | The view that is displayed when you select a record to set for a Lookup column. |
System views aren't shown in the view selector and you can't use them in sublists in a form or as a list in a dashboard. You can't delete or deactivate these views. However, Power Platform admins can control whether system views are available or not to users with security roles. More information: Manage access to public system views (preview)
For information about removing views, go to Remove views.
System views are owned by the organization so that everyone can view them. For example, everyone has organization-level access to read records for the view (savedquery
) table. These views are associated with specific tables and are visible within the Solutions area in Power Apps (make.powerapps.com). You can include these views in solutions because they're associated with the table.
Note
System views are cached for performance optimization purposes and therefore plug-ins on the savedquery
table aren't supported.
Some public views exist by default for system tables and for any custom table. For example, when you create a new custom table, it has the following combination of public and system views.
Name | Type |
---|---|
Active table plural name | Public |
Inactive table plural name | Public |
Quick Find Active table plural name | Quick Find |
Table name Advanced Find View | Advanced Find |
Table name Associated View | Associated |
Table name Lookup View | Lookup |
You can create custom public views. You can delete any custom public views you create in an unmanaged solution.
You can't delete any system-defined public views.
Custom public views added by a managed solution should only be deleted by uninstalling or updating the managed solution.
As a system customizer you can customize views and subgrids through controls by making them read-only or editable as well as display an alphabetic list at the bottom of views or subgrids (jump bar).
The following controls are available:
Grid control name | Read-only or editable? | Description |
---|---|---|
Power Apps grid control | Read-only or editable | This grid control includes accessibility enhancements and will become the default grid control used in views and subgrids. This control will eventually replace all other grid controls. More information: Power Apps grid control |
Power Apps read-only grid | Read-only | Modern grid with accessibility enhancements released in October 2021 and became the default read-only grid experience in April 2022. More information: Power Apps read-only grid control |
Editable grid | Editable only | Legacy grid control. More information: Make model-driven app views editable using the editable grid control |
Read-only grid (deprecated) | Read-only | Legacy grid control that is deprecated. More information: The legacy read-only grid in model-driven apps is deprecated |
Events
Power BI DataViz World Championships
Feb 14, 4 PM - Mar 31, 4 PM
With 4 chances to enter, you could win a conference package and make it to the LIVE Grand Finale in Las Vegas
Learn moreTraining
Module
Customize views and forms for model-driven apps - Training
Discover the differences between views and forms, and learn how to modify table views and forms effectively.
Certification
Microsoft Certified: Power Platform Developer Associate - Certifications
Demonstrate how to simplify, automate, and transform business tasks and processes using Microsoft Power Platform Developer.