Create and edit One-to-many or Many-to-one table relationships using Power Apps portal

The Power Apps portal provides an easy way to create and edit 1:N (one-to-many) or N:1 (many-to-one) relationships for Microsoft Dataverse.

The portal enables configuring the most common options, but certain options can only be set using solution explorer. More information:

View table relationships

  1. From the Power Apps portal, select either Model-driven or Canvas design mode.
  2. Select Tables and select the table that has the relationships you want to view. If the item isn’t in the left navigation pane, select …More and then select the item you want.
  3. With the Relationships area selected, you can select the following views:
View Description
All Shows all the relationships for the table
Custom Shows only custom relationships for the table
Default Shows only the standard relationships for the table

Account table relationships.

Create relationships

While viewing table relationships, in the command bar, select Add relationship and choose either Many-to-one or One-to-many.

Select type of relationship.


For information about Many-to-many relationships see Create N:N (many-to-many) relationships


The portal uses different terminology than solution explorer. The solution explorer Primary table is the Current table in the portal.

Depending on your choice you will see either:

Type Panel
Many-to-one Many to one relationship panel
One-to-many One to many relationship panel

Choose the Related table for the relationship you want to create between the two tables.


With either choice, a lookup column will be created on the current table.

Once you select the table you can edit the details of the relationship. In this example, multiple contact table rows can be associated with a single account.

One to many relationship account and contact

You can edit the default values provided before you save. Select More options to view the Relationship name and Lookup column description values

Field Description
Lookup column display name The localizable text for the lookup column that will be created on the related table.
This can be edited later.
Lookup column name The name for the Lookup column that will be created on the related table.
Relationship name The name for the relationship that will be created.
Lookup column description The description for the lookup column. In model-driven apps this will appear as a tooltip when people hover their mouse over the column.
This can be edited later.

You can continue editing the table. Select Save table to create the relationship you have configured.

Edit relationships

While viewing table relationships, select the relationship you want to edit.


Each relationship can be found within the primary table or the related table as a Many-to-one or One-to-many relationship. Although it can be edited in either place, it is the same relationship.

The publisher of a managed solution can prevent some customizations of relationships that are part of their solution.

The only columns you can edit are Lookup column display name and Lookup column description. These can also be edited in the properties of the lookup column in the related table. More information: Edit a column

Delete relationships

While viewing table relationships, select the relationship you want to delete.

Delete table relationship.

You can use the Delete relationship command from the command bar or from the row context menu when you click the ellipses (...).

Deleting the relationship will delete the lookup column on the related table.


You will not be able to delete a relationship that has dependencies. For example, if you have added the lookup column to a form for the related table, you must remove the column from the form before you delete the relationship.

See also

Create and edit relationships between tables
Create and edit 1:N (one-to-many) or N:1 (many-to-one) relationships
Create and edit 1:N (one-to-many) or N:1 (many-to-one) table relationships using solution explorer
Edit a column