How MS Flow can make a friendship with NAV 2017


I think all of you already know what is Microsoft Flow. If not, you can get a quick overview here . 

All of this looks very simple, but if it really so?  

Yes…. but, before you will make simple flows in Microsoft flow service, you should connect your current apps.

In a current blog, I will describe how to connect Dynamics NAV 2017, which works on Azure VM.

NAV Server 

First, we should configure OData tab in NAV Server. 

To work with MS Flow, setups should be:

Enable add in annotationsYes
Enable OData ServicesYes
Enable SSLDepends on client services. If your client is https then OData will be HTTP. Suggest to use No setup
Enable V3 EndpointYes
Enable V4 EndpointYes


  • OData URL should not be a localhost, it should be equal to Azure VM DNS name (see below).
  • Remember OData Port, we should use it later in setup of Azure VM (see below)
  • Don’t forget to run NAV Server 🙂

NAV Setup

Create user

  • User Name will be used in MS Flow Connection User Name field
  • Web Service Access Key. Create this key by click on Assist button. It will be used in MS Flow Connection User Password field

Create Web Service


Here you should add your tables (Object type = Page) to which you will make a connection from MS Flow. 

F. ex. if you want to send notifications to your customers, when sales order will be shipped, you need to publish

  • Sales Order – to check if it was modified
  • Contact – to get e-mail of customer

Don’t forget to publish your web service!

Azure VM


Your virtual machine should have dns name. This is short video how to setup it

Create Inbound security rules

Add inbound security rule for OData Port. Check here how to setup it. 


If you will not open OData port on your VM, your OData services will not be accessed.


You can check how your OData service works by using such services as 

Microsoft Flow Connection

What are MS Flow connections and how to setup them, you can find here .

To connect Dynamics NAV, you should choose it in connections and setup as on next screen.

  • OData feed URL should be equal to NAV Server OData URL
  • Username should be equal to NAV Username 
  • Password should be equal to NAV User Web Service Access Key
  • Company should be equal to NAV Company 


I’ve prepared also video tutorial How to send notifications to customers when sales order is Released.

(Sorry for Russian language in this video, I will translate it later, when find some time)

Update (Jan 18)

If you use NAV on Docker container, then by default URL is secured (https), but certificate is self-signed. So, Flow will not work. You should create new NAV container with parameter -useSSL:$false

See tweeter issue here

Share Post:

Leave a Reply

About Me


A Microsoft MVP, Business Central architect and a project manager, blogger and a speaker, husband and a twice a father. With more than 15 years in business, I went from developer to company owner. Having a great team, still love to put my hands on code and create AI powered Business Central Apps that just works.

Follow Me

Recent Posts