web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / Using patch to update ...
Power Apps
Unanswered

Using patch to update table in dataverse but it is not updating

(0) ShareShare
ReportReport
Posted on by 33

Hi!

 

i am using Dataverse Table to add data to table and in canvas app i am using the patch function but when i save the data it is adding a new row instead of updateing the data please help!

I have the same question (0)
  • Verified answer
    Michael E. Gernaey Profile Picture
    53,335 Super User 2025 Season 2 on at

    @Gjoni23 

     

    The answer is your code is only good for creating new records really.

     

    You need to change the Defaults(Table) to be a lookup to the Row to update.

    If The Gallery is the row then put GalleryName.Selected instead. If not find a column to match on in  a  lookup

     

    New
    
    Patch(Table, Defaults(Table)
    
    Update
    Patch(Table, LookUp(Table, Column = "", {})


    If I have helped you, I would really appreciate if you please Mark my answer as Resolved/Answered, and give it a thumbs up, so it can help others

    Cheers

    Thank You
    Michael Gernaey MCT | MCSE | MCP | Self-Contractor| Ex-Microsoft
    https://gernaeysoftware.com
    LinkedIn: https://www.linkedin.com/in/michaelgernaey

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

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 717 Most Valuable Professional

#2
Michael E. Gernaey Profile Picture

Michael E. Gernaey 329 Super User 2025 Season 2

#3
Power Platform 1919 Profile Picture

Power Platform 1919 268

Last 30 days Overall leaderboard