Announcements
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.
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. 😃
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
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"})
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
Congratulations to our 2026 Super Users!
Congratulations to our 2025 community superstars!
These are the community rock stars!
Stay up to date on forum activity by subscribing.
Haque 88
WarrenBelz 85 Most Valuable Professional
Valantis 45