Share
Report
2Hi Guys,
Hope you can help me out here, i have two Sharepoint online lists, Training Tasks and Training progress. The Training Tasks list acts as a repository for all tasks to be performed for a specific machine, which is selectable from a choice dropdown as well as other options such as a timeline in days as to when the task is to be completed by and the area of a building in which the machine is stored in, the machines are grouped by the area location in the list. So for example it would have all 20 tasks that would need to be completed on the Cola01 machine in the soft drinks location within 30 days. There are maybe 8 machines and 4 locations, as well as 30, 60 90 365 day task milestones that tasks need to be completed by
The second list
Here I capture who the engineer is that’s performed the tasks and a second engineer that’s verified the work. This list has a link per task to the 1st list (so as not to have to duplicate the task descriptions and detail). The tasks are allocated to the engineer via the manager.
At the min I have the tasks in list one updated as a once of exercise, and list two has some test data in there where I've allocated jobs to test engineers, and they completed the work etc - all ok
Then I created a power app which via a gallery displays all the tasks in their various states that’s been allocated to the engineer. E.g. Eng 01 has 3 "Not Started tasks" 6 in progress and 10 completed tasks. When he has all tasks completed in all location n and machines he is seen as qualified or competent to work on all machines sin all locations.
Where I’m struggling and can’t figure out is: if i want the engineer to work on machine cola01 in the soft drinks group and complete all 20 x of the 30 day tasks, I can assign him one task at a time, but I want to be able to assign him the 20 tasks in one go on the Training progress list. Assign them all with a status of "Not started" and use the day I assigned him the task as day 1 and have the due date show as 30 days from now.
I hope this all makes sense and that I’ve explained it well enough for someone of you guys that’s way more tuned in to this kinda stuff that me to let me know how to complete this project. I was hoping to keep everything within the app (as opposed to linking it to power automate to execute the solution) although id take that if it was my only solution. I’d love to better understand the patch function at that seems like it can do what I need but I don’t know enough as I’m picking up bits here and there myself, self-taught.
Thanks for any help you all can shine on this for me.
Hope you can help me out here, i have two Sharepoint online lists, Training Tasks and Training progress. The Training Tasks list acts as a repository for all tasks to be performed for a specific machine, which is selectable from a choice dropdown as well as other options such as a timeline in days as to when the task is to be completed by and the area of a building in which the machine is stored in, the machines are grouped by the area location in the list. So for example it would have all 20 tasks that would need to be completed on the Cola01 machine in the soft drinks location within 30 days. There are maybe 8 machines and 4 locations, as well as 30, 60 90 365 day task milestones that tasks need to be completed by
The second list
Here I capture who the engineer is that’s performed the tasks and a second engineer that’s verified the work. This list has a link per task to the 1st list (so as not to have to duplicate the task descriptions and detail). The tasks are allocated to the engineer via the manager.
At the min I have the tasks in list one updated as a once of exercise, and list two has some test data in there where I've allocated jobs to test engineers, and they completed the work etc - all ok
Then I created a power app which via a gallery displays all the tasks in their various states that’s been allocated to the engineer. E.g. Eng 01 has 3 "Not Started tasks" 6 in progress and 10 completed tasks. When he has all tasks completed in all location n and machines he is seen as qualified or competent to work on all machines sin all locations.
Where I’m struggling and can’t figure out is: if i want the engineer to work on machine cola01 in the soft drinks group and complete all 20 x of the 30 day tasks, I can assign him one task at a time, but I want to be able to assign him the 20 tasks in one go on the Training progress list. Assign them all with a status of "Not started" and use the day I assigned him the task as day 1 and have the due date show as 30 days from now.
I hope this all makes sense and that I’ve explained it well enough for someone of you guys that’s way more tuned in to this kinda stuff that me to let me know how to complete this project. I was hoping to keep everything within the app (as opposed to linking it to power automate to execute the solution) although id take that if it was my only solution. I’d love to better understand the patch function at that seems like it can do what I need but I don’t know enough as I’m picking up bits here and there myself, self-taught.
Thanks for any help you all can shine on this for me.
All responses (
Answers (
