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:
- 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.
View entity relationships
- From the Power Apps portal, select either Model-driven or Canvas design mode.
- Select Data > Entities and select the entity that has the relationships you want to view.
- With the Relationships tab selected, you can select the following views:
|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|
While viewing entity relationships, in the command bar, select Add relationship and choose either Many-to-one or One-to-many.
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 entity is the Current entity in the portal.
Depending on your choice you will see either:
Choose the Related entity for the relationship you want to create between the two entities.
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.
You can edit the default values provided before you save. Select More options to view the Relationship name and Lookup field description values
|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.
While viewing entity relationships, select the relationship you want to edit.
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
While viewing entity relationships, select the relationship you want to delete.
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.
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.
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