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 🙂

 

 

11 thoughts on “Connect Dynamics NAV and Microsoft PowerApps

  1. Wilbert

    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.

    1. renato Post author

      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

    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?

    1. renato Post author

      Hi Soren,

      this issue can indicates multiple problems, and your plan is ok. I would check if url is visible from outside of Dynamics NAV. Check firewall, self signed certificate.

  3. Srikar Nadar

    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

    1. renato Post author

      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

    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.

    1. renato Post author

      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

    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

    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

    1. renato Post author

      Hi,

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

      Br,
      Renato.

Leave a Reply

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