PATCH A SharePoint Single Line Text Column In Power Apps



Goal

Change the Address column (Single Line Text Type) from “123 Fake Street” to “456 Ocean Avenue”


Input

Customer Locations (SharePoint List)

IDCustomer NameAddress
1XYZ Widgets Company123 Fake Street


Patch Function Code
Patch(
    'Customer Locations',
    LookUp('Customer Locations', ID=1),
    {
        Address: "456 Ocean Avenue"
    }
)


Output

Customer Locations (SharePoint List)

IDCustomer NameAddress
1XYZ Widgets Company456 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
    }
)