Access your Projects and generate Status Reports using Project Online and PowerApps

Today´s post is about Office 365 variety of services and how your company can use them to empower your business and users.

After several years working with the Microsoft PPM Solution, or Project and Portfolio Management Solution, which used to be consisted of:

  1. Microsoft Project Professional
  2. Microsoft SharePoint Server
  3. Microsoft Project Server
  4. Microsoft Office (Excel, Word)

It’s interesting to see how the PPM Solution has evolved.

Since Office 365 became part of the strategy for most of the organizations, providing cloud services that could integrate with their business as a “Your go-to Office-anywhere“, things really started to change.

In less than 1 year we saw 70% of our customers moving to the cloud, rapidly!

I can remember almost like today, when Power BI was announced: a completely new service, that had his own tool and was promising to do magic with your data! and yes, they were right!

Now we see Power BI as a MUST HAVE service on most of our clients, using or not the Microsoft PPM Platform.

All this just to say that our Microsoft PPM Solution is growing day after day!
Thanks Microsoft!

The Microsoft PPM Solution it is now more powerful than ever and it’s been supported by several other solutions, services and tools.

In order to deliver the best advice to our customers, WE MUST follow what is new.
The reason is simple: it makes our lives easier and more productive.

Look at the sample below where we used several different services and tools, but when properly combined, it just work in full synergy. Such a beautiful synergy that might scare some, but in the end, it will only help our business to achieve more with less!

Ok, enough… These are the services we will use:

  1. Project Online
  2. PowerApps
  3. Flow
  4. Azure (hosting our service)
  5. Office Online
  6. OneDrive for Business

You can watch the video here and see it live when I challenged one of my colleagues to try it out! –> Special thanks to Signe. 🙂

Below you will find a description of each service and some screenshots of the entire process.
PPMPro-Draw-Bannerv03.png

Building our mobile app, in PowerApps, to collect and display information of my portfolio of projects in Project Online. 
PPMPro - PowerApps Studio

Using the mobile app to display, analyze and filter my portfolio and projects information.

This slideshow requires JavaScript.

Using PowerApps to run a custom Flow:
PPMPro-Powerapps05PPMPro-generating word doc.png

Using Flow to design my business logic and integrations between different services.
In this case, we will call our custom Azure service
PPMPro - Flow

Our custom service automatically generates my Project Status Report, based on a Office Word template stored in OneDrive for Business, and save it at my Project Online Project Site!
PPMPro-DocGeneratorService

Hope you got inspired and enjoyed this post!