Updating a SharePoint Number Column in Power Apps
In this tutorial, we’ll explore how to effectively patch or update the “number column” in SharePoint using Power Apps. Modifying columns in SharePoint through Power Apps is essential, especially for those working on dynamic applications. Whether you have a text input, dropdown, or slider, this guide will illustrate how to update the number column with ease.
Objective
Our main aim is to update the Score column, which is of the “number column” type, from 55 to 80 in our SharePoint list.
Initial Data
Consider the following Test Scores from our SharePoint List:
| ID | Student Name | Score |
|---|---|---|
| 1 | Samuel Wright | 55 |
Patching the Number Column
Patch(
'Exam Results',
LookUp('Exam Results', ID=1),
{
Grade: 80
}
)
Expected Result
Post-patching, our SharePoint List should reflect the following changes:
| ID | Student Name | Score |
|---|---|---|
| 1 | Samuel Wright | 80 |
Advanced Scenarios
Beyond direct patching, there are different scenarios where we might want to fetch values from different user inputs:
Scenario #1: Text Input
To patch a value from a text input to a number column:
Patch(
'Exam Results',
LookUp('Exam Results', ID=1),
{
Grade: Value(TextInput_Grade.Text)
}
)
Scenario #2: Dropdown
To patch a value from a dropdown menu to a number column:
Patch(
'Exam Results',
LookUp('Exam Results', ID=1),
{
Grade: Dropdown_Grade.Selected.Value
}
)
Scenario #3: Slider
To patch a value using a slider for the number column:
Patch(
'Exam Results',
LookUp('Exam Results', ID=1),
{
Grade: Slider_Grade.Value
}
)
If you find any challenges implementing the above solutions or need further assistance related to SharePoint, Power Apps, or any other technical query, feel free to contact us. Our team at SoftwareZone365 is here to help, guide, and potentially offer our expert services to address your needs.
Additional Insights:
Many organizations have started to ‘Update SharePoint Number via Apps‘ because it simplifies the process of modifying list data. This technique doesn’t just enhance workflow efficiency; it also ensures a higher degree of accuracy. By integrating Power Apps, businesses can eliminate the complexities of traditional coding methods. As a result, even those without extensive technical backgrounds can swiftly make necessary adjustments, leading to smoother operations and improved data integrity.
Conclusion
Updating SharePoint’s number column using Power Apps is a straightforward process once you understand the patching mechanism. Whether you’re using text input, dropdowns, or sliders, with the proper code, you can seamlessly update your SharePoint lists. Always remember to test your implementations, and don’t hesitate to reach out for any assistance. We’re here to help!
