powerapps and nav 2017 can read the OData flow

wic

Hi,
I'm trying to demonstrate powerapps with NAV2017. In the powerapps app, I take the "dynamics NAV" connection and put the oData feed URL (which works in IE or Firefox). The login and company is entered and after 10 seconds I received a message "Data could not been loeaded correctly. Try again"

I tried different cronus companies (switzerland are always within parenthese like "CRONUS (Suisse) SA" and the ODataV4 feed too. If I put a totally incorrect companyname, I've the same message.
Any idea?
Thanx

wic

UPDATE: apparently the powerapp "web app" has better read capabilities :-) but now the error is "the tables could not be loaded correctly. Try again".
Maybe I should not take the "Dynamics 365" template. I use it then I use the "Dynamics NAV" connection but it seems to be a mesh inbetween.
Someone get it work?

mohana_cse06

Its working for me in Dynamics 365.
Can you access your ODATA url from any other public machine?

wic

Hi,
thanx for the answer.
Actually my NAV is on Azure. I tried to connect from my computer. IE/Firefox gave me answers for my Odata, so I suppose it should work from "powerApps" too.

By the way, same problem with the new Excel add-in (the one from the store) it always return an error.

yukon

You can access the OData from IE/FF if you are using windows/username/navusername or web service key. But PowerApps only work with navusername or web service key.

- PowerApps Work with (2017 OData (V3 or V4),2016 OData(V3)) . I'm not sure current connector only support read only. It show the error when i write back to nav.

Regards,

Kraver

I have the same issue, cannot connect with powerapps. Excel and any browser handles it fine.
Tried users as email adresses and as nav user. We are using NAV2015 however..

What Odata feed are they expecting?
Tested these:
http://IP:7448/Navinstance/OData/PublishedPage
http://IP:7448/Navinstance/OData/
http://IP:7448/Navinstance/

Or does it need to be https?

Crunch

yukon wrote: »

You can access the OData from IE/FF if you are using windows/username/navusername or web service key. But PowerApps only work with navusername or web service key.

- PowerApps Work with (2017 OData (V3 or V4),2016 OData(V3)) . I'm not sure current connector only support read only. It show the error when i write back to nav.

Regards,

I'm facing the same issue with a local test installation.

aceX

Please check the service which you use (example DynamicsNAV100) does have enabled OData in OData fast tab and also does this service credential type is NavUserPassword.
PowerApps are working just fine with NAV 2017 and reading data from there. But you can't insert data in NAV using PowerApps, the OData link gives you only read only access to the data. I think PowerApps are not much useful until this issue is not avoided..

Regards