Share via

Create virtual table to native table relationships

  • Article

Important

Some of the functionality described in this release plan has not been released. Delivery timelines may change and projected functionality may not be released (see Microsoft policy). Learn more: What's new and planned

Enabled for Public preview General availability
Users by admins, makers, or analysts Aug 2024 Aug 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 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