line code execution

[Fado]

Hi Dears,

I have a button that has too many code lines and all of them are connected to do a certain purpose,

my concern is the interruption happens when the user closes the web browser or navigating to another screen after pressing the button, some of the code gets executed and the rest of the code gets ignored which leads to uncompleted code execution 

I am looking for something that is similar to what we already have in C# and SQL the "begin transactions and end transactions"

or something to run the whole code once the button is pressed without interruption.

any help will be appreciated 

Thank you 

[RandyHayes]

@Fado 

Since PowerApps is no where like a development platform like C# you will need to work with the concepts of PowerApps.  In general a lot of "actions" in an action formula should be avoided.  But, if you have something like this and have no other way to design around it, then you will need to consider more interaction with the user...things like "Processing x...Please wait" messages etc.

As well, you can also utilize the ConfirmExit actions of the App to inform the user that actions are in process or some other notice.

Is for rolling back transactions, this can easily be done by combining the OnSuccess actions of your Forms and then a rollback path for OnFailures.  But I have a feeling that forms are not a part of your app.

So, beyond that, I would consider (if this is so intensive and must be rolled back on failure) to utilize a Flow in PowerAutomate to do the work that you need and rollback as necessary.

I hope this is helpful for you.

[Fado]

Thank you for such a reply, the forms are not included in my solution the below code is from my submit button, any ideas, please 

UpdateContext({popup:true});
Set(
SubmitrecordID,
Patch(
Vacation_List,
Defaults(Vacation_List),
{
Title:ComboBoxName.Selected.Names,
RequestType: "Vacation",
JobTitle: JobTitle_F.Text,
Employee_Number: EmployeeNumber_F.Text,
Employee_Grade: EmployeeGrad_F.Text,
Dept: EmployeeDept_F.Text,
Branch: EmployeeBranch_F.Text,
WeeklyHoliday:WeeklyHoliday_F.Text,
RequestDate: Applieddate_F.SelectedDate,
RequestDateFrom: StartDate_p.SelectedDate,
RequestDateTo: EndDate_p.SelectedDate,
Days_difference: DateDifference.Text,
VacationType: DropdownVacationType.SelectedText.Value,
CurrentBalance: CurrentBalance_F.Text,
Remaining_Balance: remaining_Balance_F.Text,
Request_Note:RequesterNoteVacation.Text,
ItemStatus:"Pending",
Alternative_Employee:AlternativeEmployee_F.SelectedText.Name
}
).ID
);
//Lock The Vacation to be applied one at time

Patch(Users_List,LookUp(Users_List,ComboBoxName.Selected.Names=Names),{LockRecord:"Locked"});
//SubmitForm([@Attachment_Form]);

// sending notification Using SMTP Connectors and append the staus of the form

//IT Case-Supervisor
If(EmployeeDept_F.Text="IT",Set(ApproverEmailName,"Akam Ahamad");
SMTP.SendEmailV3({from:"portal@nivatransport.com",To:"fadi.ahdab@nivaoil.com",Subject:"Vacation Request",Body:HtmlText2.HtmlText});
Patch(Vacation_List,LookUp(Vacation_List,ID=SubmitrecordID),
{Stage:"Akam Ahmad Approval",DADisplayName:"Akam Ahmad",DAemail:"fadi.ahdab@nivatransport.com",CurrentApproved:"portal@nivatransport.com",Status:"CEO-V",CurrentApprover:"portal@nivatransport.com"});
// push notification via mobile to the dept maanager
PowerAppsNotification.SendPushNotification(
{
recipients: ["fadi.ahdab@nivatransport.com"],
message: "Vacation Request",
params: Table({key:"ItemID", value:SubmitrecordID}),
openApp: true
}
)
);

//Logstic Case-Employee
If(EmployeeDept_F.Text="Logistic"&& EmployeeGrad_F.Text<>"Manager",Set(ApproverEmailName,"Hawkar Wasman");
SMTP.SendEmailV3({from:"portal@nivatransport.com",To:"fadi.ahdab@nivaoil.com",subject:"Vacation Request",Body:HtmlText2.HtmlText});
Patch(Vacation_List,LookUp(Vacation_List,ID=SubmitrecordID),
{Stage:"Hawkar Wasman Approval",DADisplayName:"Hawkar Wasman",DAemail:"fadi.ahdab@nivatransport.com",CurrentApproved:"fadi.ahdab@nivatransport.com",Status:"DA1-V",CurrentApprover:"portal@nivatransport.com"});
// push notification via mobile to the dept maanager
PowerAppsNotification.SendPushNotification(
{
recipients: ["fadi.ahdab@nivatransport.com"],
message: "Vacation Request",
params: Table({key:"ItemID", value:SubmitrecordID}),
openApp: true
}
)
);

