Hi @Anonymous ,
Could you please share more details about the error message within your app?
Have you set Not Null property for some fields in your Azure SQL Table?
I have made a test on my side, and don't have the issue that you mentioned. Please check if you have set Not Null property for some fields in your Azure SQL Table, if true, please make sure you have provided valid values for these fields in your Edit form.
In addition, please also consider remove the connection from your app, then re-create a new connection to your Azure SQL Table, then try your app again, check if the issue is solved.
If the issue still exists with the SubmitForm() function, as an alternative solution, you could consider submit your form data using Patch function instead of SubmitForm() function. Please set the OnSelect property of the "Submit" button to following:
If(
EditForm1.Mode = FormMode.New,
Patch( /* <-- Add new record */
'YourSQLTable',
Defaults('YourSQLTable'),
{
Column1: DataCardValue1.Text,
Column2: DataCardValue2.Text,
...
}
),
Patch( /* <-- Modify existing record */
'YourSQLTable',
BrowseGallery1.Selected,
{
Column1: DataCardValue1.Text,
Column2: DataCardValue2.Text,
...
}
)
);
If(
IsEmpty(Errors('YourSQLTable')),
Back()
)
Note: The DataCardValue1, DataCardVlaue2, ... represents the Data Card Value boxes within your Edit form.
Please take a try with above solution, then check if the issue is solved.
More details about the Patch function, please check the following article:
Patch function
Bets regards,
