I create a connection to Dynamics with the following connection:
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?
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?
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.
Dive into the Power Platform stack with hands-on sessions and labs, virtually delivered to you by experts and community leaders.
Watch Nick Doelman's session from the 2020 Power Platform Community Conference on demand!
Check out the community blog page where you can find valuable learning material from community and product team members!