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.
- OData Feed URL – url that is provided in NST under OData base url (first picture)
- Username – user which we previously created in NAV (6th picture).
- Password – Web Service Access Key (7th picture)
- 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 🙂
Tags: dynamics nav PowerApps
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.
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.
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?
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.
Hi Soren,
Dynamics NAV 2016 is not supported with PowerApps as one of the requirements is ODataV4 which was first provided in NAV 2017. The following blog has further information:
https://cloudblogs.microsoft.com/dynamics365/no-audience/2018/07/05/create-apps-with-powerapps-and-dynamics-nav/
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
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.
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.
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.
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.
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
Hi,
is this configuration on Azure VM or your local installation? Did you try without OdataV4, only Odata?
Br,
Renato.
why dynamics NAV is important? any use for that can explain a few lines?
http://mastermindtechies.com/microsoft-dynamics-nav/
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.
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
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.
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.
Hello. I updated NAV 2016 to NAV 2018 my dynamics server. Then, I configured my instances as you say.
But when I tried to connect powerApps – I have an error:
“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.”
When I tried get ODataV4 from Postman, I had an error.
Then I configured API from page 5469.
After that, I connect from powerApps to my server, using default connection – Business Central On-Premises.
URL – https://nav.kernel.ua:9008/MYODATDINSTANCE/api/beta
Hello,
I did follow the steps that you have provided and i am getting this error “The URL ‘https://180.151.86.85:7048/PowerApp/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: 378c44a6-24ff-49b1-893f-ccb2c154c363”.
Can you please tell me what am i doing wrong?
Thank you.
Hello Vaihav,
were you able to solve your problem? I also use an https link and it does not work on powerapps.
when I use http it works. but I’m supposed to apply ssl (https) connection.
I appreciate your help !
Hi Renato,
Great and detailed Post.
Wondering how to do the same with NAV 2013 since we dont have ODataV4. Any info regarding this?. Thanks.