Primary Key Column 'itemnumber' Must Be Either Read-only and Optional or Writable and Required.

Dynamics 365 Finance Forum

Error while calculation data entity in Power Apps

Hello,

i k trying to add D365 FinOps data Entity in Power Apps but it will requite above error.

Cannot read property 'dataEntityDefinition' of undefined

Session ID: 1cc49780-ebe8-4edf-88cc-5309fd593870

Replies (17)

• All Responses
• But Answers

Will Wu responded on 28 Oct 2020 five:x AM

Mistake while adding data entity in Ability Apps

Hi Ashik Patel,

Please make sure there is a cavalcade called "dataEntityDefinition" in your D365FO data entity.

Hope this helps.

Error while calculation data entity in Power Apps

Hi,

Do yous become this error for a specific entity only or for all of your entities?

Is at that place possibly a connection problem to your motorcar?

Best regards,

Ludwig

Error while adding information entity in Power Apps

Yep it is specific Entity fault

Error while adding data entity in Power Apps

Hi  Volition,

i added only one field on this entity just nonetheless getting aforementioned error

Error while calculation information entity in Power Apps

in my entity have 2 tables  InventDim,Inventsum

Will Wu responded on 28 Oct 2020 nine:38 PM

Error while adding data entity in Power Apps

Hi Ashik Patel,

Effort to employ these two tables as data sources separately and check whether there is any fault message.

Error while adding data entity in Power Apps

Hello Ashik,

Tin yous actually open and run your PowerApps itself without embedding information technology into D365FO?

Can you also provide some boosted data on the tables that your PowerApp uses? Were those entities created / adapted by y'all?

Best regards,

Ludwig

Error while adding data entity in Power Apps

Hullo Ashik,

I practise assume this is a custom entity. Can you tell what values you used for the backdrop PublicCollectionName and PublicEntityName?

Error while adding information entity in Ability Apps

Hello Andre,

below entity name

Public Entity Proper noun : PickingListLines

Public Collection name :PickingListLines

Error while calculation data entity in Power Apps

Hi Ashik,

Check entity key on the entity and what kind of fields used there. There should not accept properties AllowEdit = No and Mandatory = Yeah at the same time. If they set to Auto, try to gear up AllowEdit = True and Mandatory = False

Error while calculation data entity in Power Apps

Hi Ashik,

Can yous attempt to take unique values for these names? E.g. 1 with PickingListLine (without due south) and the other with PickingListLines? Too ensure at that place is no other entity with the same values in these properties.

Suw responded on vii Jun 2021 8:47 AM

Fault while adding information entity in Power Apps

Whatsoever update on this issue ?

I found that following onhand entities also throw same error when adding via Power Apps.

Though, they are attainable from Power Automate without whatsoever fault.

one. InventorySitesOnHand

2. InventorySitesOnHandV2

3. WarehouseOnHand

iv. WarehouseOnHandV2

Suw responded on 7 Jun 2021 8:48 AM

Error while adding data entity in Power Apps

Any update on this issue ?

I found that following onhand entities also throw same fault when adding via Power Apps.

Though, they are accessible from Ability Automate without any error.

1. InventorySitesOnHand

2. InventorySitesOnHandV2

3. WarehouseOnHand

4. WarehouseOnHandV2

Mistake while adding data entity in Ability Apps

How-do-you-do all,

Finally managed to observe the solution for the effect.

While trying to connect to the required table/entity open the network tracer on the browser.

in the invoke call you should get the errorMessage that shows which field is causing the issue and why is that. This is the trouble for WarehouseOnHandV2 and similar issue was for my custom entity. It is related to the primary key defined on the entity.

1. [{dresult: {,…}}, {seq: 31}]
   1. 0: {dresult: {,…}}
      1. dresult: {,…}
         1. errorMessage: "Primary key column 'ItemNumber' must be either read-only and optional or writable and required."
   2. 1: {seq: 31}
      1. seq: 31

As well this is forwarded to the Dynamics team of Microsoft and so hope they will fix this issue and nosotros will get more reasonable letters when things similar this happen.

Regards,

Zoran

Anthony responded on 26 Jul 2021 iii:02 PM

Fault while adding data entity in Power Apps

Hello Zoran,

Has Microsoft or the Dynamics team responded to you lot? Using certain entities in Ability Apps withal produces the mistake "Master key column '<col name here>' must be either read-only and optional or writable and required." as of seven/26/2021.

Did you notice a workaround that worked?

Thanks.

Fault while adding information entity in Power Apps

Hi,

Do yous go this mistake for a specific entity only or for all of your entities?

Is there possibly a connection problem to your machine?

All-time regards,

Ludwig

Error while adding information entity in Power Apps

Hi all,

Finally managed to detect the solution for the issue.

While trying to connect to the required table/entity open the network tracer on the browser.

in the invoke call you should get the errorMessage that shows which field is causing the issue and why is that. This is the problem for WarehouseOnHandV2 and similar issue was for my custom entity. It is related to the primary central defined on the entity.

1. [{dresult: {,…}}, {seq: 31}]
   1. 0: {dresult: {,…}}
      1. dresult: {,…}
         1. errorMessage: "Primary key column 'ItemNumber' must be either read-simply and optional or writable and required."
   2. i: {seq: 31}
      1. seq: 31

Likewise this is forwarded to the Dynamics team of Microsoft so hope they will fix this effect and we will get more reasonable messages when things like this happen.

Regards,

Zoran

hansenwoud1961.blogspot.com

Source: https://community.dynamics.com/365/financeandoperations/f/dynamics-365-for-finance-and-operations-forum/406395/error-while-adding-data-entity-in-power-apps

Share this post