Create or edit views of data in a table

Completed

With Power Apps maker portal, it's easy to modify and create views with your table data. Follow these steps to create and save views of data in a table:

  1. If you're not already there, go ahead and sign in to the Power Apps maker portal.

  2. On the left pane, select Tables. Select the table that is associated with the data that you want to view. You'll see the Tables editor screen with the five panes. Look for the Data experiences pane.

  3. Within the Data experiences pane, select Views.

    View of the Tables editor screen with Views selected under the Data experiences pane.

  4. Selecting Views opens a list of views of data associated with your table. You can open an existing view or create a new view.

Open existing views

To open an existing view, from your list of current views, select the name of the view that you want to see, and the View editor will open.

Screen showing the View edit screen with fields highlighted in the Sort by and Filter by in the properties pane.

On the left side of the View editor notice a list of available table columns that can be added into the view. They can be added simply by selecting the table column or by dragging and dropping into your view preview pane in the center of the screen. You can move columns by dragging and dropping them in the proper location in the header.

Notice the properties pane on the right side of the screen that shows the Name of the view, includes an optional Description, and it includes options for sorting the view in the Sort by dropdown (notice that you can sort by multiple columns by selecting the Then sort by button to choose another column). You can also choose to filter your view by selecting options available in the Filter by field, and the Edit filters option below.

Don't forget to save any changes you made to your view by selecting the Save and publish button in the top right of the command bar. Publishing makes this view consumable by other table users.

Finally, if you decide that there's not a table column that you need for this view you can select the + New table column button just below the Search field in the Table columns pane.

Create a new view

If you want to create a new view altogether (rather than to modify an existing view), follow these steps:

  1. Return to the table you wish to create a view in.

  2. In the Data experiences pane select Views.

  3. Power Apps navigates you to a screen showing the available Views. In the command bar, at the top select + New view. A pop out window for Create a view will appear in the middle of the screen.

  4. Enter a Name and Description for the view and select the Create button.

  5. Drag and drop columns into your view, reorder by dragging and dropping into the view header, and select any desired sort and filtering options. Select Save and publish in the top right of the screen when you're ready to make that view available for your table.

You've now experienced how easy it's to modify an existing table view or create your own by using the Power Apps maker portal.