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

(0) Share

Report

Posted on by Gjoni23

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!

Categories:

Microsoft Dataverse

Screenshot_4.png

All responses (1)

Answers (1)

Verified answer

Michael E. Gernaey 42,456 Super User 2025 Season 1 on at

Like (1)

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

@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