Custom multi-table lookups can now include virtual tables


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 - Nov 25, 2022

Business value

Users can now use virtual tables as part of their multi-table lookups. This opens up the ability to have greater access to their virtual data including the Azure Active Directory (Azure AD) User virtual table.

Feature details

Multi-table lookups are lookups that retrieve data from multiple tables at once. A commonly used out-of-the-box example is the customer lookup, which retrieves data from the account and contact tables. Users can create multi-table lookups themselves using the SDK or API, and in the future, they'll be able to do this using as well.

Now, when creating custom multi-table lookups, users can select from any local table and any virtual table. In order to participate in a custom multi-table lookup, the selected tables or virtual tables must not already be part of an existing multi-table lookup. For details on how to create these, go to Multi-table lookups.

See also

Defining relationships in virtual tables (docs)