Answered

save Today and Now in a form

(0) Share

Report

Posted on by MayranPiran

If I use the TODAY and NOW function in a card and then I save the form with SubmitForm and if I have to edit it again, the previously placed time will be updated with the current time and I will lose the data entered before, how do I do it use the function, get the current date and time, save it and when I go back, keep the previously placed time without changing it to the current one?

Categories:

Building Power Apps

I have the same question (0)

All responses (6)

Answers (2)

Rusk 1,369 Super User 2024 Season 1 on at

Like (1)

Report

Where are you saving your TODAY / NOW values? I would add another column (maybe named 'Last Edited'), and then save to that column if there is a value in your original column.

Something like If(IsBlank('Original Submission Time'), SAVE HERE, ELSE SAVE THERE)

Was this reply helpful? Yes No
MayranPiran 83 on at

Like (0)

Report

the data is saved in SharePoint with the date and time,
in DefautDate I put TODAY, but I have 5 cards of value that need to be inserted with dates and times, but I put the date in a moment, I save and then I have to fill in another one and then the old card is updated

image.png

Was this reply helpful? Yes No
Rusk 1,369 Super User 2024 Season 1 on at

Like (1)

Report

So it seems your departure / arrival times have a "Default" formula that is driven by the NOW function. Is this correct?

If so, you may be able to modify your "Default" formula. Can you share the formula you are currently using?

Was this reply helpful? Yes No
MayranPiran 83 on at

Like (0)

Report

that's right

I'm using this in hours and minutes " Text(Hour(Now());"00")"
already on the date DefautDate I am using TODAY()

Was this reply helpful? Yes No
Verified answer

Rusk 1,369 Super User 2024 Season 1 on at

Like (1)

Report
Something like this might work for your "Default" formula, assuming that the card with the dropdown is referencing the saved time value:
If(IsBlank(ThisItem.'Your Column Name'),Text(Hour(Now()),"00"),Parent.Default)

So check if the saved time column for the item you're working on is blank, if so use the NOW default, if not use the saved one.

Was this reply helpful? Yes No
Verified answer

MayranPiran 83 on at

Like (1)

Report

THANK YOU SO MUCH FRIEND, it was perfect, it saved my job hahaha, thank you very much...

Was this reply helpful? Yes No