Answered

Is it fine to write formula after SubmitForm()

(0) Share

Report

Posted on by johnjohnPter

2,015 Season of Giving Solutions 2025

I have a form and 4 buttons... now when clicking on some button i will be submitting the Form and return the users to the main screen. while on other scenarios after submitting the form i need to Patch and clear some collections for SharePoint items. so generally speaking is it fine to write formula after form submission something as follow:-

If(IsEmpty(colNetworkConflicts),
If(IsEmpty(colSelectedMedia) Or IsEmpty(colSelectedNetworks),
Notify("Please select atleast one Network and one Medium",NotificationType.Error),
SubmitForm(BookingCalendarForm))
,
Notify("Conflict found, Please check the Booking calendar for more info",NotificationType.Error));
Clear(colDelegableresults);
Clear(colNetworkConflicts);

or as follow:-

SubmitForm(PrintFormForm);

Office365Outlook.SendEmailV2(
 PrintFormForm.LastSubmit.'Printing House Email',
 PrintFormForm.LastSubmit.'Email Subject',
 PrintFormForm.LastSubmit.'Email Body',
 {
Attachments:Table({
 Name: varAttachment.DisplayName,
 ContentBytes: varAttachment.Value
})

or the formula after the SubmitForm() will not get executed/reached?

Categories:

Building Power Apps

I have the same question (0)

All responses (6)

Answers (1)

Sort by

M_Ali_SZ365 1,110 on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @johnjohnPter ,
Try this
SubmitForm(BookingCalendarForm); Clear(colDelegableresults); Clear(colNetworkConflicts); // Additional logic after form submission
Fuel our success! 🚀 Give a thumbs up and click 'Solution Accepted' to supercharge our community. Your actions speak volumes!
Warm regards,
Muhammad Ali

Was this reply helpful? Yes No
johnjohnPter 2,015 Season of Giving Solutions 2025 on at

Like
a
(0)

Report
Copy link

Link copied!

@M_Ali_SZ365 did you read my question? as seems your answer is not related to it. thanks

Was this reply helpful? Yes No
v-qiaqi@microsoft.com Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @johnjohnPter,

If you want to do something after form submission, to ensure the form is submitted successfully, you could write the other operation like your Patch() or Clear() on the OnSuccess property of the form.

If there is no invalid error in your form, actions will be operated after your form submission.

Was this reply helpful? Yes No
johnjohnPter 2,015 Season of Giving Solutions 2025 on at

Like
a
(0)

Report
Copy link

Link copied!

@v-qiaqi-msft but as i mentioned that the form can be submitted by the other buttons where i do not want to perform the patch.. so that why i am writing it after the SubmitForm() on the button onselect and not on the form onsuccess.. so again to return to my question, will the formulas that comes after the SubmitForm() get executed?

Was this reply helpful? Yes No
v-qiaqi@microsoft.com Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @johnjohnPter,

I have answered it in my previous reply.

If there is no invalid error in your form, actions will be operated after your form submission, which is after the SubmitForm() get executed.

Was this reply helpful? Yes No
Verified answer

timl 37,233 Super User 2026 Season 1 on at

Like
a
(1)

Report
Copy link

Link copied!
@johnjohnPter

The direct answer to this question is yes, the formulas after SubmitForm will be executed.

>> will the formulas that comes after the SubmitForm() get executed?

However, it would be preferable to add the additional formulas to the OnSuccess property of the form so that they run only when the call to SubmitForm succeeds.

Before calling SubmitForm, you can set a variable that identifies the button that was clicked.

Button1.OnSelect - UpdateContext({locButton:"Button1"}); SubmitForm(Form1) Button2.OnSelect - UpdateContext({locButton:"Button2"}); SubmitForm(Form1) Button3.OnSelect - UpdateContext({locButton:"Button3"}); SubmitForm(Form1)

You can then refer to this variable in the OnSuccess to execute the calls to Patch/Clear/SendEmail depending on the source button.

Form1.OnSuccess - Switch(locButton, "Button1", <Optional Patch/Clear operations for button 1>, "Button2", <Optional Patch/Clear operations for button 2>, "Button3", <Optional Patch/Clear operations for button 3> )

Was this reply helpful? Yes No