Unanswered

PowerApps patch(update a record) beginner

(0) Share

Report

Posted on by Community Power Pla...

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.

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

I think i'd need something simular to this. Any help/questions are welcome. I know this is a scattered post i am just very stuck.

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (0)

Community Power Pla... on at

Like (0)

Report
Pseudo code of what im trying to do based on SQL code.
UPDATE table3 SET reason_category_id = id_reason_category_dropdown WHERE two.name = two_name_dropdown.SelectedValue

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.

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

Any mod available for help? @v-jefferni @v-dezhili-msft @v-qiaqi-msft @v-liwei-msft I am really stuck here.

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

Needed support. Anyone know anything?

Was this reply helpful? Yes No