Introduction

Completed

You can add table lists to webpages by using Microsoft Power Apps portals Studio, where you can configure some of the main properties. Additional configuration options are available by using the Portal Management app.

Configure the table list

Portals Studio provides a basic interface for creating and configuring table lists; however not everything can be configured in portals Studio. Makers can customize all table list features and properties by using the Portal Management app. To access table lists in the Portal Management app, use the following procedure:

  1. Go to the Power Apps maker portal.
  2. In the upper-right corner, use the environment selector to select the target environment.
  3. From the Apps list, locate and open the Portal Management app. (The app type is Model-driven.)
  4. In the left navigation, select Table Lists.
  5. Open the list that was previously created in portals Studio.

Screenshot of the New table list in Portal Management.

A table list can be as simple or as complicated as your business requirements specify. To begin, the only required properties for the table list, other than the name and the website, are the target Table Name and one or more Views.

table lists are highly configurable and have several settings that define the list behavior. Lists can also include actions for the user to interact with the items on the list.

Diagram of table list structure and overview.

The following sections describe some of the most common features and settings.

Note

Most of the options that add interactive elements, such as buttons, support customization of the elements in multiple languages. For example, if multiple views are enabled, the name for each of the views in the view selector can be customized for each of the enabled portal languages.

Views

Selected views define the Microsoft Dataverse table columns, list layout, and the default sort order.

  • Multiple views - If more than one view is specified, a drop-down list renders to allow the user to switch between the views.

  • Sorting and pagination - Sorting is enabled on any of the displayed columns and the page size is configurable.

Screenshot of the Entitlement Contacts view and features.

Note

Table lists include the Web Page for Details View and Web Page for Create general properties. These properties are for backward compatibility only. The functionality is included as part of the View Actions and Item Actions grid configuration.

Configuration

You can configure table list data by using filtering and searching or by selecting various display options.

Filtering and searching

Filtering and searching functionalities help you configure the data in the following ways:

  • Search - When Quick Search is enabled, the portal renders a text search box. It is similar to the Quick Search feature in model-driven apps. Quick Search runs across the view columns and lets users locate information within larger lists by using plain text input. Portal users can enter the asterisk wildcard character to search on partial text.

  • Portal filters - List data can be filtered by the current portal user, the current portal user's parent account, and the current portal website. This feature enables some common scenarios by using configuration only, without the need for additional development:

    • List of product reviews that are left by the current user.
    • List of the buildings on the campus for the department (account) of the current user.
    • List of all draft pages for the current website, only when multiple portals are provisioned.

If both the current portal user and current portal user's parent account filters are enabled, the portal renders a drop-down menu, which allows the user to view their own data (My) or their parent account's data (account name is displayed).

  • Metadata filters - This feature is also configuration-only. Records in the list can be filtered on any of the list columns, including ranges, lookups, optionsets, and custom FetchXml expressions. Portal users have access to the interactive filtering panel when the table list is rendered.

Screenshot of the table list search and filtering features.

Display options

Views can render as traditional grid lists, calendars, or maps. Delivering list content as an OData feed is also supported.

Screenshot of the table list rendered as a map and calendar.

Alternative views might require additional configuration such as start and end date columns for a calendar, or latitude and longitude columns for a map.

Important

Maps and calendars require page templates that can render the view. When a starter portal is provisioned, Rewrite page templates like Page or Full Page support this functionality. Pages that use web templates will render the default table list view.

Actions

Table lists can have actions associated with them to enable commands for each list, such as Create and Download (as a Microsoft Excel spreadsheet), or commands for each record, such as View or Edit, and to trigger workflows.

Screenshot of the table list features and commands.

For more detailed information about table list attributes and relationships and how to use them to configure list behavior, see About table lists.