The requested operation is invalid. Server Response [dbo].[tableName] A value must be provided to item client requestId: d18ddacb-…….

[Umesh_chape]

Hello,

I am creating power app to save the data in SQL server ( Azure). 

In this app total 4 screens are present and at last screen I am submitting data from form to SQL table. 

I am getting below error 

"

The requested operation is invalid. Server Response [dbo].[tableName] A value must be provided to item client requestId: d18ddacb-……."

Any if what may wrong from powerapps, SQL table, Azure access

I have attached error screenhot

Thanks

[mdevaney]

@Umesh_chape 
Show the code you are using to submit the data.  A screenshot of the app would also be helpful.

---
Please click "Accept as Solution" if my post answered your question so that others may find it more quickly. If you found this post helpful consider giving it a "Thumbs Up."

[timl]

Hi @Umesh_chape 

The most likely cause of this error is that your table contains a mandatory field, and your Form or Patch statement doesn't provide a value for this field. Can you check that you've provided values for all the mandatory/non-null fields in your table?

[Umesh_chape]

Thank for response @timl 

My table contains all fields with allow nulls. Please find attached screenshot for your reference

Thanks

[mdevaney]

@Umesh_chape 
Did you forgot to pass the ID when updating an existing record?  Are you using a SQL View?

You have not shown your code here as I asked in my first post.  Please share it.

---
Please click "Accept as Solution" if my post answered your question so that others may find it more quickly. If you found this post helpful consider giving it a "Thumbs Up."

[Umesh_chape]

Thanks @mdevaney . Sorry I missed your answer. 

Please find attached screenshot of app and table

Thanks

[Umesh_chape]

@mdevaney   I have written below code to submit form values to SQL

SubmitForm(Form1);NewForm(Form1) 

Thanks

[timl · Accepted solution]

Hi @Umesh_chape 

Can you confirm that there is a primary key on your table? None of the columns in your screenshot seem like a primary key field.

PowerApps isn't able to work against tables without a primary key so that's another candidate for this not working.

[mdevaney · Accepted solution]

@Umesh_chape 
Now that I have seen your code, I agree with @timl: have you defined a primary ID (key) for your SQL table?

---
Please click "Accept as Solution" if my post answered your question so that others may find it more quickly. If you found this post helpful consider giving it a "Thumbs Up."

[Umesh_chape]

Thanks @timl @mdevaney . I have created primary key as "Requestor". 

But Then I am getting error "Requestor: Field Requestor is required" 

I am passing this field from  Office365Users connector. Code is "Office365Users.MyProfileV2().displayName". Even I can see that result on my screen.