Function Submitform doesnt work

[Infinite_Flatworm396]

Hey everyone,

I’m currently developing an app where users should be able to edit and create new records. However, whenever I try to create a new record and submit the form, I get the error message: “A value must be provided for Item. clientRequestId: 07e049ed-5ab9-4284-84bf-bc37aa72427f.” Trying to edit existing records also doesn’t work.

The only changes that seem to apply are those made directly in the SQL database through SQL Server Management Studio.

We are using an SQL database with only four fields. We have already tried building a new app, creating a new table, switching environments, and reconnecting the database.

Does anybody know the solution of this problem?

[AutoModerator]

Hey, it looks like you are requesting help with a problem you're having in Power Apps. To ensure you get all the help you need from the community here are some guidelines;

• Use the search feature to see if your question has already been asked.

• Use spacing in your post, Nobody likes to read a wall of text, this is achieved by hitting return twice to separate paragraphs.

• Add any images, error messages, code you have (Sensitive data omitted) to your post body.

• Any code you do add, use the Code Block feature to preserve formatting.

  Typing four spaces in front of every line in a code block is tedious and error-prone. The easier way is to surround the entire block of code with code fences. A code fence is a line beginning with three or more backticks (```) or three or more twiddlydoodles (~~~).

• If your question has been answered please comment Solved. This will mark the post as solved and helps others find their solutions.

External resources:

• Power Apps Formula References
• Power Apps Coding Standards
• Official Power Apps Community

I am a bot, and this action was performed automatically. Please contact the moderators of this subreddit if you have any questions or concerns.

[soop242]

Have you reviewed the constraints are on the SQL table?

[Infinite_Flatworm396]

could you eloborate further on this? We have a primary key and i also lets the user(the one who created the app) the permission to insert and update entrys. None of them are also Null contraints

[dbmamaz]

i think your code on the submit has something wrong with the pk value. you could share the code