Sub counttasks() Dim project As .Project Dim xtask As .Task project Dim taskcount As Integer 0 For Each xtask In project. Please ensure that subtasks are created appropriately in MS Project and the. Disregard, I found the solution to my problem.
The flow process would be as follows (*IMPORTANT: The REST API to use for this would be ProjectServer vs. You are creating a project plan using MS Project for Consumer Market Study. Ive seen the Microsoft Project produces some standard reports but doesnt provide all the statistics that I require. In order to accomplish this, I used the “Send and HTTP Request to SharePoint” action in my Power Automate flow, and the end result appears in the schedule as shown in this image: Is there an easy way to count the number of tasks in MS Project For example, I want to count the total number of tasks scheduled to finish before a certain date, and then then number of tasks Late within that period. Great timing as Daniel was also looking at the same challenge. Drawing on PMI best practice this guide explains why Project Managers should avoid linking summary tasks. Your ability to decipher the tasks on the summary level is limited but may be sufficient for. Why you should not link summary task in MS Project. These roll-up Gantt bars provide high level reports that are still fixed down to the task level. This is a guest post from Daniel Partridge - who answered an internal enquiry at Microsoft, for a colleague who needed to add a task under a summary using Power Automate (Flow). In Microsoft Project, it is possible to roll-up tasks so that a projection of the respective task’s Gantt chart bar is displayed at the summary level.