Connect Dynamics NAV and Microsoft PowerApps

Hi,

in this blog post I will write how to create connection between Dynamics NAV 2018 and Microsoft PowerApps.

This connection will then be used in next few blog post to see how this integration works, but let’s start with connection.

First what you will need is one Dynamics NAV NST with NavUserPassword credential type and configured Odata Base URL like on picture bellow.

 

Now login to https://powerapps.microsoft.com/ and then you will be transferred to page like on picture bellow.

 

Now the next step is to click on gear in upper right corner and then on Connections.

When the new web page is open click on New connection,

 

And in new web page filter Dynamics and choose Dynamics NAV.

 

Now leave this new window opened and return back to NAV and go to Departments -> Administration -> IT Administration -> General -> Users and create new user in NAV. Give that user a  username, super permission, and then click on change web service key.

In the Web Service Access fast tab you should have Web Service Access Key, copy it to notepad.

Now return back to Microsoft PowerApps and fill the window with information like bellow.

  1. OData Feed URL – url that is provided in NST under OData base url (first picture)
  2. Username – user which we previously created in NAV (6th picture).
  3. Password –  Web Service Access Key (7th picture)
  4. Company – name of the company in NAV -> You can find it under the NAV Button -> Select Company.

 

Finally click on OK, and if everything is okay you should see new Connection Dynamics NAV under connections.

Now we are ready to use that connection so I am happy to write my next blog posts about this beautiful and powerfull integration with Flow and PowerApps.

 

Br,

Renato 🙂

 

 

17 Comments
  1. Wilbert 1 year ago

    Hi Renato,

    Great post.

    I try to get it to work with credentialtype windows instead of NavUserPassword. Do you know if that works? When i create the connection I get the the error: Incorrect username or password. Type the correct username and password for Microsoft Dynamics NAV, and try again.

    If i copy the url in chrome and use my windows credentials it works fine.

    • Author
      renato 1 year ago

      Hi Willbert,
      thanks on the comment.
      Currently, integration between Dynamics NAV and PowerApps works only with NavUserPassword authentification because it uses Dynamics NAV connector which works with NavUserPassword.

      Best regards,
      Renato.

  2. Søren Hougaard Hinrup 12 months ago

    Hi
    I just followed the instruction in this post, but my PowerApp still wont connect to our Azure NAV Database. It keeps giving me the following error:
    “The URL ‘http://XX.XXX.XX.XXX:7048/NAV/OData/’ is not a valid Microsoft Dynamics NAV OData feed URL. The OData feed URL can be found on the ‘Web Services’ page in Microsoft Dynamics NAV. clientRequestId: 3a6f92fa-5454-4002-afb0-4ae04fc415c5”.
    I can easily access the OData feed from my browser.

    When I try to connect to Dynamics NAV the name of the connection is “Dynamics NAV (example)”. I have a Plan2 licens.
    Do you have any idea why it won’t connect?

  3. Srikar Nadar 12 months ago

    Hi Renato,

    Followed the same process but facing following issues, can you let me know where it went wrong.

    The URL ‘http://XXXXXX:7048/DynamicsNAV90/OData/’ is not a valid Microsoft Dynamics NAV OData feed URL. The OData feed URL can be found on the ‘Web Services’ page in Microsoft Dynamics NAV. clientRequestId: de08ad59-baf9-488b-84ae-22b01ce40e35.

    Thanks,
    Srikar

    • Author
      renato 11 months ago

      Hi Srikar,
      it can be multiple issues. Check if this link is available in browser when you connect to them. Do you see data in browse? Do you try to turn off firewall, vpn or etc.

      Best regards,
      Renato.

  4. Srikar Nadar 12 months ago

    Hi Renato,

    I have tried all the steps for connecting NAV with power app but am facing the following issue, can you let me know where it went wrong?

    The URL ‘http://XXXX:7048/DynamicsNAV90/OData/’ is not a valid Microsoft Dynamics NAV OData feed URL. The OData feed URL can be found on the ‘Web Services’ page in Microsoft Dynamics NAV. clientRequestId: aaedff10-0062-4da8-9def-2777bae1e702

    Thanks,
    Srikar.

    • Author
      renato 11 months ago

      Hi Srikar,
      it can be multiple issues. Check if this link is available in browser when you connect to them. Do you see data in browse? Do you try to turn off firewall, vpn or etc.

      Best regards,
      Renato.

  5. Think Tribe 12 months ago

    MS Dynamics NAV is a suitable business handling software developed for small business owners. It computerizes and manages the business tasks of a business therefore bringing about enhanced work effectiveness. It is available with amazing features which create the management of sales, finance, transportation, fabrication, advertising, and much simpler.

  6. Rachana 10 months ago

    1. link in browser work properly including power BI
    2. firewall off both
    3. get error both OdataV4 and OData

    i try all but i still face the error below please help

    The URL ‘http://192.168.1.117:7048/DynamicsNAV100/ODataV4/’ is not a valid Microsoft Dynamics NAV OData feed URL. The OData feed URL can be found on the ‘Web Services’ page in Microsoft Dynamics NAV.
    clientRequestId: A26EA298-19FB-4839-A7D9-5C01F7826631

    • Author
      renato 8 months ago

      Hi,

      is this configuration on Azure VM or your local installation? Did you try without OdataV4, only Odata?

      Br,
      Renato.

  7. mastermindtechies 7 months ago

    why dynamics NAV is important? any use for that can explain a few lines?
    http://mastermindtechies.com/microsoft-dynamics-nav/

    • Author
      renato 5 months ago

      Hi,

      you can use dynamics NAV to help small and mid-size companies worldwide to manage their accounting and finances, supply chain, and operations.

      Best regards,
      Renato.

  8. brendon 7 months ago

    Hey,
    Would this work with Nav 2013r2? I see nothing from the article that indicates it wouldn’t.

    I’d like to create records in NAV using powerapps, for example a Customer or a PO with basic info i.e. PO number and description. So nothing too complicated, just enough info to get the ball rolling.

    I have access to the NAV SQL db through powerapps and suspect I could create records through SQL via store procedues but this seems more legit.

    Has anyone had success creating record in NAV 2013r2 using PowerApps?

    Thanks in advance,
    Brendon

    • Author
      renato 5 months ago

      Hi Brendon,

      to be honest I never had the opportunity to test it with NAV 2013 R2 only with NAV 2017 and NAV 2018 which works ok. If you use SQL connector then it should do not matter which version of Dynamics NAV it is. When we speak about ODATA connector, in that case, it could be important which version of Dynamics NAV is.

      Best,
      Renato.

  9. Nitin Goel 3 months ago

    We have dynamic NAV 2016 with secure SSL OData web service which can be accessed in browser outside the organization as well.
    When I try to create Custom connector, it throws 401 unauthorised error.
    I also try the same OData web service using Postman and here also it throws 401 unauthorised

    Please let me know is that possible to connect Dynamic NAV 2016 with Powerapps either using custom connector or new connection or some other ways. Please help.

Leave a reply

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

*

Copyright ©2019 fajdiga.info. All rights reserved. Powered by Derecjun

Log in with your credentials

Forgot your details?