Use Business Central in an Automated Workflow
You can use your Business Central data as part of a workflow in Microsoft Power Automate.
[!NOTE] In addition to Power Automate, you can use the Workflow functionality within Business Central. For more information, see Workflow.
[!NOTE]
You must have a valid account with Business Central and with Power Automate.
Add Business Central as a data source in Power Automate
In your browser, navigate to flow.microsoft.com, and then sign in.
Choose My flows from the ribbon at the top of the page.
There are 3 ways to create a flow; Start from template, Start from blank, and Start from a connector. A template is a predefined flow that has been created for you. To use a template, select it and create a connection for each service the template uses. With the Start from blank and Start from a connector options, you can create a new flow completely from scratch.
To create from blank, on the My flows page, choose the Start from blank and Automated flow options.
Search for Microsoft Dynamics 365 Business Central connector.
Define a name and choose the trigger you want to use for your flow.
From the list of available triggers, select one of the Business Central triggers available:
- When a vendor approval is requested
- When a general journal line approval is requested
- When a record is deleted
- When a record is changed
- When a record is created
- When a record is modified
- When a general journal batch approval is requested
- When a customer approval is requested
- When an item approval is requested
- When a purchase document approval is requested
- When a sales document approval is requested
Power Automate will prompt you to select an environment and company within your Business Central tenant, plus any conditions in your data that you want to listen for.
[!NOTE] The Business Central connector for Power Automate supports multiple production and sandbox environments. If you haven't created multiple production or sandbox environments, Production is the only available option that you can choose.
At this point, you've successfully connected to your Business CentralBusiness Central data and are ready to begin building your flow.
To create from a template, choose the Start from template option.
Search for Microsoft Dynamics 365 Business Central templates.
From the list of available templates, select one of the templates, and then choose Create.
- Request Approval for Microsoft Dynamics 365 Business Central sales order
- Request Approval for Microsoft Dynamics 365 Business Central sales quote
- Request Approval for Microsoft Dynamics 365 Business Central sales invoice
- Request Approval for Microsoft Dynamics 365 Business Central sales credit memo
- Request Approval for Microsoft Dynamics 365 Business Central customer
- Request Approval for Microsoft Dynamics 365 Business Central purchase order
- Request Approval for Microsoft Dynamics 365 Business Central purchase invoice
- Request Approval for Microsoft Dynamics 365 Business Central purchase credit memo
- Request Approval for Microsoft Dynamics 365 Business Central item
- Request Approval for Microsoft Dynamics 365 Business Central vendor
- Request Approval for Microsoft Dynamics 365 Business Central general journal batch
- Request Approval for Microsoft Dynamics 365 Business Central general journal lines
Power Automate will display a list of services used in the flow template and will attempt to connect automatically to those services. If you haven't previously connected to a service, you'll be prompted to sign in to each of the services you need to connect to. A green checkmark will appear next to each service once a connection has been successfully made. Select Continue.
Power Automate will prompt you to select an environment and company within your Business Central Power Automate template.
For more information, see the Power Automate Documentation.
Troubleshooting
"Entity set not found” error
Problem
When creating a new Power Automate Flow using a Business Central approval trigger, like When a purchase document approval is requested, you get an error message similar to:
Entity set not found: <name>
where <name> is the service name of the missing web service, like workflowWebhookSubscriptions or workflowPurchaseDocumentLines.
Possible cause
Using Power Automate to integrate with your Business Central approvals requires that certain page and codeunit objects are published as web services. By default, most of the required objects are published as web services for you. But in some cases, your environment may have been customized so that these objects are no longer published.
Fix
Go to the Web Services page and make sure that the following objects are published as web services. There should be an entry in the list for each object, with the Published check box selected.
| Object Type | Object ID | Object Name | Service Name |
|---|---|---|---|
| Codeunit | 1544 | WorkflowWebhookSubscription | WorkflowActionResponse |
| Page | 6408 | workflowCustomers | workflowCustomers |
| Page | 6406 | workflowGenJournalBatches | workflowGenJournalBatches |
| Page | 6407 | workflowGenJournalLines | workflowGenJournalLines |
| Page | 6409 | workflowItems | workflowItems |
| Page | 6405 | Purchase Document Line Entity | workflowPurchaseDocumentLines |
| Page | 6404 | workflowPurchaseDocuments | workflowPurchaseDocuments |
| Page | 6403 | Sales Document Line Entity | workflowSalesDocumentLines |
| Page | 6402 | workflowSalesDocuments | workflowSalesDocuments |
| Page | 6410 | workflowVendors | workflowVendors |
| Page | 831 | workflowWebhookSubscriptions | workflowWebhookSubscriptions |
[!NOTE] The Service Name value must be exactly as shown in the table. Don't change or translate the service name.
For more information about publishing web services, see Publish a Web Service.
See Also
Getting Ready for Doing Business
Workflow
Importing Business Data from Other Finance Systems
Assign Permissions to Users and Groups
Manage Dynamics 365 Business Central Workflows
Approval User Setup
Setting Up Business Central
Finance
--- author: edupont04