Microsoft FLOW and NAV 2017 connection issues

(0) Share

Report

Posted on by Community Member

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

I have the same question (0)

All responses (23)

Answers (0)

SK-30011758-0 85 on at

Like (0)

Report

RE: Microsoft FLOW and NAV 2017 connection issues

Hi, did you ever get any success with this, I have the identical problem

many thanks

Was this reply helpful? Yes No
Yukon 714 on at

Like (0)

Report

RE: Microsoft FLOW and NAV 2017 connection issues

Hi,

Try to use with NAVUserName or Web Service Access key.

Regards,

Was this reply helpful? Yes No
Suggested answer

Roberto Stefanetti 12,998 on at

Like (0)

Report

RE: Microsoft FLOW and NAV 2017 connection issues

hi,

"Web Service Access key" i think is mandatory for NAV 2017 to avoid Mashup error.

i ask to Microsoft about documentation\configuration for NAV 2017 (Microsoft Flow is in Preview).

let you know ASAP.

Was this reply helpful? Yes No
Community Member on at

Like (1)

Report

RE: Microsoft FLOW and NAV 2017 connection issues

Thank you Roberto

Was this reply helpful? Yes No
Suggested answer

Roberto Stefanetti 12,998 on at

Like (0)

Report

RE: Microsoft FLOW and NAV 2017 connection issues

hi,

good news, i asked two hours ago to my friend Suvidha to write a post about this issue.. she was wraiting a post about this topic..... just in time.....

please read this post... (is about Dynamics 365 but can be useful also for NAV 2017)

suvidhablogpost.wordpress.com/.../my-first-microsoft-flow-with-dynamics-365-for-financials

good reading..

Was this reply helpful? Yes No
Suggested answer

Mohana Yadav 60,979 Super User 2025 Season 2 on at

Like (0)

Report

RE: Microsoft FLOW and NAV 2017 connection issues

Created 2 flows.. 1 for Dynamics 365 and 1 for NAV2017

Dynamics365 flow is working and NAV2017 flow is not working.. need to investigate..

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

RE: Microsoft FLOW and NAV 2017 connection issues

Roberto,

I read through the blog. It was helpful but the issue remains when trying to create a FLOW for Dynamics NAV 2017 - keep running into the MASHUP 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: 'vparameswaranlt.sg.com'

This error comes up when trying to select the table on the FLOW. All connection settings info. are entered accurately to my knowledge and as explained/illustrated in the blog.

This is standard Cronus NAV 2017 database. All client and server components are installed locally on my machine. The NAV2017 Web Client works correctly. Do we need to have SSL enabled on the NAV server for the FLOW to work?

Here are my settings:

ODATA Feed URL: vparameswaranlt.sg.com/.../OData

Username: SG\VPARAMESWARAN (exactly as in the User card in NAV)

Password: Web service key (copied from the User card in NAV)

Company: CRONUS USA, Inc.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

RE: Microsoft FLOW and NAV 2017 connection issues

Mohana,

Just replied to Roberto. I read through the blog he suggested. It was helpful but the issue remains when trying to create a FLOW for Dynamics NAV 2017 - keep running into the MASHUP 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: 'vparameswaranlt.sg.com'

This error comes up when trying to select the table on the FLOW. All connection settings info. are entered accurately to my knowledge and as explained/illustrated in the blog.

This is standard Cronus NAV 2017 database. All client and server components are installed locally on my machine. The NAV2017 Web Client works correctly. Do we need to have SSL enabled on the NAV server for the FLOW to work?

Here are my settings:

ODATA Feed URL: vparameswaranlt.sg.com/.../OData

Username: SG\VPARAMESWARAN (exactly as in the User card in NAV)

Password: Web service key (copied from the User card in NAV)

Company: CRONUS USA, Inc.

Was this reply helpful? Yes No
SK-30011758-0 85 on at

Like (0)

Report

RE: Microsoft FLOW and NAV 2017 connection issues

Does youR Web service access key have an equals sign at the end?

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

RE: Microsoft FLOW and NAV 2017 connection issues

Yes, it does.

Was this reply helpful? Yes No