Share via

Create virtual table to native table relationships

  • Article

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, Power Platform, and Cloud for Industry release plans.

Enabled for Public preview General availability
Users by admins, makers, or analysts Aug 20, 2024 Oct 4, 2024

Business value

This feature empowers you to build applications through lookups and filtering using the power of virtual tables. This allows you to build complex multi-table applications where virtual table to native table relationships can be defined.

Feature details

In this feature, we're allowing the virtual table to native table relationships. The following capabilities will be available.

Simple lookup CRUD operations:

  • Filters (AND, OR) and conditions (all operators)
  • Order by lookup field
  • Multiple lookups (CRUD, filters, conditions, ordering)
  • Paging

Expansion types of join (inner, left outer, ...):

  • Link without relationship
  • Retrieve all attributes
  • Order by (expanded field, combined clauses)
  • Filters (AND, OR) and conditions (all operators)
  • Paging
  • Multi-level expand
  • One-to-many expand scenarios

Additional resources

Setting up a virtual table relationship (docs)