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.
There was a problem adding your data source. Please try again
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)
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.
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 ?
@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 looks like this is still under investigation. I searched for this on
@FCGALLEGif you can validate please.
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 ?
Check out the News & Announcements to learn more.
Did you know that you can visit the Power Query Forum in Power BI and now Power Apps
Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.
Check out our new Discover Your Career Path blog post series and get all the details.