cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Jfreitas
Level: Powered On

D365FO and powerapps error: the field with id '0' does not exist in table

Hello, 

 

I am fairly new to PowerApps and have been assigned the task of creating a power app that connects to a D365FO entity and then add and update the information. When I attempt to use a form and then SubmitForm() i get the following error: Error.png

This only occurs when I change the information of the form before submitting and will not occur if the form is empty when submitting. 

 

I can provide further information if needed

 

Thank you for any assistance you may be able to provide

2 REPLIES 2
Community Support Team
Community Support Team

Re: D365FO and powerapps error: the field with id '0' does not exist in table

Hi @Jfreitas ,

Could you please share a bit more about the error message within your app?

Have you made some changes within your 'EcoResReleasedProduct' table? Modify columns or remove columns from your D365 F&O table?

 

Please check if you have made some changes to your 'EcoResReleasedProduct' table. If yes, please consider remove the D365 F&O connection from your app, then re-add a new connection to your D365 F&O table from your app, check if the issue is solved.

 

In addition, as an alternative solution, you could also consider submit your form data into your D365 F&O table using Patch function instead of SubmitForm function. Please take a try with the following formula:

Patch(
      EcoResReleasedProduct,
Defaults(EcoResReleasedProduct),
EditForm1.Updates )

check if the issue still exists.

More details about Patch function, please check the following article:

Patch function

 

In addition, such issues are commonly seen in maps when there is a new field added in any of it's associated tables. please also check and see if the following article would help in your scenario:

https://community.dynamics.com/ax/f/33/t/195541

https://community.dynamics.com/ax/f/33/t/170734

 

Best regards,

Community Support Team _ Kris Dai
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Administrator
Administrator

Re: D365FO and powerapps error: the field with id '0' does not exist in table

Thanks for posting in the community @Jfreitas - can you review the above reply and update the thread when you have a chance? 

 

Thank you,

 

@TopShelf-MSFT 

Helpful resources

Announcements
thirdimage

Power Automate Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

sixthImage

Power Platform World Tour

Find out where you can attend!

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

fifthimage

Microsoft Learn

Learn how to build the business apps that you need.

Top Kudoed Authors
Users Online
Currently online: 211 members 6,203 guests
Please welcome our newest community members: