cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
AlesonITC Helper II
Helper II

Update data on SQL with form submit

Hi, I have got an SQL table with this columns for example:

 

ID

Month

Price1

Price2

 

Where pk is ID + Month.

Then I got 200 rows with data. When I tap or click in some row, and press "edit" button, it navigates to another screen with a form with the data of the row tapped or clicked loaded. The next step would be change "Price1" or "Price2" and submit the form to update the row. 

 

When I do it, it says that there are a registry with this pk because it tries to insert a new row with the data I wrote instead of modify the existent row.

 

Anyone knows how can I update the row instead of insert a new one with the editform?

 

Thx a lot. Regards.

Helpful resources

Announcements
firstImage

New Ranks and Rank Icons released on April 21!

The time has come: We are finally able to share more details on the brand-new ranks coming to the Power Apps Community!

Power Platform 2020 release wave 1 plan

Power Platform 2020 release wave 1 plan

Features releasing from April 2020 through September 2020

Top Solution Authors
Top Kudoed Authors
Users online (7,881)