Power Platform Community Forum Thread Details

Hoping somebody might be able to provide some guidance or point me in the direction of how i might create within power apps a way of inputting and storing the projected number of hours committed to a project over the forecasted project lifespan. This will then be used to evaluate capacity within a team.

In theory i already know by the type of project which is selected what the profile of the weekly hours looks like over the course of the project by key dates (which are also populated at project creation). this could be stored in a sharepoint list as a lookup table.

I would like to come up with a solution which when the project is created with a "project start date" i can then automatically populate the forecasted weekly hours based on the key milestone dates (also automatically generated) until project completion.

My current data structure is i have a project Sharepoint List which captures project number, start date and other key dates through the lifecycle of the project. Then another sharepoint list which has project number and the W/C 6th Nov, W/C 13th and so on. This is the list which i was going to populate the weekly hours.

I am struggling to work out how i could pre-populate this weekly hours into the sharepoint list based on the week commencing date and project key dates

Any pointers on how to achieve this or if i am looking at it the wrong way would be great. I have attached an excel file which proiveds an example of what i want to achieve.

Thanks

Chris