PATCH A SharePoint Single Line Text Column In Power Apps

Imported reference from Matthew Devaney's blog for learning purposes. Original: https://www.matthewdevaney.com/power-apps-patch-function-examples-for-every-sharepoint-column-type/patch-a-sharepoint-single-line-text-column-in-power-apps/. Author: Matthew Devaney.

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) 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" } ) Code language: JavaScript ( javascript ) 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 } ) Code language: JavaScript ( javascript ) 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 } ) Code language: JavaScript ( javascript ) Did You Enjoy This Article? 😺

Subscribe to get new Copilot Studio articles sent to your inbox each week for FREE Enter your email address Sign Me Up