PowerApps patch(update a record) beginner

[DvdH]

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:

[BCBuizer]

 @DvdH ,

For the first issue:

You mentioned you want to insert a new item in Three with the Patch function. To achieve that you need enter the Defaults function as the second argument:

Patch(
   DD.Three,
   Defaults(DD.Three),
   {three_id: ____,
    SecondColumn: ____,
    LastColumn: ____}
)

More information on the Patch function can be found here: https://learn.microsoft.com/en-us/power-platform/power-fx/reference/function-patch

I think the second issue got resolved here: https://powerusers.microsoft.com/t5/Building-Power-Apps/Dependant-dropdown-issue/m-p/1965537

[DvdH]

I am sorry i might not of explained it properly. I want to update a row in table two where two_id = two_id_dropdown.Selected.Value.
I want to fill the empty column "reason_category_id" with reason_category_id_dropdown.Selected.Value where two_id = two_id_dropdown.Selected.Value.


Thanks for all your support. This post is a bit older and some things have changed but this reply should make my problem clear.

[BCBuizer]

Hi @DvdH ,

To update an exsting item in DD.Two where the two_id = two_id_dropdown.Selected.Value, and save the value of reason_category_id_dropdown.Selected.Value in the 'reason_category_id column', use:

Patch(
   DD.Two, 
   LookUp(
      DD.Two,
      two_id = two_id_dropdown.Selected.Value
   ), 
   {reason_category_id: reason_category_id_dropdown.Selected.Value}
)

[DvdH]

@BCBuizer Edited responds due to fixing error but finding different issues:
For the submit button i got this issue:

Patch(
   'DD.product_subunit_batch_step_timeloss', 
   LookUp(
      'DD.processorder_id',
      processorder_id = processorder_id_name_dropdown.Selected.processorder_id
   ), 
   {reason_category_id: input_reason_category_id.Text}
)

I at first didnt share any table names but i think these are fine. I confuse myself if i rename them so i will just use the names.

The powerapp is connected to the data but might be write-only. How do enable permission for powerapps to edit tables in the database? I have admin rights to the sql server.

[BCBuizer]

Hi @DvdH,

Usually there's no decimal in the Data Source name. The reason I left it in there is because that's what you provided and what seemed to be accepted in other topics. Try removing "DD.":

Patch(
   processorder_id, 
   LookUp(
      processorder_id,
      full_processorder_id = processorder_id_name_dropdown.Selected.Value
   ), 
   {reason_category_id: input_reason_category_id.Text}
)

[DvdH]

Hi i found the issue. At first i did try that and remove DD. but it is the table name. The ERD shown is not the actual table name since it was a moqup.
I had to just put the table names in singuler quotes and it worked. Other issue was found. Can u check last post? I edited it.

[BCBuizer]

Hi @DvdH ,

Good to read you got this issue resolved.

For information on the new issue that appeared, please have a look around first before bringing it up in this topic. I found some suggestions for a similar error in this topic: https://powerusers.microsoft.com/t5/Building-Power-Apps/The-data-source-is-read-only-error/td-p/3146...

[DvdH]

Thanks, i did find that post and i can create new rows with the connected account in the SQL location. This should mean that the account has the correct permissions i assume. If not how do i check it? I also refreshed all tables in the powerapps and i restarted the SQL management servers. Since this is how it was fixed for that topic i was hoping it would work for me aswell. Sadly it doesn't and i couldn't find where to see which account is connected. I think it is the admin account but would love to double check this. Also couldn't find where to see it on google.

[DvdH]

Thanks for your help. I will post an update of this post tomorrow. I am currently working from home and sick. My brain can not put this info together I think i've found the main problem with this patch run. I will repost about this tomorrow if i do not find anything online. If i find a solution myself i will post it aswell.
Thanks @BCBuizer and anyone who read this.