// Logstic Case-Manager
If(EmployeeDept_F.Text="Logistic"&& EmployeeGrad_F.Text="Manager",Set(ApproverEmailName,"Akam Ahmad");
SMTP.SendEmailV3({from:"portal@nivatransport.com",To:"fadi.ahdab@nivaoil.com",subject:"Vacation Request",Body:HtmlText2.HtmlText});
Patch(Vacation_List,LookUp(Vacation_List,ID=SubmitrecordID),
{Stage:"Akam Ahmad Approval",DADisplayName:"Akam Ahmad",DAemail:"fadi.ahdab@nivatransport.com",CurrentApproved:"fadi.ahdab@nivatransport.com",Status:"CEO-V",CurrentApprover:"portal@nivatransport.com"});
// push notification via mobile to the dept maanager
PowerAppsNotification.SendPushNotification(
{
recipients: ["fadi.ahdab@nivatransport.com"],
message: "Vacation Request",
params: Table({key:"ItemID", value:SubmitrecordID}),
openApp: true
}
)
);

//Finace Case-Employee
If(EmployeeDept_F.Text="Finance"&& EmployeeGrad_F.Text<>"Manager",Set(ApproverEmailName,"Debar Fariadoon");
SMTP.SendEmailV3({from:"portal@nivatransport.com",To:"fadi.ahdab@nivaoil.com",subject:"Vacation Request",Body:HtmlText2.HtmlText});
Patch(Vacation_List,LookUp(Vacation_List,ID=SubmitrecordID),
{Stage:"Fadi Ahdab Approval",DADisplayName:"Debar Faraidoon",DAemail:"fadi.ahdab@nivatransport.com",CurrentApproved:"fadi.ahdab@nivatransport.com",Status:"DA1-V",CurrentApprover:"portal@nivatransport.com"});
// push notification via mobile to the dept manager
PowerAppsNotification.SendPushNotification(
{
recipients: ["fadi.ahdab@nivatransport.com"],
message: "Vacation Request",
params: Table({key:"ItemID", value:SubmitrecordID}),
openApp: true
}
)
);

//Finace Case-Manager
If(EmployeeDept_F.Text="Finance"&& EmployeeGrad_F.Text="Manager",Set(ApproverEmailName,"Akam Ahmad");
SMTP.SendEmailV3({from:"portal@nivatransport.com",To:"fadi.ahdab@nivaoil.com",subject:"Vacation Request",Body:HtmlText2.HtmlText});
Patch(Vacation_List,LookUp(Vacation_List,ID=SubmitrecordID),
{Stage:"Akam Ahmad Approval",DADisplayName:"Akam Ahmad",DAemail:"fadi.ahdab@nivatransport.com",CurrentApproved:"fadi.ahdab@nivatransport.com",Status:"CEO-V",CurrentApprover:"portal@nivatransport.com"});
// push notification via mobile to the dept maanager
PowerAppsNotification.SendPushNotification(
{
recipients: ["fadi.ahdab@nivatransport.com"],
message: "Vacation Request",
params: Table({key:"ItemID", value:SubmitrecordID}),
openApp: true
}
)
);

// Service Case-Employee
If(EmployeeDept_F.Text="Service"&& EmployeeGrad_F.Text<>"Manager",Set(ApproverEmailName,"Sarmand ");
SMTP.SendEmailV3({from:"portal@nivatransport.com",To:"fadi.ahdab@nivaoil.com",subject:"Vacation Request",Body:HtmlText2.HtmlText});
Patch(Vacation_List,LookUp(Vacation_List,ID=SubmitrecordID),
{Stage:"Fadi Ahdab Approval",DADisplayName:"Akam Ahmad",DAemail:"fadi.ahdab@nivatransport.com",CurrentApproved:"fadi.ahdab@nivatransport.com",Status:"DA1-V",CurrentApprover:"portal@nivatransport.com"});
// push notification via mobile to the dept maanager
PowerAppsNotification.SendPushNotification(
{
recipients: ["fadi.ahdab@nivatransport.com"],
message: "Vacation Request",
params: Table({key:"ItemID", value:SubmitrecordID}),
openApp: true
}
)
);

