Add a many-to-many relationship subgrid to a form

Dustin Miner

This post provides screenshots showing how to add a many-to-many (N:N) subgrid to a Dynamics 365 form (Figure 1). In this example, many person records will be associated to many document records

Figure 1

Setup

1.) Create the many to many relationship (Figure 2). This will also create a relationship (intersect) table (Figure 4)

Figure 2

2.) Add the subgrid to the form

Note: Name = Subgrid_Documents_Contact_DocumentUpload

Figure 3

Appendix

Figure 4 – intersect entity records
Figure 5 – the form’s xml

Further reading

Multiselect lookup control

References

https://learn.microsoft.com/en-us/power-apps/maker/data-platform/create-edit-nn-relationships

Post Views: 243

Related Posts