Connect Flow & Dynamics Business Central

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.

2 thoughts on “Connect Flow & Dynamics Business Central

  1. Pekka Niva

    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.

    1. renato Post author

      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.

Leave a Reply

Your email address will not be published. Required fields are marked *