Unanswered

Capture start time and end time of a status on click of button

(0) Share

Report

Posted on by luaxs4

Hi All,

I am developing a production tracker, which captures the status of production when the user clicks a button. What i am looking for is to capture start time of a status (Unavailable) in start_time column and when the user changes the status to busy after clicking the button, it should capture the end time of the status in end_time column, but it should be for the same record. Once done, the start_time of the new status should get captured as new line item.

I am using teams dataverse as database. Image for reference as to how i would like the output.

If the status is unavailable, then it will capture the start time, but when user changes the status using a click of button, it should capture the end time of 1st status and create a new entry in next line with start time captured for the new status and this continues.

Categories:

Microsoft Dataverse with Power Apps

I have the same question (0)

All responses (3)

Answers (0)

Drew Poggemann 9,287 Most Valuable Professional on at

Like (0)

Report
Hi @luaxs4 ,

When the user clicks the button (OnSelect property), you would want to execute the Patch to update the current record.

Patch( StatusTable, SelectedRecord, { end_time: Now() } )

and then create your new StatusTable record

Collect( StatusTable, { status: StatusField.Text, start_time: Now(), // You might want to have set a variable on what you set as the end from the last record and use this for start so it matches vs. calling Now again... end_time: Blank() } )

You would want to set the context of your SelectedRecord to the new record you just created as well in case the. user hits the button again...

Was this reply helpful? Yes No
luaxs4 58 on at

Like (0)

Report

The " SelectedRecord" is causing some confusion, everytime i tried typing selectedRecord, it shows Name isn't valid "SelectedRecord" isn't recognized error

And If i try defaults option then the record comes in the following manner
what am i doing wrong?

Was this reply helpful? Yes No
Drew Poggemann 9,287 Most Valuable Professional on at

Like (0)

Report

Hi @luaxs4 ,

You are modifying a record so you would need to select this record from the Dataverse to update it. Example is you could set the selected record from a Gallery or use the Lookup function to find that record... You can then "Set" the value of the SelectedRecord:

https://learn.microsoft.com/en-us/power-platform/power-fx/reference/function-set

Was this reply helpful? Yes No