Date and Time

(0) Share

Report

Posted on by akbarmahfuzalam

709

Hello Team,

I'm stuck here and need aid from the community.

I have three text fields: StartTime, EndTime, and TotalTimeSpend.

I'm referring to form as form1.

When I select the status field as Production, Break, or any entry, I want the Starttime to take the current date and time, and when I submitform(form1), it should get the End date and time, as well as the total time spent in HH:MM:SS:

Starttime= DataCardValue5

Endtime = DataCardValue6

TotalTimeSpend= DataCardValue7

Data is storing in Sharepoint List name TimeTracker.

Categories:

Building Power Apps

I have the same question (0)

All responses (14)

Answers (0)

RandyHayes 76,297 Super User 2024 Season 1 on at

Like (1)

Report

@akbarmahfuzalam

When you reference a Time function in your formula, it is evaluated when it first appears. It will not update itself as the time changes. So, you will need to keep track of the time in your app.

The best way to go about that is to place a Timer control in your app and set it not visible. Set the AutoStart to true and the repeat to true and the duration to 1000.

In the OnTimerEnd action of the timer, place the following formula: Set(glbCurrentTime, Now())

Now, in your formulas that you want to be based on current time, use the above variable instead of Now().

So, for your default formula, set it just to glbCurrentTime

By the way - Now() returns the date and time, so there is no need to do Today() + a time conversion based on the Hour minute and second, like you showed in your formula. Now() is equivalent. And with the above formula, glbCurrentTime is always Now() accurately updating.

I hope this is helpful for you.

Was this reply helpful? Yes No
akbarmahfuzalam 709 on at

Like (0)

Report

@RandyHayes
Thanks a ton
Its working for StartTime but what do i need to put on EndTime and when i click the Save button it should store the date and time too. How its going to capture the time diff in the TotalTimeSpend

Was this reply helpful? Yes No
RandyHayes 76,297 Super User 2024 Season 1 on at

Like (1)

Report

@akbarmahfuzalam

Well, the rest of it is all logic in your form.

For example, I am going to only assume that the Start time only gets filled in if the Production status is chosen. But, then you have a break time status and then what happens?

Are you creating individual records for each action (production, break, end, etc)? Or are you updating ONE record as the status changes? If that is the case, then you need logic in the form to preserve start time once entered, and then how does break time get accounted for?

If you are doing an individual record for each action, then the calculation would be based on the StartTime and the EndTime only.

So, not sure what your logic is in the app.

Was this reply helpful? Yes No
akbarmahfuzalam 709 on at

Like (0)

Report

@RandyHayes
Creating an individual records for each action (production, break, end, etc)? Yes am updating ONE record as the status changes. that is the case and i need logic in the form to preserve start time once entered.
Doing an individual record for each action, the calculation would be based on the StartTime and the EndTime only.
Now what would be the logic here.

Was this reply helpful? Yes No
RandyHayes 76,297 Super User 2024 Season 1 on at

Like (1)

Report
@akbarmahfuzalam

So your default for the StartTime would be (note, since you're storing as text, we need to convert for it):

Coalesce(Parent.Default, Text(glbCurrentTime))

That will preserve the start time.

Was this reply helpful? Yes No
akbarmahfuzalam 709 on at

Like (0)

Report

@RandyHayes
StartTime sorted
Endtime____ ?
TotalTimeSpend___ ?
Save button___ ?

Was this reply helpful? Yes No
RandyHayes 76,297 Super User 2024 Season 1 on at

Like (1)

Report

@akbarmahfuzalam

What triggers an End time? I believe that is where the issue comes in.

Was this reply helpful? Yes No
akbarmahfuzalam 709 on at

Like (0)

Report

@RandyHayes

When I click the Save button then only the EndTime trigger and the totaltimespend will trigger. And then form need to be reset for new entry

Was this reply helpful? Yes No
RandyHayes 76,297 Super User 2024 Season 1 on at

Like (0)

Report
@akbarmahfuzalam

So if EndTime is getting set on save, then just set the Default of the End time to be the same as the starttime.

Coalesce(Parent.Default, Text(glbCurrentTime))

Your TotalTime would just be a DateDiff statement on the start and end times.

ex. DateDiff(DateTimeValue(yourStartTimeInput.Text), DateTimeValue(yourEndTimeInput.Text), Minutes)

But you had originally stated that the Status chosen somehow impacted your recording of the values, so I'm not sure how that is fitting in to the logic.

Was this reply helpful? Yes No
akbarmahfuzalam 709 on at

Like (0)

Report

@RandyHayes

I mean to say here is when i Select any entry from the dropdown (production, break, end, etc) The StartTime need to be saved and then when i click the save button then only Endtime capture the current date and time and form can be reset

Was this reply helpful? Yes No