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
}
)
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
}
)
Did You Enjoy This Article? 😺
Subscribe to get new Power Apps articles sent to your inbox each week for FREE