Error connecting to D365. Primary Key error.

[Anonymous]

Good morning internet.

I'm trying to connect a PowerApp to some specific tables in D365. Some tables connect OK, for example, ItemBatches table, however to get stock locations, I need to connect to the WarehousesOnHand, however, when I try and connect, I receive the following message.

            Error
            There was a problem adding your data source. Please try again

            More

                  Primary key column 'ItemNumber' must be either read-only and optional or writable and required.

I notice this question has been asked a couple of times, but the threads have fizzled out without an answer. Does anybody have any ideas?

Many thanks in advanced

Neil (a D365/PowerApps Newbie)

[FCGALLEG]

Hi NeilCotton, 

We have it reported as bug. We are working on to fix this issue.

Thanks.

JAvi

[Anonymous]

Hi @FCGALLEG ,

Thanks for your reply..... do you know if there is any other way I can get at that specific data (the warehouse location of a batch)?

Many thanks for your time.

Regards

Neil

[FCGALLEG]

No sorry. but we hope to have the bug fix in the next weeks.

Javi.

[Datnt6]

Hi @FCGALLEG 

I have the same issue can you please tell me when MS will release the fix ? Is the issue from powerapps or entity of D365FO ?

Thank you.

[VineetCANZ]

I am having the same issue any idea when this will be fixed?

[raoraheel]

@FCGALLEGdo you have an update on when the fix will be available to us? I'm getting a similar error when trying to use ReqTrans table in my app.

[VineetCANZ]

@FCGALLEG can you at least tell us the bug number and the link so we can track it ??

[raoraheel]

@VineetCANZ  looks like this is still under investigation. I searched for this on

@FCGALLEGif you can validate please.

Issue 413461 - Open

https://fix.lcs.dynamics.com/Issue/Details/1193348?bugId=413461&dbType=3&qc=ca88281167c7d70ea471144d...

[VineetCANZ]

I am no getting a different error 

Cannot read property 'name' of undefined

Session ID: e1b46985-2bab-4cce-8808-0e35a5020f5f

Can anyone let me know what this means and how can i get this working ?