CRM Crate

What are complex tables in Power Apps / Dynamics 365?

We will understand the concept & usage of complex tables in Power Apps / Dynamics 365. Before we start, make sure to subscribe to CRM Crate so that you can stay up to date in the field of Power Apps / Dynamics 365.

What are complex tables in Power Apps / Dynamics 365?

Understanding Complex Tables in Power Platform

The complex tables are the dataverse tables or entities that include the following complex server-side logic require users of an app or flow that uses these tables to have a Power Apps Plan 2 or Power Automate Plan 2 license:

Real-time workflows

Workflows automate business processes without a user interface. They are usually used to initiate an automation that doesn’t require any user interaction. The real-time workflows are synchronous in nature and are executed in real-time.
Click here to learn more about workflows.

Code plug-ins

plug-in is a requirement specific custom event handler that executes in response to a specific event raised during processing of a Microsoft Dataverse data operation within the dataverse. The plug-in is implemented as a custom class compiled into a .NET Framework assembly that can be uploaded and registered with Dataverse. One or more compiled plug-in classes within an assembly can be registered on specific events (steps) within the Dataverse event framework.
Click here to learn more about Code plug-ins.

Licensing for complex tables

The complex tables are applicable only  for the legacy Power Apps Plan 1 and Plan 2 licenses, and not for the latest Power Apps per app and Power Apps per user plans.

The following table lists tables that contain complex server-side logic out-of-the-box as part of the installation of customer engagement apps in Dynamics 365 (Dynamics 365 Sales, Customer Service, Field Service, Marketing, and Project Service Automation).

  • Account
  • Agreement
  • Agreement Booking Date
  • Agreement Booking Incident
  • Agreement Booking Product
  • Agreement Booking Service
  • Agreement Booking Service Task
  • Agreement Booking Setup
  • Agreement Invoice Date
  • Agreement Invoice Product
  • Agreement Invoice Setup
  • Agreement Sub-Status
  • Bookable Resource
  • Bookable Resource Booking
  • Bookable Resource Booking Header
  • Bookable Resource Category
  • Bookable Resource Category Assn
  • Bookable Resource Characteristic
  • Bookable Resource Group
  • Booking Alert
  • Booking Alert Status
  • Booking Status
  • Characteristic
  • Competency Requirement (Deprecated)
  • Competitor
  • Contact
  • Customer Asset
  • Delegation
  • Expense
  • Field Computation
  • Field Service Price List Item
  • Filter
  • Follow
  • Incident Type
  • Incident Type Product
  • Incident Type Service
  • Incident Type Service Task
  • Integration Job
  • Integration Job Detail
  • Inventory Adjustment
  • Inventory Adjustment Product
  • Inventory Transfer
  • Invoice
  • Invoice Frequency
  • Invoice Line
  • Invoice Line Detail
  • Journal
  • Journal Line
  • Lead
  • Note
  • OData v4 Data Source
  • Opportunity
  • Opportunity Line
  • Opportunity Line Detail
  • Order
  • Order Invoicing Product
  • Order Invoicing Setup
  • Order Line
  • Payment
  • Payment Detail
  • Post Configuration
  • Post Rule Configuration
  • Postal Code
  • Price List
  • Price List Item
  • Product
  • Project
  • Project Approval
  • Project Contract Line Detail
  • Project Contract Line Milestone
  • Project Contract Line Resource Category
  • Project Contract Line Transaction Category
  • Project Parameter
  • Project Stages
  • Project Task Status User
  • Project Team Member Sign-Up
  • Purchase Order
  • Purchase Order Bill
  • Purchase Order Product
  • Purchase Order Receipt
  • Purchase Order Receipt Product
  • Purchase Order Sub Status
  • Queue Item
  • Quote
  • Quote Booking Incident
  • Quote Booking Product
  • Quote Booking Service
  • Quote Booking Service Task
  • Quote Booking Setup
  • Quote Invoicing Product
  • Quote Invoicing Setup
  • Quote Line
  • Quote Line Detail
  • Quote Line Milestone
  • Quote Line Resource Category
  • Quote Line Transaction Category
  • Quote Project Price List
  • Rating Model
  • Rating Value
  • Requirement Characteristic
  • Requirement Resource Category
  • Requirement Resource Preference
  • Requirement Status
  • Resource Request
  • Resource Requirement
  • Resource Requirement Detail
  • RMA
  • RMA Product
  • RMA Receipt
  • RMA Receipt Product
  • RMA Sub-Status
  • Role competency requirement
  • Role Price
  • RTV
  • RTV Product
  • RTV Sub-Status
  • Tax Code
  • Tax Code Detail
  • Time Entry
  • Time Group
  • Time Group Detail
  • Time Off Request
  • Transaction Category Price
  • User
  • View
  • Wall View
  • Warehouse
  • Work Order
  • Work Order Incident
  • Work Order Product
  • Work Order Service
  • Work Order Service Task
  • Work Order Sub-Status
  • Work template

Thus, we learned the usage & concept of complex tables in Power Apps / Dynamics 365.

0 0 votes
Article Rating
Notify of
Newest Most Voted
Inline Feedbacks
View all comments
How to restrict users from sharing Canvas Apps? - CRM Crate
4 months ago

[…] Power Apps employs low-code, a software development approach that empowers users to create apps by dragging and dropping components into a flowchart-style layout. Users of PowerApps have the flexibility to create either canvas applications or model-driven applications within the program. Canvas apps are precisely as they imply: PowerApps offers a blank canvas where users can drag and drop components freely to create a user interface in any desired arrangement. […]

Advantages & disadvantages of using Virtual Tables in Power Apps - CRM Crate
3 months ago

[…] and efficient way to access and utilize information from diverse sources directly within the Power Apps interface, enhancing the platform’s capabilities for building robust and interconnected […]

Create a Virtual Table in Power Apps using OData v4 Data Provider [Complete Guide] - CRM Crate
6 days ago

[…] and efficient way to access and utilize information from diverse sources directly within the Power Apps interface, enhancing the platform’s capabilities for building robust and interconnected […]

error: CRM Crate Security Engine - Disabled Right Click & Selection!


Well Done,
Welcome to CRM Crate

Stay tuned with us and get all latest updates and learning in Microsoft CRM and related techonologes.