PowerApps patch(update a record) beginner

[Anonymous]

Goodday all(

, I am a beginner in PowerApps and i am also very new to the coding side of PA. I am trying to currently use a patch function to update my table.

See example ERD of tables used.

I am trying to update table Three.
I want to insert Reason_Category.reason_category_id into table three. It is currently empty due to this being manually selected in the PowerApp i am making.
See below example of the powerapp.

I want to insert reason_category_id into table 3 on submit button where two_name ='two_name_dropdown'.Selected.name

Any more data/information needed let me know.
Pseudo code in SQL style:

UPDATE table3
SET reason_category_id = id_reason_category_dropdown
WHERE two.name = two_name_dropdown.SelectedValue

I think i'd need something like shown below.

Patch(
'DD.two',
Lookup('two', name:'two_name_dropdown'.Selected.name),
{???:'???'.Text}
)

Any help/questions are welcome. I know this is a scattered post i am just very stuck.
Problem 2:
Another issue i can't seem to get the reason id correct.
in this instance reason cat 2 and 3 are empty and when empty instead of giving the reason id it gives a 1.
Any way to be garantueed to get the correct id? I am so confused by some of this.
See below:

[Anonymous]

Good morning,
I have looked into the issue and found it had to do with how the relationships are setup.
I saw some issues with the code i had previously. New code:

Patch(
   'DD.product_subunit_batch_step_timeloss', 
   LookUp(
      'DD.product_subunit_batch_step_timeloss',
      batch_cycle_id = dataholder_batch_cycle_id.Selected.batch_cycle_id
   ), 
   {reason_category_id: input_reason_category_id}
)

This fixed all errors except for the read-only error. I will try and look at this with the Database admin. Thanks i think this code above sorts the button though. I had to add some dependent dropdowns as data placeholders to be able to make this work.
Apperently there were no specified PK's.
I've fixed this.
New error and the only error left:
When i click the submit button while having all data spots filled i get this error. I only found where it says that people refreshed their powerapp and it was fixed this sadly did not fix it for me.

[Anonymous]

Hi @BCBuizer are u familiar with the issue shown below?

It happends when trying to run my Patch button in the powerapp.

[Anonymous]

Hi @BCBuizer , I figured out what it has to do with:

Patch(
   'DD.product_subunit_batch_step_timeloss', 
   LookUp(
      'DD.product_subunit_batch_step_timeloss',
      batch_cycle_id = dataholder_batch_cycle_id.Selected.batch_cycle_id
   ), 
   {reason_category_id: input_reason_category_id".?"}
)

See ".?"
If i enter .Text i get this error

If i enter nothing i get the error:

So im assuming it has to do with this part of the code. Any support?

No good suggested value here.  Is my code just wrong?

[BCBuizer · Accepted solution]

Hi @Anonymous ,

If input_reason_category_id has a numerical value, you can use the Value function to convert the type from text to number:

Patch(
   'DD.product_subunit_batch_step_timeloss', 
   LookUp(
      'DD.product_subunit_batch_step_timeloss',
      batch_cycle_id = dataholder_batch_cycle_id.Selected.batch_cycle_id
   ), 
   {reason_category_id: Value(input_reason_category_id.Text)}
)

[Anonymous]

Hi, Im sorry i made a new post to sepperate the issues. I had indeed found that out by someone else check:
Re: Network error patch function - Page 3 - Power Platform Community (microsoft.com) Thanks anyways. I still have errors and could really use your help.