For those of you that are familiar with Project Server or Project Online, only the default lists and default columns from those lists are synchronised to the database reporting schema. So Project API’s like the OData API (_api/ProjectData) only have data for Risks / Issues and the default columns etc. I have published an example solution starter script that will allow data from any list on the project site to be used.
This solution starter should be updated before production use to include the correct data you want, improve error handling, support the REST API pagination etc. This example uses the Issues list and some example default columns from the Issues list but it can easily be updated to use a custom list on the Project Sites.
Once added it will look like this (this in on one of my MOD demo tenants):
The select menu will contain a list of EPTs:
Changing the selection to another EPT will load a SharePoint modal pop up whilst the data loads:
If an EPT is selected that doesn’t contain any list items the following will be displayed:
There is example conditional formatting on the table:
The list item title is a clickable hyper link that will open the list item in a new window:
Fully test this on a non-production PWA instance before using in Production, the script is provided As Is with no warranties etc. Try it out and let me know what you think.