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)

IDInvoiceNumberCustomerNameTotalAmountCurrency
11001HYK Group Limited


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


Output

Customer Invoices (SharePoint List)

IDInvoiceNumberCustomerNameTotalAmountCurrency
11001HYK 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
    }
)