Is the common data service connector still working ?

[_Simon_]

Hello, I'm trying to build an app that lists sales opportunities from Dynamics 365 in a browser gallery with the deprecated connector. However I'm getting weird results:

This how the app looks like when it's automatically build by Power App Studio. Some fields seems to work and others (foreign keys) don't. Is this because of the deprecated connector or there is another problem here I can work on ?

I've read somewhere that the new recommended way to build power apps for Dynamics is to use the common data services. Is this possible to migrate on this easily ?

Thanks in advance for your answers.

[_Simon_]

Sorry I've just realized I've written "common data service connector " instead of "Dynamics 365 connector " in the title of this post... My question concern the latter.

[rohsh354]

Hello,

Yes, Dynamics 365 Connector is officially deprecated on 5th May 2020, so its not surprising if it does not work as expected.

You should leverage "Common Data Service (Current Environment) connector".

https://docs.microsoft.com/en-us/power-platform/important-changes-coming#dynamics-365-connector-is-d...

Changing or adding a connection should not be difficult. Please refer to the article below. Its related to "Common Data Service" connector but same should be applicable for "Common Data Service (Current Environment)"

https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/connections/connection-common-data-serv...

[_Simon_]

Hello,

Thank you for your reply, I've read this MS docs article concerning the common data service (current environment). In it I'm reading that we have to create solution-aware flows to use the Common Data Service (current environment) connector. This looks like a long process and honestly I don't think we have time for that on the project I'm working on.

Currently, everything is working fine with the dynamics 365 connector except when we try to write a foreign key on a record, as you can see in the example below we're trying to write an account id on an opportunity but the api respond with an code 400 and a vague error message, can you confirm that it's failing because we're using the old dynamics 365 connector ? In addition, is it possible to send raw http requests to the api to achieve our goal ? If yes, how this requests should be formatted ?

We would like to continue the current development with the old connector if possible to avoid wasting 1 week of dev but if this is doomed to fail we will probably going to switch on the new connector asap.

This is what happens when we try to create a new opportunity, we've isolated the issue to the accountid because it works when this field is removed (it just creates an opportunity no linked to an account):

Thanks again for your help

[_Simon_]

I forgot to add that we're using Dynamics on premises (not Dynamics Cloud)

[_Simon_ · Accepted solution]

Ok so I managed to find a solution by using the Patch function.

Patch(
    Opportunities,
    Defaults(Opportunities),
    {
        name: DataCardValue19.Text,
        probability: 969950001, /* This is hardcoded for now */
        _parentaccountid_value: DataCardValue22.Selected.accountid,
        main_product_line_value: DataCardValue3.Selected.productid
    }
)

Another thing was to write the accountid selected by the dropdown on the _parentaccountid_value field instead of the parentaccountid field. Don't know why tho.