Create and edit One-to-many or Many-to-one entity 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 Common Data Service.

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

View entity relationships

  1. From the Power Apps portal, select either Model-driven or Canvas design mode.
  2. Select Data > Entities and select the entity that has the relationships you want to view.
  3. With the Relationships tab selected, you can select the following views:
View Description
All Shows all the relationships for the entity
Custom Shows only custom relationships for the entity
Default Shows only the standard relationships for the entity

Account entity relationships

Create relationships

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

Select type of relationship

Note

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

Important

The portal uses different terminology than solution explorer. The solution explorer Primary entity is the Current entity 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 entity for the relationship you want to create between the two entities.

Note

With either choice, a lookup field will be created on the current entity.

Once you select the entity you can edit the details of the relationship. In this example, multiple contact entity records 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 field description values

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

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

Edit relationships

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

Note

Each relationship can be found within the primary entity or the related entity 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 fields you can edit are Lookup field display name and Lookup field description. These can also be edited in the properties of the lookup field in the related entity. More information: Edit a field

Delete relationships

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

Delete entity 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 field on the related entity.

Note

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

See also

Create and edit relationships between entities
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) entity relationships using solution explorer
Edit a field