Create virtual table to native table relationships
Important
This content is archived and is not being updated. For the latest documentation, go to Microsoft Dataverse documentation. 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 makers to build applications through lookups and filtering using the power of virtual tables. This allows makers to build complex multi-table applications where virtual table to native table relationships can be defined.
Feature details
In this feature, we're enabling the virtual table to native table relationships. The following capabilities will be enabled.
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