Tutorial: Add a list to your page

In this tutorial, you'll learn how to display a list business information to your users from Microsoft Dataverse on a page in your site.

First, you'll need to create a table (or choose an existing table) in Dataverse to store your business information. You'll also need to configure a view from the table that will define the columns and structure for your list. You'll add the list component to a page. For security reasons, your users won't yet be able to view the information until we define table permissions in the following tutorial.

In this tutorial, you learn how to:

  • Create a table
  • Create a view
  • Add a list to the page

Prerequisites

Create a table

This video provides an overview of the steps to create a table.

Use the steps below to create a table.

  1. Go to Power Pages.

  2. Select the Data icon on the left navigation.

    • Select the New table button.

    Create a new table button.

  3. Give the table a name and select Create.

    Create a new table window.

  4. Select New column.

    Add a new column button.

  5. Enter a name and a data type, then choose Save.

    New column settings.

  6. Select the space under the name field and enter your data.

    Enter text for column.

Note

You can use the tab key to move to the next column and enter additional data. You can also use the tab key to navigate to the next row and add additional records.

For more information, see How to create and modify Dataverse tables using data workspace.

Create a view

This video provides an overview of the steps to create a view.

Use the steps below to create a custom view for the table you created.

  1. Select the table you created in the steps above.

    • Select Views and choose New view.

    The new view.

    • Enter a name for the view.

    Enter a name for the view.

  2. Add the application data and status reason columns to the view.

  3. Select Save and choose Publish.

  4. Select Views to show the available views for the table.

For more information, see Create and modify Dataverse views using data workspace.

Add a list to the page

This video provides an overview of the steps to add a list to the page.

Use the steps below to add a list to a web page so you can view information stored in Dataverse.

  1. Inside the design studio, choose the option to Create a new page.

  2. Add a name for the page.

  3. Choose the Start from blank layout.

    • Select Add.
    • Select List.

    Add a list.

  4. Fill in the details.

    • Choose the table and view you'd like from the dropdown menus.

    Fields for add a list window.

  5. Select Preview.

    The preview icon.

    Note

    When you first view the page, you will see a message displayed that you do not have permissions to view the data. Security is very important when building sites.

    A list view without access to data.

For more information, see Add a list.

Next steps

In order for the site users to see data, we need to create table permissions to allow users to view data securely.