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

All responses (6)

Answers (2)

Sort by

Rusk 1,369 Super User 2024 Season 1 on at

Like
a
(1)

Report
Copy link

Link copied!

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)
MayranPiran 83 on at

Like
a
(0)

Report
Copy link

Link copied!

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
Rusk 1,369 Super User 2024 Season 1 on at

Like
a
(1)

Report
Copy link

Link copied!

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?
MayranPiran 83 on at

Like
a
(0)

Report
Copy link

Link copied!

that's right

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

Rusk 1,369 Super User 2024 Season 1 on at

Like
a
(1)

Report
Copy link

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

MayranPiran 83 on at

Like
a
(1)

Report
Copy link

Link copied!

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