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
}
)
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)
}
)
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
}
)
Did You Enjoy This Article? 😺
Subscribe to get new Power Apps articles sent to your inbox each week for FREE