Forum Discussion

ska1903's avatar
ska1903
Frequent Visitor
8 years ago

Show next milestone task for each project

Hi,

 

I am trying to get the following information from the Project Online OData feed and struggling to figure out how to get it.

 

I want to show the Next task that is a milestone for each project as below.

 

Project -- Task

    1      -- Milestone 3

    2      -- Milestone 2

    3      -- Milestone 5

 

Is this possible and if so how?

 

Thanks 

Need Help

2 Replies

  • v-jiascu-msft's avatar
    v-jiascu-msft
    Icon for Microsoft Employee rankMicrosoft Employee
    8 years ago

    Hi ska1903,

     

    What data do you have? I think you need to get the data from Project Online first. Then maybe a measure could help. Can you share a sample?

     

    Best Regards,

    Dale

    • ska1903's avatar
      ska1903
      Frequent Visitor
      8 years ago

      Hi v-jiascu-msft, 

       

      I am using the Project Online content pack template and I am using the OData feed for the information so all the data is available. 

       

      My users have started 6 projects in Project Online with their associated tasks and marked some of them as milestones and now want a (supposedly) simple table showing the project name and what the next task, that is marked as a milestone, is and the date that it is supposed to Finish.

       

      I suppose the fields I would need are;

       

      Projects Table;

      Project Name

      Project ID -> realtionship to Project ID in Tasks Table

      Project Owner Name

       

      Tasks Table;

      Task Name

      Project ID (As above, linked)

      Task is Milestone

      Task Finish Date

       

      Regards,

      Mark