Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
Important
As of October 2026, this content is archived and no longer maintained. Information on this page may not reflect the latest product plans, features, or guidance. For current roadmap information across Dynamics 365, Power Platform, Dataverse, Microsoft 365, and Copilot, visit the roadmap. Continue to use Microsoft Learn for authoritative product guidance and documentation.
| Enabled for | Public preview | General availability |
|---|---|---|
| Users by admins, makers, or analysts | 
Aug 20, 2024 |
Oct 4, 2024 |
Business value
With this feature, you can build applications that use virtual tables for lookups and filtering. You can create complex applications that use relationships between virtual tables and native tables.
Feature details
This feature supports relationships between virtual tables and native tables. The feature includes the following capabilities:
Simple lookup operations:
- Filters with AND and OR operators, plus all condition operators
- Order by lookup field
- Multiple lookups with CRUD operations, filters, conditions, and ordering
- Paging
Expansion operations with types of join inner and left outer:
- Link without relationship
- Retrieve all attributes
- Order by expanded field and combined clauses
- Filters with AND and OR operators plus all condition operators
- Paging
- Multi-level expand
- One-to-many expand scenarios
Geographic areas
Visit the Explore Feature Geography report for Microsoft Azure areas where this feature is planned or available.
Language availability
Visit the Explore Feature Language report for information on this feature's availability.