Power Platform Community Forum Thread Details

Hello all,

I'm trying to create a time clock for use at work. It is a warehouse environment with only a small number of employees and employees will not login, they would just select their name from a drop down. The app is connected to an Excel workbook, which contains a table of the employees and then also a table which contains the different activity records. There are four activity columns, set as date/time format, one for clocking in at start of day, out for lunch, in after lunch, out at the end of the day.

Right now the app has two screens, one where a user selects their name, then they click a button to go to the next screen. There are then four different editforms, each one tied to one of the activity columns. The employee's name is pulled from the datacard on screen 1 into a datacard on each of the editforms, and that datacard links to a column in the time clock activity table so that the name is stored against the activity. Each form has a button which has OnSelect properties that submit the associated form, notify the user of its success, reset the form (with default mode of new) and navigate to the first screen.

My problem is that when I select a button, such as the one for clocking out for lunch, it adds a new row to the table, rather than updating the row which was created when that employee clocked in at the start of the day. How can I set it up so that an existing row is updated with the new activity, rather than a new row being created?

At the backend of this the Excel form will live in OneDrive, or perhaps a Sharepoint site, and our HR officer will pull the info out when she needs to submit it for payroll and then calculate hours. I'm not tied to the two screen setup I have created so far, this is the first app I'm jumping into so have been learning plenty along the way already.

Current output in the excel workbook: