Showing results for 
Search instead for 
Did you mean: 
New Member

Please provide an example how to make a connection to on-premise Dynamics NAV (2017)

I create a connection to Dynamics with the following connection:

  • OData Feed URL: http://<server>:<portnumber>/DynamicsNAV_NL_WIN/OData/
  • Username: <domain>\username
  • Password: <password>
  • Company: CRONUS Nederland BV


It saves the connection without an error. Based on this connection I create a new flow. But Microsoft Flow gives an error when I have to fill in the Dynamics NAV Table Name. The error is 'Can not retrieve value: TypeMismatchError'


Please can you provide an example how to create a connection to an on-premise Dynamics NAV 2017 environment? Or tell me what is going wrong?

Community Support
Community Support

Hi adoorn,


I think you have successfully added the Dynamics NAV connection.

And currently it is still under preview, some function may not be available. Just from the error message you shared, it seems that currently Microsoft Flow doesn't support that type of data.

Could you please share some information regarding the table that you want to get into Microsoft Flow?


Community Support Team _ Michael Shao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Hi Michael,


I want to create a basic example to the Customer tabel (is tabel 18 in Dynamics NAV).

De ODATA feed is based on page 22 (Customer List)



I used the the following ssl url https://<server>:7048/DynamicsNAV_SALES_WIN/OData/

But still the same problem.

I can use the the Odata in the webbrowers an excel with no problem, also from a different computer.


Please provide us a solution.

Helpful resources

MPA Virtual Workshop Carousel 768x460.png

Register for a Free Workshop

Learn to digitize and optimize business processes and connect all your applications to share data in real time.

New Process Advisor Capabilities carousel.png

Read the blog for the latest news

Read the latest about new experiences and capabilities in the Power Automate product blog.

PA Survey Carousel Image.png

We want to hear from you!

If you are a small business ISV/Reseller, share your thoughts with our research team.

AI Builder AMA June 7th carousel (up on May 25th, take down June 8th) (1).png

'Ask Microsoft Anything' about AI Builder!

The AI Builder team invite you to ask questions and provide helpful answers at our next AMA.

Users online (1,522)