Create/Update Records is not working with Lookup (EntityReference) field

Like (0) Share

Report

Posted on 24 Jul 2020 06:46:04 by hardik_486

Hi,

I have created console application and tried to connect Dynamics 365 using Microsoft.Powerplatform.Cds.Client (.net core package) and everything is working fine. I am also able to fetch the records from Dynamics.

I have tried to create the records with only Name field - for e.g. account["name"] then it is working fine and new records are created in Dynamics. But when I tried to set lookup field - for e.g. dummyentity["test_accountid"] = new EntityReference("account", <GUID of Account>) then it gives below error

Microsoft.Rest.HttpOperationException
HResult=0x80131500
Message=Operation returned an invalid status code 'BadRequest'
Source=Microsoft.PowerPlatform.Cds.Client

I already verified the field names and GUID also exists in dynamics.

Can you please help me out here?

Thanks in advance!

Regards,

Hardik Shah

All responses (3)

Answers (0)

v-xida-msft on 24 Jul 2020 at 09:46:03

Like (0)

Report

Re: Create/Update Records is not working with Lookup (EntityReference) field

HI @hardik_486 ,

How do you update the LookUp field in your Account Entity? Using Microsoft.Powerplatform.Cds.Client?

Please make sure the 'test_accountid' is the logic name of the LookUp field in your Target Entity. Please go to the CDS in your PowerApps, then find your Target Entity, then find the logic name of the LookUp field, rather than go to your Dynamics CRM.

According to the issue that you mentioned, I think this issue may be related to this ALPHA version -- Microsoft.Powerplatform.Cds.Client -Version 0.2.14-Alpha.

Please consider submit an assisted support ticket through the following link for further help:

https://powerapps.microsoft.com/en-us/support/pro

Regards,
hardik_486 2 on 24 Jul 2020 at 06:57:44

Like (0)

Report

Re: Create/Update Records is not working with Lookup (EntityReference) field

Hi,

Thanks for quick response.

Yes it seems the same issue in other thread. I tried lots of thing but it is not working with lookup fields.

Regards,
Hardik Shah
magesoe 80 on 24 Jul 2020 at 06:52:55

Like (1)

Report

Re: Create/Update Records is not working with Lookup (EntityReference) field

Sounds like the same issue as https://powerusers.microsoft.com/t5/Power-Apps-Pro-Dev-ISV/Operation-return-invalid-status-code-Bad-Request-Microsoft/m-p/635841#M3044