Skip to main content

Notifications

Power Apps - Building Power Apps
Unanswered

How can we update multiple records in single update statement

(0) ShareShare
ReportReport
Posted on by

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.

  • Bahalzamon Profile Picture
    Bahalzamon on at
    Re: How can we update multiple records in single update statement

    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"})

  • devipriyanka Profile Picture
    devipriyanka on at
    Re: How can we update multiple records in single update statement

    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

  • Bahalzamon Profile Picture
    Bahalzamon on at
    Re: How can we update multiple records in single update statement

    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. 😃

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.

Helpful resources

Quick Links

Microsoft Kickstarter Events…

Register for Microsoft Kickstarter Events…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Announcing Forum Attachment Improvements!

We're excited to announce that attachments for replies in forums and improved…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 145,636

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 64,942

Leaderboard