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

Announcements

News and Announcements icon
Community site session details

Community site session details

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

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!

Screenshot_4.png
I have the same question (0)
  • Verified answer
    Michael E. Gernaey Profile Picture
    53,960 Moderator 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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Users!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 76 Most Valuable Professional

#2
Haque Profile Picture

Haque 69

#3
Kalathiya Profile Picture

Kalathiya 38 Super User 2026 Season 1

Last 30 days Overall leaderboard