I'm not particularly eager to rely on Dataverse's OOTB Many-to-Many (N:N) relationship due to its limitations and, in most cases, do opt for custom association (joint) tables. Yes, it is a bit of extra work; however, with a custom table, it is possible to get full control over that many …...
Digitally transforming organizations with Microsoft Power Platform and Azure