Hi @SyedAli,
Could you please share a screenshot about your app's configuration?
Further, could you please share more details about the Update property of the Data card which is not updated back to your SQL table?
I have made a test on my side, and don't have the issue that you mentioned. Please check if you have provided proper value for the corresponding column (on your side, it is the Numeric column).
I also agree with @Meneghino's thought almost, you could also consider take a try to convert your Numeric column into a Decimal or Money type column, and then re-create an app based on your SQL table, check if the issue is solved.
In addition, please also take a try to use Patch function to save your form data into your SQL table instead of SubmitForm function. The standard formula of Patch function as below:
Patch(
YourSQLTable,
Defaults(YourSQLTable),
{
Column1:DataCardValue1.Text,
Column2:DataCardValue2.Text,
...
}
)
Please modify your formula within the OnSelect property of the "Submit" button as below:
If(
EditForm1.Mode=FormMode.New,
Patch( /* <-- New record */
'YourSQLTable',
Defaults('YourSQLTable'),
{
Column1:DataCardValue1.Text,
Column2:DataCardValue2.Text,
...
}
),
Patch( /* <-- Modify an existing record */
'YourSQLTable',
BrowseGallery1.Selected,
{
Column1:DataCardValue1.Text,
Column2:DataCardValue2.Text,
...
}
)
)
then check if the issue is solved.
More details about the Patch function in PowerApps, please check the following article:
Patch function
Best regards,
Kris
