You’re offline. This is a read only version of the page.
Announcements
122
HI
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
Thank you for this, really helpful and set me on the right path.
The one bit i am struggling with is logic around below:
"For each week between the project's start and end date, populate the forecasted hours into your weekly hours SharePoint list."
Do you have an example of how this is achieved?
Chris
Share
Report
All responses (
Answers (
