PATCH A SharePoint Number 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-number-column-in-power-apps/. Author: Matthew Devaney.

PATCH A SharePoint Number Column In Power Apps Goal

Change the Score column (Number type) from 55 to 80 Input Test Scores (SharePoint List) ID Student Name Score 1 Samuel Wright 55 Patch Function Code Patch(

'Test Scores' , LookUp( 'Test Scores' , ID= 1 ), { Score : 80 } ) Code language: JavaScript ( javascript ) Output Test Scores (SharePoint List) ID Student Name Score 1 Samuel Wright 80 Scenario #1: Text Input

Patch a value found in a text input to a Number field. Patch Function Code Patch(

'Test Scores' , LookUp( 'Test Scores' , ID= 1 ), { Score : Value(TextInput_Score.Text) } ) Code language: JavaScript ( javascript ) Scenario #2: Dropdown

Patch a value found in a dropdown to a Number field. Patch Function Code Patch(

'Test Scores' , LookUp( 'Test Scores' , ID= 1 ), {

Score : Dropdown_Score.Selected.Value } ) Code language: JavaScript ( javascript ) Scenario #3: Slider

Patch a value found in a slider to a Number field. Patch Function Code Patch(

'Test Scores' , LookUp( 'Test Scores' , ID= 1 ), { Score : Slider_Score.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