Hi @itghcitrus ,
Could you please show more details about the error message within your canvas app?
Do you submit data back to your original SQL Table or SQL View?
How do you submit your data? Using SubmitForm function or Patch function?
Based on the issue that you mentioned, I have made a test on my side, and don't have the issue that you mentioned. Firstly, please check if you have defined proper Primary Key in your SQL Table.
There are some known limits within SQL Connector in PowerApps, please check the following article:
https://docs.microsoft.com/en-us/connectors/sql/#known-issues-and-limitations
Also please check if you have provided proper value for these Required fields in your SQL Table. When you write data back to your SQL Table, please use SQL Table as data source rather than SQL View. Currently, the SQL View is Read Only in PowerApps app. If you use Patch function to submit form data, the standard formula format as below:
Patch(
'[dbo].[SQL Table]',
Defaults('[dbo].[SQL Table]'),
{ // must specify all Required fields within '{}' part
Cokumn1: "xxxx",
Column2: "xxxx",
...
}
)
Best regards,
