Labour Planning

(1) Share

Report

Posted on by Tan_Bui

Hello all,

Hope you are doing great!

I got an idea about an app, please help me to advise if it is feasible to build with Power Apps canvas. This is about labour planning. As per the below table, this is a list of all of my lift/esc installers. The column is the date, ie, which date of the labour plan. Each cell which is the combination of the row - installers and the column - date will be the job site and the task that they are going to work on. I want to have a drop out or a search which the manager can choose which job site and which task need to be carried out at the job site to put in this file. So each of lift (depending on number of stops, product line) the time for each task may be different (please refer to table 2).

So the important point here is that when we assign a task and a job site to a person, there should be a validation for how many hours left (or total per plan if there is no actual hour yet). A manager then can only assign that many days.

Thank you very much for your help.

Table 1:

Installer Name

17/03/2025

18/03/2025

19/03/2025

20/03/2025

21/03/2025

22/03/2025

23/03/2025

24/03/2025

25/03/2025

26/03/2025

27/03/2025

28/03/2025

Mark

Clinton

Rusty

Table 2:

Project Number	Project Name	Task	Planned Duration (Days)	Actual Duration (Days)
123	ABC	Mechanical Installation
123	ABC	Testing
123	ABC	Handover
124	XYZ	Mechanical Installation
124	XYZ	Testing
124	XYZ	Handover

Categories:

Building Power Apps

I have the same question (0)

All responses (5)

Answers (1)

MS.Ragavendar 5,036 Super User 2025 Season 2 on at

Like (1)

Report

@Tan_Bui,

Would you like a basic prototype setup or help with a specific feature first?

Was this reply helpful? Yes No
Tan_Bui 28 on at

Like (0)

Report

@MSR@08012015

Hello,

Thank you for your reply. It would be great if you could help me with a basic prototype set up with some explanations.

I am actually from Finance so I have quite limited knowledge about Power Apps.

Best regards,

Tan

Was this reply helpful? Yes No
Verified answer

MS.Ragavendar 5,036 Super User 2025 Season 2 on at

Like (2)

Report
@Tan_Bui,

I am providing this approach based on SharePoint as Backend DataSource for storing the records.

Backend Schema

Installers Table (List of workers)

Projects Table (Stores project details)

Tasks Table (Stores task details with duration)

Labour Assignments Table (Stores which installer is assigned to which task & project on a specific date)

UI / Screen

Use a flexible Gallery or Data Table to display Installer Name × Date assignments.

Dropdowns/Search for Assignments:

Managers select an installer.

Choose a Job Site (Project).

Select a Task (Filtered based on the project).

Auto-calculate Planned Duration and restrict overbooking.

Business Process

Send notifications if an installer is over-assigned using power automate.

Basis on my understanding i have shared the high level overview this can be tweak as per your requirement and understanding.

Hope this helps!

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item

Was this reply helpful? Yes No
MS.Ragavendar 5,036 Super User 2025 Season 2 on at

Like (0)

Report

@Tan_Bui,

Do u still have any queries?

Was this reply helpful? Yes No
Tan_Bui 28 on at

Like (1)

Report

Hello @MSR@08012015,

Thank you very much for your kind help.

Let me follow the flow and in case of any unclear, I appreciate your further help.

Sorry for the late response and have a great week ahead!

Best regards,

Tan

Was this reply helpful? Yes No