Hi,
in this blog post, I will describe how to connect Microsoft Flow and Business Central.
In one of my previous blog post, I describe how to connect Dynamics NAV and Microsoft Flow via connector for PowerApps and Flow.
First, we will navigate to search bar in Dynamics Business Central and search for manage flow
In the new window, Flow will open.
Here we have possibilities to see flow entries which occur after events, open Microsoft Flow web page, select environment in which we want to work, or setup and see Connection Information.
If I click on Select Environment I can see for which environment I have possibilities to create flow.
When I return back to Manage Flows and click on Connection information I can see information about connection between Dynamics Business Central and Flow.
If you don’t see Web Service Access Key in the window that means that for the user who is specified in User Name you have not created the Web service access key for user Marin. To do that go to search bar and find users page. Then select and open user and click on Change web service key.
The new pop-up will open where you can specify if you want to set an expiration date for the key or specify that key does not expire.
After that, web service access key will be shown in Connection Information page and we are ready to use flow.
Another way to connect Dynamics Business Central and Flow is to navigate to https://flow.microsoft.com and sign in with our Dynamics 365 account.
Then go to gear icon in upper right corner and click on Connections.
In a few seconds, you will see the window like on the picture below
and you need to click on Create a connection button. New window will open where I will search for Dynamics and choose Microsoft Dynamics 365 Business Central connector
New pop-up will open where you need to click on create
and after that to confirm sign in with Dynamics 365 account.
Now you can start using Flow with some of the predefined templates
or by creating new flow from the available triggers and actions.
In my next blog post, I will write more detail about available templates and how to use them in your businesses.
Br,
Renato.
Tags: Dynamics 365 Business Central Flow
Hi Renato, I tried to make it happen so:
I have a sharepoint list where I write rows containing planning line information like type budget, item 1000, 1 pcs, 800 euros.
I´d like to have a flow to transfer planning lines to a specific job and to a specific job task no in Business Central. I have those values in my rows. How to make that happen? I have succeed to create new customers like you show earlier, but this is more complicated. I think the problem is that you cannot set plenty of item key values, like here job no & job task no & line no (from no series automatically) and use them all when creating new record into table 1003 Job Planning Line.
Hi Pekka Niva,
did you try with adding this multiple key (which is limitation for now in Flow) in that table in SharePoint and then with flow transfer them to Business Central?
Br,
Renato.
Hello Renato
Do you have information how to add own triggers (or extend list of available tables to existing trigger On record create/modify) to BC so they appear as available in list?
Hi,
you can create custom API pages in Business Central to connect to other functionalities.
Br,
Renato.