Power Platform Community Forum Thread Details

We currently use a MS Timesheet Form, filled out by casual employees, which is approved/declined dynamically by department head and summarised in a power query using a flow from sharepoint. It works well, except that the data is not robust - due to no time or calculation fields in MS forms. Hence the hours they work are often wrong and they don't take off their lunch time etc, and there is no way of converting their varied input in power query. i.e. start time might be 8, 8.0,8:00 or 8am etc. This was acceptable when the numbers of casuals were manageable, but now my summary excel worksheet has tripled, the checking of each line is awful. Plus, our database payroll module doesn't provide an adequate timesheet solution.

I want to replicate the start of the flow in excel (via a power query sourcing the worksheet tables from a folder),instead of ms Forms, but would love some feedback as to whether it is possible. I'm thinking then at least the data is formatted correctly and the time worked is a calculated field. It would be easy to see what days had been entered or missed, instead of looking at emails. Some immediate issues I can think of are:

users would have to enter the data in the desktop version of excel using data validation or forms (assuming macros may be required to update the table)
the tables in excel (one worksheet/book per user for privacy reasons) need to have a response sent back to them so only new timesheets are sent in the flow. I haven't sourced an example of this.

Is there a prospect of MS Forms being developed to included time and calculations? That would solve this issue.

Thanks for any suggestions/solutions.

Categories:

General topics