How to Create a Dataverse View (Columns, Related Tables, Filters and Sort)

If you need your team to see only the open, high-priority service requests, create a Dataverse view with the right columns, filters and sort. A view is a saved query on a table.

People get stuck because the designer has two Status columns, related columns hide on a separate tab, and nothing reaches the app until you publish.

In this tutorial, we’ll create a Dataverse view step by step, pull in a column from a second table, filter and sort it, and then use the same view in a model-driven app and a canvas app.

The Sample Table We’ll Use

Everything runs on one table in my Power Platform developer environment: Service Request (plural Service Requests), with 11 rows. New to tables? Start with what Microsoft Dataverse is, or create a Dataverse table of your own first.

Column	Type	Sample values
Subject	Text (primary column)	Password Reset, Network Issue
Request Number	Text	REQ-1003, REQ-1006
Status	Choice (custom)	Open, In Progress, Closed
Priority	Choice	Low, Medium, High
Due Date	Date	10/26/2026, 10/28/2026
Customer	Lookup to Customer	Amy, Bob, Cleo, Dan, Eve

Method 1: Create a Public View in the View Designer (Recommended)

Use this when every app user should get the same list:

1. Go to make.powerapps.com and pick your environment.
2. Select Tables, open the table, and under Data experiences select Views.
3. Select + New view.

In the Create a view dialog, I named it Open High Priority Requests, unchecked Get AI-generated column suggestions (on by default) and selected Create.

The designer opens with only Subject. In the Table columns pane, I clicked Request Number, Status, Priority and Due Date to add them.

How does this work?

Here’s the catch: there are two Status columns, our custom choice (Open, In Progress, Closed) and the system Status (Active, Inactive). Hover to see the logical name, cr85a_status. Our Dataverse choice column guide explains the custom one.

Then select Save and publish. The old Switch to classic option is gone.

Method 2: Add Columns from a Related Table

This answers the “view from two tables” question. A view sits on one table, but it can show columns from any table linked by a lookup.

Switch the Table columns pane to the Related tab, which lists every lookup. I expanded Customer (Customer) and selected Customer Name.

How does this work?

The grid gets Customer Name (Customer), filled with Amy, Dan, Cleo, Bob and Eve. That’s one reason Dataverse beats a SharePoint list for related data.

No lookup between the tables? Add one first.

Method 3: Filter and Sort the View

In the right pane, select Edit filters. It starts with an And group; + Add offers Add row, Add group and Add related table.

1. Row 1: Status Equals In Progress, Open.
2. Row 2: Priority Equals High.
3. Select Ok.

Then select Sort by > Due Date (ascending). Then sort by adds a second sort.

The preview drops to 2 rows: Password Reset (due 10/26/2026) and Network Issue (due 10/28/2026).

How does this work?

In an And group, a row must pass every condition. A multi-value Equals matches any listed value, so Status can be Open or In Progress.

To edit a filter, select it in the right pane; closing it removes it without a prompt. For more, see filtering Dataverse Yes/No and choice columns.

Pro Tip: For a related-table condition, use Add related table. Its only operator is Contains data.

Method 4: Use the View in a Model-Driven App

A published public view shows up in any model-driven app that includes the table. In my SPGuides Service Request App, it showed chips Status: In Progress, Open and Priority: High, with Rows: 2.

The view selector switches views. Personal views show a person icon.

Users make personal views in the app: change the grid, then pick Save as new view. They stay private until shared through Manage and share views.

Set as default view makes the current view your default.

Method 5: Use the View in a Canvas App

Skip rebuilding the filter in Power Fx. In my Service Request Choices Demo app, I set gallery galView’s Items to:

Filter('Service Requests', 'Service Requests (Views)'.'Open High Priority Requests')

A label counts the rows:

CountRows(galView.AllItems) & " requests in the view"

It showed “2 requests in the view”, with no delegation warning.

How does this work?

Passing 'Service Requests (Views)'.'Open High Priority Requests' to Filter applies the view’s saved filter, so the gallery matches the designer preview.

The Views dropdown in the gallery’s Properties pane writes the same formula. See get data from Dataverse in Power Apps, and our Power Apps delegation guide covers big tables.

Dataverse View Types on the Views Page

Every custom table starts with these view types:

Type	What it’s for	Can you delete it?
Public	View selector, subgrids, dashboards	Custom ones, yes
Quick Find	Columns searched by quick find	No
Advanced Find	Advanced Find results	No
Associated	Related rows on a form	No
Lookup	Picking a lookup value	No
Personal	A user’s own view	Yes, by the owner

Edit, Turn Off or Delete a View

To edit, open the view, change it and select Save and publish. To hide a custom public view, select it and choose Turn off.

To delete, select Remove > Delete from this environment. That’s permanent, and it works only on custom public views in an unmanaged solution.

Which Method Should You Use?

You want to…	Use
Give every app user the same list	Method 1, public view
Show a column from a lookup table	Method 2, Related tab
Limit and order rows	Method 3, Edit filters + Sort by
Let users save their own list	Method 4, personal view
Reuse the filter in a canvas app	Method 5, the (Views) enum

Things to Keep in Mind

• Two Status columns: filter on your custom choice, not the system Active/Inactive one.
• Save isn’t enough: users only see changes after Save and publish.
• A view used in an app must be removed from the app before you can delete it.
• You can’t turn off the table’s default public view; make another one the default first.

More Power Apps builds are on our Power Apps tutorials hub.

If you’re working through Dataverse, these are good next reads:

• 51 Dataverse Interview Questions and Answers (With Scenarios)
• How to Add Data to a Dataverse Table in Power Apps (Form, Import, Patch and Collect)
• Dataverse Formula Column: How to Create One, If Examples, Errors and Limits
• Dataverse Version History: Turn On Auditing and View Row Changes

Frequently Asked Questions