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

[Jfreitas]

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: 

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

[v-xida-msft]

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,

[TopShelf-MSFT]

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