You’re offline. This is a read only version of the page.
37
Hello all,
Please may i know how to update all the values present in SharePoint list at a time through power apps.
Refer the above image for the requirement.
Thank yoo.
Hi @ravi123,
I did some testing and had similar results for the UpdateIf & ForAll(Patch()) alternative. (+- 20sec for 40 records)
Another option is collecting your datasource, making the changes there and using Patch(ListName, colName) to bulk update your records. However, in the case of updating 40 records it actually performed worse in my test scenario. A guide on this can be found here.
As a faster alternative, I would recommend using a Power Automate flow that is started by the press of a button within the app (Instant cloud flow).
I hope this helps!
Hi @LaurensM This formula worked for me thank you.
I have a follow-up question ?
In fact i'm using this app inside the Context of PowerBi. When i input the value and submit in app, it is taking quite a long time to update the SP list(List Count =40 only).So may i know how to improve the refresh rate in terms of write back to the SP List.
Thank you.
Hi @ravi123, this would mean that all records within the list should have the new value for that column.
You could use an UpdateIf statement to achieve this:
Share
Report
All responses (
Answers (
UpdateIf(ListName, true, {ColumnName: txtInput.Text})
Please update ListName with your SP list, ColumnName with the name of the value column and TextInput with the name of your text input control.
If it is a number column you might need to adjust it slightly with a Value() around the TextInput:
UpdateIf(ListName, true, {ColumnName: Value(txtInput.Text)})
If this solves your question, would you be so kind as to accept it as a solution.
Thanks!
