How to Update all the values of SharePoint column at a time through Power Apps

(0) Share

Report

Posted on by ravi123

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.

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (1)

Verified answer

LaurensM 12,516 Moderator on at

Like (0)

Report
Copy link

Link copied!
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:

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!

Was this reply helpful? Yes No
ravi123 37 on at

Like (0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
LaurensM 12,516 Moderator on at

Like (0)

Report
Copy link

Link copied!

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!

Was this reply helpful? Yes No
ravi123 37 on at

Like (0)

Report
Copy link

Link copied!

Hai @LaurensM
Updateif formula is working fine with the Text input control.
What if i want to use Dropdown instead of Text input. May i know the formula for this ?.
Thank you !..

Was this reply helpful? Yes No