Unanswered

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

(0) Share

Report

Posted on 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

Categories:

Power Apps Pro Dev & ISV

All responses (3)

Answers (0)

Sort by

magesoe 80 on at

Like
a
(1)

Report
Copy link

Link copied!

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
hardik_486 2 on at

Like
a
(0)

Report
Copy link

Link copied!

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
v-xida-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

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,