Unanswered

How can we update multiple records in single update statement

(0) Share

Report

Posted on by devipriyanka Microsoft Employee

We have multiple records which need to updated in a CDS table from canvas app. Can we update all the records with different values at once without using for all.
Kindly help us with solution.
Thanks in advance.

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (0)

Bahalzamon on at

Like (0)

Report
Copy link

Link copied!

Hey @devipriyanka

I would suggest UpdateIf, this will update all the matching records.
https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/functions/function-update-updateif

fi you want to change everything just make the condition True, otherwise you can add multiple statements.
UpdateIf(DataSource, Or(condition1, condition2, etc...),{Field1:"asdf", Field2: 5,etc...})

this way you can expand its selection or limit it how you like. 😃

Was this reply helpful? Yes No
devipriyanka Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Thank you @Bahalzamon,
Here we have a collection of records which are around 20 that need to be updated. Can we do it with UpdateIf.
Please help

Was this reply helpful? Yes No
Bahalzamon on at

Like (0)

Report
Copy link

Link copied!

Definitely, you could modify the entire dataset so be careful (safety third) 😋
This is the first sentence from the documentation I provided in my last post just so you can see the official MS info. 😃
Use the UpdateIf function to modify one or more values in one or more records that match one or more conditions.

So for example if you just want 1 item use something like its ID, but if you want all records assigned to Bob to be assigned to Frank: UpdateIf(DataSource, Assigned="Bob",{Assigned:"Frank"})

Was this reply helpful? Yes No