Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics NAV (Archived)

Microsoft FLOW and NAV 2017 connection issues

Posted on by Microsoft Employee

I am trying to create a Microsoft FLOW to Dynamics NAV 2017 Cronus db and running into issues. Thought I’d run it by you.

https://flow.microsoft.com/en-us/

Below are the steps I am following:

My Flows >> Create from Blank. Type NAV, it comes up with the 2 available options. Select Dynamics NAV - When a record is created

Then it prompts for Connection Info. I created a webservice entry in NAV 2017 for the Item List Page and copied and pasted the ODATA URL into this field from NAV. I tried entering the username a few different ways since it was failing. But the latest entry for user name and company name are exactly as in NAV 2017 Cronus db.

Then when I click Create, it comes up with the Table Name selection. When I click the drop down button, it shows the error: "Could not retrieve values. Invalid Mashup expression using supplied values. inner exception. Dynamics 365 for Financials Request failed. The remote name could not be resolved Mycomputername.domain

Any suggestions?

Much Thanks

Kind Regards,

-Vasu

*This post is locked for comments

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Microsoft FLOW and NAV 2017 connection issues

    Hi All,

    is there any update about the Ms. Flow issue with NAV 2017?

    Regards,


    Rizki

  • Suggested answer
    Roberto Stefanetti Profile Picture
    Roberto Stefanetti 12,998 on at
    RE: Microsoft FLOW and NAV 2017 connection issues

    hi,

    I passed the request to NAV support.

    Flow is changed (like Power BI.... etc.)

    There seems to be problems with updating MS FLow that natively uses OData4.0 instead of 3.0 previously used; In practice, the existing\udated connector on NAV 2018 connects native to 4.0 during the mashup (not NAV 2017).

    Example:

    "Just tried it with oData V4 URL and get the same result as with the normal oData URL.. errors on creating connection then same issue trying to create the FLOW itself. Interesting it works with 2018 though, wonder if an update is due to 2017 to make it work again."

    Some checks

    Check "Company name": characters  "/ * % or & ???"  are not allowed in NAV 2017 > supported only since NAV 2018...

    I'll let you know as soon as I get more information about this issue.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Microsoft FLOW and NAV 2017 connection issues

    0272.Untitled.png

    Hi I have added the base odata URL in and it still not working (see screen shots) - Any other ideas?

  • Suggested answer
    Zaid Tariq Profile Picture
    Zaid Tariq 2,266 on at
    RE: Microsoft FLOW and NAV 2017 connection issues

    Hi,

    If you have not specified the Base Odata Url in NAV Administration, you will not be able to connect.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Microsoft FLOW and NAV 2017 connection issues

    Hi Rishabh, did you resolve this? I am getting the same error but can't figure it out!

  • RE: Microsoft FLOW and NAV 2017 connection issues

    Hi Dmitry,

    I tried steps given as per your blog, but while connecting dynamics NAV with Flow and powerapps it gives me following error :

    The URL 'dynamicsnav2017dns.centralindia.cloudapp.azure.com/.../&; 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: 9aeb664f-948c-49dd-8a2d-c98b34b68b64

    its a test environment where I am trying it. (not working with http either)

    one more thing, I am able to access this url from a local machine on browser but not the remote desktop of my VM.

    Appreciate your help.

    Thanks!

    Rishabh.

  • Sara Freitas Profile Picture
    Sara Freitas on at
    RE: Microsoft FLOW and NAV 2017 connection issues

    Yes, I did everything like you explain on your blog.

    I have tested with web service key and with my user password and I have always the same error.

  • Suggested answer
    dkatson Profile Picture
    dkatson 2,263 on at
    RE: Microsoft FLOW and NAV 2017 connection issues

    https://community.dynamics.com/nav/b/katsonsnavblog/archive/2017/03/31/how-ms-flow-can-make-a-friendship-with-nav2017

    Did you looked at my blog ? 

    I suppose you used user password instead of web service key

  • Sara Freitas Profile Picture
    Sara Freitas on at
    RE: Microsoft FLOW and NAV 2017 connection issues

    Hello!

    I'm trying to connect to flow with dynamics NAV 2017. I have a VM on Azure with the NAV.

    When I try to connect to flow I have this error:

    "Não foi possível obter os valores. Credentials are missing or not valid. inner exception: The credentials provided for the Dynamics 365 for Financials source are invalid."

    I'm using the right URL (it works on browser), my user name, the web service access key and the company.

    Anyone with the same problem?

  • Suggested answer
    dkatson Profile Picture
    dkatson 2,263 on at
    RE: Microsoft FLOW and NAV 2017 connection issues

    Look at my blogpost on this topic

    community.dynamics.com/.../how-ms-flow-can-make-a-friendship-with-nav2017

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

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,280 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,214 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans