PATCH A SharePoint Currency Column In Power Apps

Goal

Change the TotalAmountCurrency column (Currency type) from blank to $350.25

Input

Customer Invoices (SharePoint List)

ID	InvoiceNumber	CustomerName	TotalAmountCurrency
1	1001	HYK Group Limited

Patch Function Code

Patch( 'Customer Invoices', LookUp('Customer Invoices', ID=1), { TotalAmountCurrency: 350.25 } )Code language: JavaScript (javascript)

Output

Customer Invoices (SharePoint List)

ID	InvoiceNumber	CustomerName	TotalAmountCurrency
1	1001	HYK Group Limited	$320.25

Scenario #1: Text Input

Patch a value found in a combo box to a Currency field.

Patch Function Code

Patch( 'Customer Invoices', LookUp('Customer Invoices', ID=1), { TotalAmountCurrency: TextInput_TotalAmount.Text } )Code language: JavaScript (javascript)