Create Many-to-many entity relationships in Common Data Service using PowerApps portal
The PowerApps portal provides an easy way to create and edit Many-to-many entity 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 N:N (many-to-many) entity relationships
- Create N:N (many-to-many) entity relationships in Common Data Service using solution explorer
View Many-to-many entity relationships
- From the PowerApps 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|
Many-to-many relationships will have a Relationship type of Many-to-many.
The entity you view may have no Many-to-many relationships.
While viewing entity relationships, in the command bar, select Add relationship and choose Many-to-many.
In the Many-to-many panel, choose the entity you want related to the current entity.
Select More Options to view the Relationship Name and Relationship entity name fields.
The values for these fields are generated for you based on the entities chosen.
If you create more than one Many-to-many relationship with the same two entities, you will need to edit the generated Relationship Name and Relationship entity name fields so that they will be unique.
Select OK to close the Many-to-many panel. The relationship will be created when you save changes to the entity.
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 select the ellipses (...).
Deleting the Many-to-Many relationship will delete the relationship entity created. All data connecting entities using the relationship will be lost.