powerapps and nav 2017 can read the OData flow

wic
wic Member Posts: 96
in NAV Three Tier
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
#### Only one can survive ######

Answers

  • wic
    wic Member Posts: 96
    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?
    #### Only one can survive ######
  • mohana_cse06
    mohana_cse06 Member Posts: 5,506
    Its working for me in Dynamics 365.
    Can you access your ODATA url from any other public machine?

    -Mohana
    http://mohana-dynamicsnav.blogspot.in/
    https://www.facebook.com/MohanaDynamicsNav
  • wic
    wic Member Posts: 96
    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.
    #### Only one can survive ######
  • yukon
    yukon Member Posts: 361
    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,
    Make Simple & Easy
  • Kraver
    Kraver Member Posts: 17
    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
    Crunch Member Posts: 38
    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
    aceX Member Posts: 166
    edited 2017-06-27
    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

Categories