Unanswered

Submit a form with patch

(0) Share

Report

Posted on by nayem

hai guys, i just want to ask how do i submit a form and at the same time, i want to patch submission date with Now() function.

Cause as i know that patch will update the data, but not sure about when submitting a form

my code:

If(
Form1.Valid,

// Submit the form, clear attachments, reset the form, and open a new form
Set(varSuccessPopup, true);
SubmitForm(Form1);
Clear(colFilteredAttachments);
ResetForm(Form1);
NewForm(Form1);

,
Set(varInvalidSubmit,true);

);

where can i insert patch function here?

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (0)

v-qiaqi@microsoft.com on at

Like (0)

Report
Hi @nayem,

Do you want to update the last submit record?

If so, you could add Patch() just behind the SubmitForm():

If( Form1.Valid, // Submit the form, clear attachments, reset the form, and open a new form Set(varSuccessPopup, true); SubmitForm(Form1); Patch(list,Form1.LastSubmit,{Date:Now()});//Here add the Patch() Clear(colFilteredAttachments); ResetForm(Form1); NewForm(Form1); , Set(varInvalidSubmit,true); );

Was this reply helpful? Yes No
Michael E. Gernaey 53,362 Super User 2025 Season 2 on at

Like (0)

Report
Hi,

Since you are NOT running things concurrently, you can place your Patch, right under your SubmitForm(Form1) expression.
Set(varSuccessPopup, true); SubmitForm(Form1); Patch(goes here) Clear(colFilteredAttachments); ResetForm(Form1); NewForm(Form1);

Depending on what data you need, if you want data from the Form after submission, you can use Form1.LastSubmit

Cheers
If you like my answer, please Mark it as Resolved, and give it a thumbs up, so it can help others
Thank You
Michael Gernaey MCT | MCSE | MCP | Self-Contractor| Ex-Microsoft
https://gernaeysoftware.com
LinkedIn: https://www.linkedin.com/in/michaelgernaey

Was this reply helpful? Yes No