This post is part of the New Functionality In Microsoft Dynamics 365 Business Central 2023 Wave 2 series in which I am taking a look at the new functionality introduced in Microsoft Dynamics 365 Business Central 2023 Wave 2.
The eleventh of the new functionality in the Adapt faster with Power Platform section is Business Central virtual tables fully supported on Microsoft Dataverse.
Business Central virtual tables allow for inbound interactions from apps, flows, and pages running on Microsoft Dataverse to perform create, read, update, and delete (CRUD) operations on Business Central physical tables without the need to replicate data into Dataverse.
Enabled for: Users by admins, makers, or analysts
Public Preview: –
General Availability: Nov 2023
Feature Details
With Business Central virtual tables, your apps, flows, and pages built using Power Apps, Power Automate, and Power Pages on Power Platform can easily interact with Business Central physical tables. Synthetic relations can be created between native Dataverse tables and Business Central virtual tables, allowing related data to be presented together on Power Apps and Power Pages.
Additionally, changes made to Business Central physical tables can trigger outbound interactions from Business Central into Dataverse by emitting create, update, and delete (CUD) events that start Power Automate flows with the When a row is added, modified, or deleted trigger set to the corresponding Business Central virtual tables.