PATCH A SharePoint Number Column In Power Apps



Goal

Change the Score column (Number type) from 55 to 80


Input

Test Scores (SharePoint List)

IDStudent NameScore
1Samuel Wright55


Patch Function Code
Patch(
    'Test Scores',
    LookUp('Test Scores', ID=1),
    {
        Score: 80
    }
)


Output

Test Scores (SharePoint List)

IDStudent NameScore
1Samuel Wright80



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)
    }
)



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
    }
)



Scenario #3: Slider

Patch a value found in a sliderto a Number field.



Patch Function Code
Patch(
    'Test Scores',
    LookUp('Test Scores', ID=1),
    {
        Score: Slider_Score.Value
    }
)