Forum Discussion
Project for the Web (P4W) Baselines or Due Dates
Hey All, Are baselines or due dates planned for P4W? Do we know when they will be added? Is there a workaround in the meantime? Related question: where does the data for the custom columns ...
I've been searching for a while now about it, and it was on the Roadmap last year for release I think in Q2, but it dissappeared from the roadmap not long after.
We've started to implement a basic solution, adding custom columns on the Task table, and saving the start, finish and effort fields into the columns using a flow that's triggered by the user.
It's far from complete or ideal, but better than nothing.
For your related question, if I'm understanding correctly, all of the data is stored in Dataverse, and you can report on it with the OData API. So if you add a column called Start Baseline, with an internal name of new_startbaseline, then you can get it with this call with a REST API query:
https://<orgid.crm>.dynamics.com/api/data/v9.2/msdyn_projecttasks?$top=10&$select=msdyn_projecttaskid,msdyn_subject,msdyn_start,new_startbase.
In PowerBI it would show as new_startbase
We've started to implement a basic solution, adding custom columns on the Task table, and saving the start, finish and effort fields into the columns using a flow that's triggered by the user.
It's far from complete or ideal, but better than nothing.
For your related question, if I'm understanding correctly, all of the data is stored in Dataverse, and you can report on it with the OData API. So if you add a column called Start Baseline, with an internal name of new_startbaseline, then you can get it with this call with a REST API query:
https://<orgid.crm>.dynamics.com/api/data/v9.2/msdyn_projecttasks?$top=10&$select=msdyn_projecttaskid,msdyn_subject,msdyn_start,new_startbase.
In PowerBI it would show as new_startbase
Thank you! To clarify, the custom columns when added to a project in Project for the Web. Where does that data live? It does not appear in Dataverse as far as I can tell. In other words, if I added a custom 'Test Date' date column in a project schedule and started adding data, is that information somewhere on the backend in Dataverse? Which table?
- Hi,
I have had a couple of people in my org ask this, I believe because these custom fields do not persist across the whole PftW env, just the project, they do not sit in any dataverse table as these only contain data/fields that is universal across the environment.- Thank you! That is helpful.
