Hi @jeffgreenrc ,
Is there any error message shown up when you executes these "Update" formulas?
Is this "Amount" field a Read-Only type column in your D365 F&O table?
If you want to use Patch function to update the "Amount" field in your canvas app, please take a try with the following formula:
Patch(
'Your Table',
LookUp('Your Table', PrimaryColumn = "Specific value"), // Find the record you want to update
{
AmountField: Value(AmountTextInputBox.Text)
}
)
If you want to use UpdateIf function to update amount field value, please try the following formula:
UpdateIf(
'Your Table',
PrimaryColumn = "Specific Value",
{
AmountField: Value(AmountTextInputBox.Text)
}
)
Please check if the "Amount" field a Read-Only type column in your D365 F&O table, if true, you could not update this field from your canvas app. Also please make sure you have Edit permission to the added D365 F&O table data source.
Best regards,