web

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

News and Announcements icon

Power Platform CommunityForums Power Apps Now() doesnt getting s...

Power Apps

Answered

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

(0) Share

Report

Report

Posted on by Iantaylor2050

603

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

All responses Img

All responses (2)

Answers Img

Answers (1)

Sort by

Hassan_SZ_365 542 on at

Like
a
(0)

Report
Copy link

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

v-qiaqi@microsoft.com Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
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()})

Join the conversation