Goal
Change the Address column (Single Line Text Type) from “123 Fake Street” to “456 Ocean Avenue”
Input
Customer Locations (SharePoint List)
ID | Customer Name | Address |
1 | XYZ Widgets Company | 123 Fake Street |
Patch Function Code
Patch(
'Customer Locations',
LookUp('Customer Locations', ID=1),
{
Address: "456 Ocean Avenue"
}
)
Output
Customer Locations (SharePoint List)
ID | Customer Name | Address |
1 | XYZ Widgets Company | 456 Ocean Avenue |
Scenario #1: Text Input
Patch a value found in a text input to a Single Line Text field.
Patch Function Code
Patch(
'Customer Locations',
LookUp('Customer Locations', ID=1),
{
Address: TextInput_Address.Text
}
)
Scenario #2: Dropdown
Patch a value found in dropdown to a Single Line Text field.
Patch Function Code
Patch(
'Customer Locations',
LookUp('Customer Locations', ID=1),
{
Address: Dropdown_Address.Selected.Value
}
)
Did You Enjoy This Article? 😺
Subscribe to get new Power Apps articles sent to your inbox each week for FREE