Multi-table lookups

Important

This content is archived and is not being updated. For the latest documentation, go to What is Microsoft Dataverse?. For the latest release plans, go to Dynamics 365 and Microsoft Power Platform release plans.

Enabled for Public preview General availability
Users, automatically Apr 30, 2021 Sep 17, 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.

See also

Multi-table Lookups (docs)