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
Solved! Go to 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.
@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
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."
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?
Thank for response @timl
My table contains all fields with allow nulls. Please find attached screenshot for your reference
Thanks
@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."
Thanks @mdevaney . Sorry I missed your answer.
Please find attached screenshot of app and table
Thanks
@mdevaney I have written below code to submit form values to SQL
SubmitForm(Form1);NewForm(Form1)
Thanks
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.
@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."
User | Count |
---|---|
257 | |
110 | |
90 | |
51 | |
44 |