Answered

Updating multiple rows at the same time

(1) Share

Report

Posted on by Ansu8371

Hi,

I have a table named "Automobile" where I have different columns ID, DPT and Department. I have to update the multiple rows in "Department" which has same value in another column "DPT". I need help for getting each steps to update multiple rows at the same time. For example:

ID	DPT	Department
1	HR
2	HR
3	HR
4	CLM
5	CLM
6	CLM
7	MKT
8	FIN
9	FIN
10	FIN
11	FIN
12	FIN

It should be updated like:

ID	DPT	Department
1	HR	Human Resource
2	HR	Human Resource
3	HR	Human Resource
4	CLM	Claim
5	CLM	Claim
6	CLM	Claim
7	MKT	Marketing
8	FIN	Finance
9	FIN	Finance
10	FIN	Finance
11	FIN	Finance
12	FIN	Finance

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (1)

Sort by

Daniel Bocklandt 5,151 Super User 2026 Season 1 on at

Like
a
(2)

Report
Copy link

Link copied!
Hey @Ansu8371 ,

To achieve this you would need a ForAll Loop. Be Aware, This will go through every Record in your table and update it
If you ant to do it only for some, we will need to adapt the formula.
ClearCollect(colAuto,Automobile); ForAll(colAuto, Pacth(Automobile, ThisRecord, {Department:Switch(ThisRecord.DPT, "HR", "Human Resource","CLM", "Claim", "MKT", "Marketing", "FIN","Finance)}))

Let me know if you have any questions.

Was this reply helpful? Yes No
Ansu8371 on at

Like
a
(1)

Report
Copy link

Link copied!

Thanks for the quick response DBO_DV.
I apologize if I haven't described clearly, my scenario is quite different, I have 20,000 rows of records and have 300 distinct values for the field which I need to update and not possible to use the above formula.

Was this reply helpful? Yes No
Verified answer

Daniel Bocklandt 5,151 Super User 2026 Season 1 on at

Like
a
(2)

Report
Copy link

Link copied!

Do you have a filter with whom you can limit those entries? Maybe if the department column is empty?

Was this reply helpful? Yes No
Ansu8371 on at

Like
a
(2)

Report
Copy link

Link copied!

Thank you, it works now. I have used the following formula:

ClearCollect(
RecordsToUpdate,
Filter(
'dbo.Automobile',
DPT = DPTValue.Text
)
);
ForAll(
RecordsToUpdate,
Patch(
'dbo.Automobile',
ThisRecord,
{Department: DepartmentValue.Text} // Use the text input value
)
);
PowerBIIntegration.Refresh(); Notify("Records updated successfully", NotificationType.Success);

Was this reply helpful? Yes No