Skip to main content

Notifications

Power Automate - Using Connectors
Unanswered

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

(0) ShareShare
ReportReport
Posted on by 4

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?

Categories:
  • adoorn Profile Picture
    adoorn 4 on at
    Re: Please provide an example how to make a connection to on-premise Dynamics NAV (2017)

    Hi,

     

    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.

  • adoorn Profile Picture
    adoorn 4 on at
    Re: Please provide an example how to make a connection to on-premise Dynamics NAV (2017)

    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)

  • v-micsh-msft Profile Picture
    v-micsh-msft on at
    Re: Please provide an example how to make a connection to on-premise Dynamics NAV (2017)

    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?

    Regards

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Microsoft Kickstarter Events…

Register for Microsoft Kickstarter Events…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Announcing Forum Attachment Improvements!

We're excited to announce that attachments for replies in forums and improved…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 145,304

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 64,703

Leaderboard

Featured topics