This is a new mini blog series on building a simple Power Apps app to enhance the capability for those organisations who use the Microsoft Project Desktop “Sync with SharePoint” feature in Office 365. The idea of this mini series is to build a simple Project portal / hub for Microsoft Project MPP data. In the first post we will have a brief look at this example app so far and the components used to pull this together – all of which are no code! The initial app can be seen below:
Accessing a project enables you to view or update the project level data, in this simple example I have just added a “Project Description” field, I can also click on the Task List URL to access the source data in SharePoint Online:
Then I can access the Tasks tab and view the tasks:
This is a very basic app just to show what is easily possible with no code using the Power Platform. As the blog series progresses I will walk though how this simple app was created but giving examples of how to add new fields / features so that it can easily be extended. This app solution currently consists of:
- Two Power Apps entities in the Common Data Service (CDS)
- MPP Project
- MPP Task
- Sync Project MPP data to CDS Power Automate flow
- MPP Project model driven app and site map
These components are seen in the solution below:
The two entities are used to store the Project and Task data plus the usual forms and views. The flow is used to sync the data from the SharePoint Online task lists into the Power Apps entities on the defined schedule. The flow used can be seen below:
We will go into the flow detail in a later blog post. The model-driven app is then used to provide a central view of all projects, provide additional capability for the projects such as additional project metadata like the “Project Description” field added and then view the tasks associated to the projects.
That’s the quick intro post done to show the initial solution app concept, in part 2 we will look at the backend CDS entities used for this app then explore the Power Automate flow in detail.