How Do I: use Microsoft Flow with data from Microsoft Dynamics NAV 2017

Plataan and Microsoft has published last week my first “How Do I” video of this year.

In this video I will show you, how Microsoft Flow can use data from Microsoft Dynamics NAV 2017.
Microsoft Flow is a tool where you can make automated workflow between different platforms.
It has a bunch of connectors that can be used with each other and Dynamics NAV is one of them .

When I made this How Do I the Dynamics NAV connector was in “Preview” and only supported data feed from NAV as I have mentioned in a preview post.

With Flow you can use data from one connector to feed another.
So you can start a workflow in Microsoft Flow when a Record is “Created” or “Modified”.

And then use for example send an email, an approval or post a tweet on twitter.
It can all be done without writing any line of code.
So you don’t need to be a developer to use it, even end users can start create workflows of them own.

I wonder where this will end. A lot of ServiceDesk calls? Or more work for consultants?

Later I will make another “How Do I” where I will let Microsoft Flow write data to Dynamics NAV and create records.
See you next time.

2 thoughts on “How Do I: use Microsoft Flow with data from Microsoft Dynamics NAV 2017

  1. Wilbert says:

    Hi Gunter,

    Great blog. I,m currently looking into powerapps to connect to an on premise NAV database.
    I managed to read form the SQL database directly and with a query i can read from an sql table into a manually created entity in CDS. I did not find yet how to update the query from the powerapp. Do you know that maybe?

    I tried to make to connect with the dynamics connector with odata. In your example you use the credentialtype NavUserPassword. i want to connect with windows credentials, do you know if thats possible?

    in the above blog you write:

    Later I will make another “How Do I” where I will let Microsoft Flow write data to Dynamics NAV and create records.

    I write records into a manually created CDS entity and want to write those records to an onpremise nav table. I only can find that REST webservices are supported, no SOAP (codeunit). Do you know what’s possible from powerapps? Or do i have to use Flow? Do you know if there is any documentation or examples?

    Thanks in advance

    1. Punky says:

      Hello Wilbert,

      currently there is no way to update or create records with the current dynamics connector.
      Microsoft is rewriting the connector to enable this feature because they also need it for Business Central.

      Connecting to OData isn’t possible with windows credentials as the Flow and Powerapps are cloud services and you can’t impersonate a windows credential in the cloud.

      I wanted to make the “How Do I” sooner but the technology isn’t ready yet.
      Maybe you have soon both of my “How Do I”‘s. One about Flow and one about Powerapps.
      The connector Microsoft is using, is the same for both. This means that neither with Flow or Powerapps you can write to NAV OData feeds.

      Greetings

Leave a Reply

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