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.
My Opinion
Not an area I’ve done anything with, but like a number of the other changes in the Adapt faster with Power Platform area of new features, I can see that this could be useful.
New Functionality In Microsoft Dynamics 365 Business Central 2023 Wave 2
What should we write about next?
If there is a topic which fits the typical ones of this site, which you would like to see me write about, please use the form, below, to submit your idea.