web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Apps Submit a form with patch

Power Apps

Unanswered

Submit a form with patch

(0) Share

Report

Report

Posted on by nayem

75

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 Img

All responses (2)

Answers Img

Answers (0)

Sort by

v-qiaqi@microsoft.com Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!
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,974 Moderator on at

Like (0)

Report
Copy link

Link copied!
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

Join the conversation