// Service Case-Manager
If(EmployeeDept_F.Text="Service"&& EmployeeGrad_F.Text="Manager",Set(ApproverEmailName,"Akam Ahmad");
SMTP.SendEmailV3({from:"portal@nivatransport.com",To:"fadi.ahdab@nivaoil.com",subject:"Vacation Request",Body:HtmlText2.HtmlText});
Patch(Vacation_List,LookUp(Vacation_List,ID=SubmitrecordID),
{Stage:"Fadi Ahdab Approval",DADisplayName:"Akam Ahmad",DAemail:"fadi.ahdab@nivatransport.com",CurrentApproved:"fadi.ahdab@nivatransport.com",Status:"CEO-V",CurrentApprover:"portal@nivatransport.com"});
// push notification via mobile to the dept maanager
PowerAppsNotification.SendPushNotification(
{
recipients: ["fadi.ahdab@nivatransport.com"],
message: "Vacation Request",
params: Table({key:"ItemID", value:SubmitrecordID}),
openApp: true
}
)
);

// Gasoil-Employee+Manager
If(EmployeeDept_F.Text="Diesel Dept." && EmployeeGrad_F.Text<>"Manager",Set(ApproverEmailName,"Akam Ahmad");
SMTP.SendEmailV3({from:"portal@nivatransport.com",To:"fadi.ahdab@nivaoil.com",subject:"Vacation Request",Body:HtmlText2.HtmlText});
Patch(Vacation_List,LookUp(Vacation_List,ID=SubmitrecordID),
{Stage:"Akam Ahamad Approval",DADisplayName:"Akam Ahmad",DAemail:"fadi.ahdab@nivatransport.com",CurrentApproved:"fadi.ahdab@nivatransport.com",Status:"CEO-V",CurrentApprover:"portal@nivatransport.com"});
// push notification via mobile to the dept manager
PowerAppsNotification.SendPushNotification(
{
recipients: ["fadi.ahdab@nivatransport.com"],
message: "Vacation Request",
params: Table({key:"ItemID", value:SubmitrecordID}),
openApp: true
}
)
);

// Managment-Case
If(EmployeeDept_F.Text="Top Management",Set(ApproverEmailName,"Akam Ahmad");
SMTP.SendEmailV3({from:"portal@nivatransport.com",To:"fadi.ahdab@nivaoil.com",subject:"Vacation Request",Body:HtmlText2.HtmlText});
Patch(Vacation_List,LookUp(Vacation_List,ID=SubmitrecordID),
{Stage:"Akam Ahmad Approval",DADisplayName:"Akam Ahmad",DAemail:"fadi.ahdab@nivatransport.com",CurrentApproved:"fadi.ahdab@nivatransport.com",Status:"CEO-V",CurrentApprover:"portal@nivatransport.com"})
);

//HR-Case-Employee+Manager
If(EmployeeDept_F.Text="HR" ,Set(ApproverEmailName,"Akam Ahmad");
SMTP.SendEmailV3({from:"portal@nivatransport.com",To:"fadi.ahdab@nivaoil.com",subject:"Vacation Request",Body:HtmlText2.HtmlText});
Patch(Vacation_List,LookUp(Vacation_List,ID=SubmitrecordID),
{Stage:"Akam Ahmad Approval",DADisplayName:"Akam Ahmad",DAemail:"fadi.ahdab@nivatransport.com",CurrentApproved:"fadi.ahdab@nivatransport.com",Status:"CEO-V",CurrentApprover:"portal@nivatransport.com"});
// push notification via mobile to the dept manager
PowerAppsNotification.SendPushNotification(
{
recipients: ["fadi.ahdab@nivatransport.com"],
message: "Vacation Request",
params: Table({key:"ItemID", value:SubmitrecordID}),
openApp: true
}
)
);

//Project Manager
If(EmployeeDept_F.Text="Project Manager" ,Set(ApproverEmailName,"Akam Ahmad");
SMTP.SendEmailV3({from:"portal@nivatransport.com",To:"fadi.ahdab@nivaoil.com",subject:"Vacation Request",Body:HtmlText2.HtmlText});
Patch(Vacation_List,LookUp(Vacation_List,ID=SubmitrecordID),
{Stage:"Akam Ahmad Approval",DADisplayName:"Akam Ahmad",DAemail:"fadi.ahdab@nivatransport.com",CurrentApproved:"fadi.ahdab@nivatransport.com",Status:"CEO-V",CurrentApprover:"portal@nivatransport.com"});
// push notification via mobile to the dept manager
PowerAppsNotification.SendPushNotification(
{
recipients: ["fadi.ahdab@nivatransport.com"],
message: "Vacation Request",
params: Table({key:"ItemID", value:SubmitrecordID}),
openApp: true
}
)
);

UpdateContext({popup:false});

Navigate(Success_Submission,ScreenTransition.Fade);