Unanswered

Now() doesnt getting saved in datetime column in SharePoint - Resubmit form

(0) Share

Report

Posted on by Iantaylor2050

531

I have a powerapp new form where user can create New Room booking request. On submission of this form, I am saving Submission _date_time field as current time. This works fine.

Update property of Submission_date_time

Now()

However if i use the same logic in EditForm field for resubmitting the request by same user, above field doesnt save current datetime.

Update property of Submission_date_time in EditForm

Now()

May i know how to solve this?

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (1)

Hassan_SZ_365 542 on at

Like (0)

Report
Hi @Iantaylor2050 ,
For your PowerApps form where the Now() function isn't updating the Submission_date_time field in the EditForm, you might need to refresh the data source or reset the form field to ensure the current date and time are captured correctly. In some cases, the EditForm might be holding onto the old data.
Use this formula:

UpdateContext({currentDateTime: Now()}); Patch(YourDataSource, YourForm.Item, {Submission_date_time: currentDateTime}); SubmitForm(YourEditForm);

Replace YourDataSource with the name of your SharePoint list and YourEditForm with the name of your edit form.
This code snippet first captures the current date and time in a variable (currentDateTime), then patches the Submission_date_time field with this value before submitting the form.
Ensures that the Submission_date_time field is explicitly updated with the current date and time every time the form is submitted in edit mode.
Best Regards,
Hassan Raza

Was this reply helpful? Yes No
Verified answer

v-qiaqi@microsoft.com on at

Like (0)

Report
Hi @Iantaylor2050,

That's easy, you just need to set a timestamp once you open the edit form.

Set the OnVisible property of your screen including your edit form as:

Set(TimeStamp,Now())

Set the Update property of the submission date time data card as this variable:

TimeStamp

Or a easier way, set the OnSuccess property of your edit form as below:

Patch(list,form.LastSubmit,{SubmissionDateTime:Now()})

Was this reply helpful? Yes No