Multi-table lookups

Important

Some of the functionality described in this release plan has not been released. Delivery timelines may change and projected functionality may not be released (see Microsoft policy). Learn more: What's new and planned

Enabled for Public preview General availability
Users, automatically Apr 30, 2021 Sep 2021

Business value

Users will be able to model more complex table relationships by using this new capability. This has been a user/MVP/ISV request for over five years. This capability is also needed by our first party app teams.

Feature details

Multi-table lookup type columns allow a user to employ a specific table that has multiple one-to-many (1:M) relationships to other tables in the environment. A single lookup type column can refer to multiple other tables. A lookup value submitted to the multi-table type column will be matched to a record in any of the related tables.

Multi-table types are currently built into Microsoft Dataverse as static types like Customer, which connects to both Account and Contact. This new feature gives users the power to define any other multi-table lookups they may need.