Showing results for 
Search instead for 
Did you mean: 
Regular Visitor

Update field in Dynamics NAV



I am trying to send data from PowerApps to Dynamics NAV using patch function but I receive errors. 


If you encountered this issue or know why it's not working please let me know. 


Thank you,




Dual Super User II
Dual Super User II

Hi @AlexCristian 


Can you share more details about the errors that you are getting? Maybe through some snippets and screenshots. That way we might be able to help you better.

Note: Make sure that you are passing values appropriate to the field type in the datasource.


Hope this Helps!

If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!

Thank you for your response. 


I didn't go into details because I read on some other website that with Odata or OdataV4 you can only read data in Power Apps but I also saw that some was able to create items or update fields in Dynamis NAV. So I'm a little confused.


The NAV I'm using is hosted on Azure, I worked with a NAV developer to make sure everything is fine from that side. 


I can retrieve the rows but I cannot update them. I need to update the quantities from a purchase order. I also tried the submit form function. Please see the attachments.



Hi @AlexCristian ,

Do you mean that you could retrieve records from your NAV table, but you could not update them within your app?

Which permission do you have for the NAV table? Only Read-Only permission?


Based on the issue that you mentioned, it seems to tell that you have read permission to the NAV table but not edit permission to your NAV table.

On your side, please check if your current account have proper Edit permission to your NAV Table.

Note: PowerApps app inherits data access permission from data source itself.


In addition, the Dynamics NAV conector is a Premium connector, please make sure that your current account have owned PowerApps Plan 1 license at least.


Also please consider take a try to re-create a new connection to your NAV Table from your app, then try your Patch function again, check if the issue is solved.


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.

Helpful resources

PA User Group

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group


Demo Extravaganza is Back!

We are excited to announce that Demo Extravaganza for 2021 has started!

MBAS on Demand

Microsoft Business Applications Summit sessions

On-demand access to all the great content presented by the product teams and community members! #MSBizAppsSummit #CommunityRocks

Power Apps June 2021

June Power Apps Community Call

Did you miss the call? Check out the recording here!

Top Solution Authors
Top Kudoed Authors
Users online (25,772)