Showing results for 
Search instead for 
Did you mean: 
Helper V
Helper V

Patch SQL, Want to Update an Record, Not Create a New One

Hi, using the following code I was aiming to update a record, not create a new one.  When I edit the record, let's say the first one (e.g. St. Louis, Company_ID 1), and I change it to Las Vegas, it creates a new record.  


What do I need to modify to simply update?  Also, what other code can I add in to return back to the detail/display screen for that record?


Thanks for any assistance!!


Patch('[dbo].[table1]', Defaults('[dbo].[table1]'), {City: DataCardValue318.Text})




SQL Dropdown Hi, thank you for assisting with the PowerApps SQL issue I was having. It works awesome on the text fields.


For some reason, and I'm 100% confident this is my own lack of experience issue, is the dropdowns do not update. Again, I do not know how to do it correctly.


  • Here's how I list the items in a dropdown that I created in the edit screen for the company name
    • ShowColumns('[dbo].[company]', "Company_Name", "ID"
  • For the update, I have the following code
    • Form_Detail_Audit_Company_Company_DataCardValue.Selected.ID Once I save/close the edit screen, it does not update the detail/display field and definitely not the SQL.

Thanks again for your help earlier and I apologize if I made more issues for myself!

Helpful resources

Power Apps News & Annoucements carousel

Power Apps News & Announcements

Keep up to date with current events and community announcements in the Power Apps community.

Community Call Conversations

Introducing the Community Calls Conversations

A great place where you can stay up to date with community calls and interact with the speakers.

Power Apps Community Blog Carousel

Power Apps Community Blog

Check out the latest Community Blog from the community!

Top Solution Authors
Top Kudoed Authors
Users online (1,593)