Dynamics 365 change tracking many to many relationship

795 views Asked by At

Has anyone tried using change tracking for many to many relationships? Since change tracking is enabled at the entity level, I'm not sure how to set it up (if it's possible). I'm using some m:m relationships in the portal and would like the data to be properly reflected.

2

There are 2 answers

0
Arun Vinoth-Precog Tech - MVP On

Unfortunately, like you said, change tracking has to be enabled in entity level and Native many to many relationship created intersect entity is not exposed to customize. So no way to do that.

If it’s Manual many to many relationship (1:N from either side) then you get an intersect entity to enable change tracking.

Edit:

Noticed that the native N:N relationship also creates a table in database (which is not visible anywhere) & getting synced using Data Export Service without need to enable “change tracking”.

1
Alessandro Marchesin On

I experimented on my local environment.

I noticed that the tracking is enabled in the in-between entity only if both entities at the extremes of the relationship have tracking active too.