Announcements
i am working on a payroll correction PowerApps where i need to make time in and time out entries screen for an employee and calculate the total hours worked where the time in and time out fields are time only fields so if any one knows how to make it please try it and reply to this question
i am attaching screen the screenshots of the screens to make below
thanks
Hi @Ayush_Rathi,
If you are using a collection to populate your grid.
You can set the OnChange property of your dropdowns with:
Patch('Collection Name', ThisItem, {'Column Name': Self.Selected.Value})
Then for your save button you can:
Patch('Data Source', 'Collection Name')
Please tick Accept as solution if the answer is useful.
Thanks,
@AARON_C
hi @AARON_C i am actually not getting how to make those time only value columns that appear in both the screenshots
@Ayush_Rathi
Correct me if I am wrong.
My understanding of the photos is that you want to go from what you currently have in the first screen shot to make it look like the second screen shot.
Please share with me your table/list you have for time entries
actually i have not made ant list as of now for that these screenshots are the sample of what i am trying to make but since PowerApps doesn't have time only fields i am stuck with how to make a SharePoint list for the same to store those time values and calculate hours worked from them
as you can see in the second screenshot if we want to edit any existing time entries it has the fields to enter hours and minutes separately and as we save the row it displays the time as a proper single time value
To create the time, you would need to create a choice column in the sharepoint list and have one with values from 1-12 for hours and one with values from 0-59 for minutes.
Essentially you need two columns for each time value you want.
but how to store those time value after choosing them from dropdown as a proper time value into a singe column
You can only save the time value as Text as there is no Time field/column.
You could do this and save this as the TimeIn value as Text.
$"{TimeInHour.Selected.Value} : {TimeInMinute.Selected.Value}"
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
Congratulations to our 2026 Super Users!
Congratulations to our 2025 community superstars!
These are the community rock stars!
Stay up to date on forum activity by subscribing.
11manish 505
WarrenBelz 502 Most Valuable Professional
Haque 324
