Inserting new row or Updating existing values in columns in sql table having primary key using PowerApp

[Raja23]

Hi Team,

I am new to this PowerApps and stuck with one scenario. Can you please help me out with this
My data source is sql server and in there i have a composite primary key formed on 3 columns (jobid, connection_id, trigger_name), there are other columns as well in the table.
My objective is to update any existing row in the sql table or insert any new row into the table.
Following are the 2 problems I am facing:
a) During update:
i) I am able to update all columns except for the primary key columns. Which is okay as ideally we should not update primary key but what if I want to do that?
ii) I am getting following error if I update jobid or connection_id
Network Error when using Patch function, specified record not found.
Following is the code am using
As there are multiple columns in the gallery, OnChange property of these columns calls a button which has below code on “onSelect” property

If (
    IsBlank(
        LookUp(
            colgridupdates,
            job_id = ThisItem.job_id
        )
    ),
    Collect(
        colgridupdates,
        ThisItem
    )
);
UpdateIf(
    colgridupdates,
    job_id = ThisItem.job_id,
    {
        job_id: Value(txtjob_id.Value),
        job_name: txtjob_name.Value,
        job_trigger_name: txtjob_trigger_name.Value,
        source_connection_id: Value(txtsource_connection_id.Value),
        send_email_to: txtsend_email_to.Value,
        metadata_updated_ts: DateTimeValue(txtmetadata_updated_ts.Value),
        is_job_disabled: chkis_job_disabled.Value
    }
)

Have another button which is Save button where user will click after making changes to existing row in Gallery.

OnSelect property of this button-following is the code

Patch('config.powerapp_job_config',ShowColumns(colgridupdates,"job_name","send_email_to","metadata_updated_ts","is_job_disabled","job_trigger_name","source_connection_id","job_id"));
Notify("Grid updated successfully",NotificationType.Success,3000);
Clear(colgridupdates);
Set(varReset,false);
Set(varReset,true);

b) During Insert:
i) I am able to insert a row in SQL table but it gets inserted with default values in key columns as well-which I can’t update because of above mentioned reason.
ii) If I need to insert a row, I need to allow myself to update any column or insert the rows with correct value , not with default ones
There is another button named as "New" which has following code on "OnSelect" property: 

Patch(
colgridupdates,Defaults(colgridupdates),
{job_id:00000,source_connection_id:00000,job_trigger_name:”default”,target_connection_id:00000}
);
Set(varReset,false);
Set(varReset,true)

Kindly suggest!

[Raja23 · Accepted solution]

Solved it by using a global variable.

Stored the previous value or original value in the variable than inside patch function used a lookup where compared value in table with the value of variable, since that matches, able to update all the columns.