Patch function need Help please

(0) Share

Report

Posted on by Xeon0021

116

Hello,

I need help in the usage of the Patch function please.

My goal is to override a field in a database table with the value "not available" if another field is not empty.

This shall happen after a form is submitted and the code I have so far is on the Onselect Property of a button:

UpdateContext({EME_MitarbeiterVar:DataCardValue56});
SubmitForm(EditMitarbeiterEinheitForm);
If(EME_MitarbeiterVar <> "", Patch(Einheit, Defaults(Einheit), {Status:"Vergeben"}));
Back();

I am not quit sure also how I can define the dataset I want to update in the Patch function because I think like this it would override all datasets, doesnt it?

Any help is much appreciated!

best regards Leon

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (1)

Verified answer

Rajkumar_M 3,747 Moderator on at

Like (1)

Report
Copy link

Link copied!

Hi

Plz try this

UpdateContext({ EME_MitarbeiterVar: DataCardValue56 });
SubmitForm(EditMitarbeiterEinheitForm);
If(EME_MitarbeiterVar <> "",
Patch(
Einheit,
LookUp(Einheit, YourConditionHere),
{ Status: "Vergeben" }
)
);
Back();

(Or)

UpdateContext({EME_MitarbeiterVar:DataCardValue56}); SubmitForm(EditMitarbeiterEinheitForm); If(!IsBlank(EME_MitarbeiterVar), Patch(Einheit, LookUp(Einheit, ID = EditMitarbeiterEinheitForm.LastSubmit.ID), {Status:"not available"})); Back();

Thanks!

If my response has been helpful in resolving your issue, I kindly request that you consider clicking "Accept as solution" and "giving it a thumbs up" as a token of appreciation.

Was this reply helpful? Yes No
Xeon0021 116 on at

Like (1)

Report
Copy link

Link copied!

Hello @Rajkumar_404 ,

thanks a lot, the second option is working for me!!

best regards

Was this reply helpful? Yes No