How can I capture the "Last update Date" on Form submission

(0) Share

Report

Posted on by JC-04111302-0

Hello Community

I have a datetime field in my Sql database.

Before the SubmitForm command, I want to update the date and time ("Last Updated on ") to the value as at Now(). Can anybody help me based on the above/attached file on the codes. I thank you.

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (1)

Sort by

timl 37,160 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Hi JC-04111302-0

If you set the Default property of the card 'Last Updated On_DataCard3' to Now(), that should hopefully work.

Was this reply helpful? Yes No
JC-04111302-0 18 on at

Like (0)

Report
Copy link

Link copied!

Hi Timl

Thank you. I did what you suggest before coming to the community. It does not answer to the problem. I explain. The default is set to Now() and say it displays 7:40 am on the screen. I leave the application open and come back after 10 minutes and submit the form. The Last updated field on the screen is still 7:40, and this is what get updated, whereas the update field should have been 7:50 am, the actual time.. This is why I want to refresh the time before the SubmitForm is executed. Any help?

Was this reply helpful? Yes No
timl 37,160 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!
Hi JC-04111302-0

You could do this with a variable. In the OnVisible property of your screen, you can assign Now() to a variable like so.

Set(varCurrentTime, Now())

You would then set the Default property of the 'Last Updated On_DataCard3' card to varCurrentTime.

Before you call SubmitForm, you can update the variable and that should then save the actual time.

Set(varCurrentTime, Now()); SubmitForm(YourForm)

Was this reply helpful? Yes No
Verified answer

ronaldwalcott 3,898 Moderator on at

Like (0)

Report
Copy link

Link copied!

If you want the actual time before the submit you could set the update property of the datacard for the date to a context variable like (initialize the value elsewhere)

UpdatedDate

and then in the OnSelect for the Submit

UpdateContext({UpdatedDate: Now()});

This should record the actual data time that the record was updated

Was this reply helpful? Yes No