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 proje...
Need Help
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