Unanswered

Many-to-many relationships are NOT reciprocal?

(0) Share

Report

Posted on by minibix

Hi - I'm creating a many-to-many relationship in a custom model driven PowerApp, specifically Account <-> Account.

I have added subgrid in form on the Account entity, but when I make a relationship from Account A to another Account B via the subgrid view button 'Add Existing Account' it only shows up in the subgrid view on the Account A, where I created the relationship originally. When I then navigate to the other Account B, it does not show up.

I can then do the same in reverse from Account B to make it show up, but it feels like I'm creating 2 separate one-way relationships.

The documentation mentions many-to-many relationships are 'reciprocal' - I assumed that this behaviour is not reciprocal as I need it to be?

https://docs.microsoft.com/en-gb/powerapps/maker/common-data-service/create-edit-nn-relationships

Am I missing something?

Categories:

Building Power Apps

All responses (2)

Answers (0)

Sort by

Ralph Soto 4 on at

Like
a
(0)

Report
Copy link

Link copied!

I am encountering the same issue. How is it reciprocal if it does not show up on both grids on the form?
Ralph Soto 4 on at

Like
a
(0)

Report
Copy link

Link copied!

So in order to get the relationship to appear on both sides, I created a plugin on the associate and dissassociate event. From there I referenced the target and related entity records. I am checking the relationship name returned with ".Referencing" then making the reciprocal relationship using ".Referenced" and flipping the entity in the association and disassociation.

Here is the code

private static void ReciprocalRelationship(IOrganizationService service, IPluginExecutionContext context,
EntityReference targetEntity, EntityReference relatedEntity, string relationshipName, string tableName)
{
if (targetEntity.LogicalName == contact.LogicalName &&
relationshipName == tableName + ".Referencing")
{
var relationship = new Relationship()
{
PrimaryEntityRole = EntityRole.Referenced,
SchemaName = tableName
};
if (context.MessageName == MessageNames.Associate)
service.Associate(targetEntity.LogicalName, targetEntity.Id, relationship,
new EntityReferenceCollection { relatedEntity });
else if (context.MessageName == MessageNames.Disassociate)
service.Disassociate(targetEntity.LogicalName, targetEntity.Id, relationship,
new EntityReferenceCollection { relatedEntity });
}
}