## Risks and Microsoft Project for the Web

Hi,

every Project has Risks. And every Project Manager what to handle them. With Microsoft Project for the Web, via PowerApps it can be done in two ways. One is useless, and another is great.

Let me create a Project:

and then:

and finally I will jump here:

Now, when I choose My Project I will get:

I choose Risk and I will get:

When I try to create a risk I will get:

As you can see, here I can only put a Risk name and a Risk owner. And that is why I think that this solution is useless.

BUT! If I install Project Accelerator which can be found here (GitHub – OfficeDev/Project-Accelerator: An Accelerator solution for Project for the web):

I will have much more! Let me show you!

As you can see on the left side of the Screen that with Project accelerator I have more options (Program, for example), and I have much more information (Overall Health, Issue Health, and so on, which I will explain in my further Blog posts).

Now, let’s focus on Risks. I will choose My Project:

As you can see, Risks Tab is here, by default. I will add a Risk:

I put a Risk name and I can choose which status Risk has:

(1) Proposed – the Risk exited and it doesn’t happen yet
(2) Active – the Risk is active, e.g. it happened and we are working on it
(3) Closed – the Risk is Closed, e.g. it didn’t happen or it was fixed
(4) On Hold – for some reason the Risk is on hold

Now I will put the Probability and Impact for the Risk, and other useful information:

So, I put Probability, Impact, Cost, Description, Mitigation and Contingency Plan for this Risk. Now I will going to save this Risk and I will get:

Exposure and Cost Exposure are calculated. Now, let me explain how.

Probability is 3, and this means 3% (percent). So if a cost of risk (if it happens) is 10.000, Cost exposure is 3% of 10.000 = 300! (kn means Croatian kunas – currency in my Country). Exposure is 3% * 5 = 0,03 * 5 = 0,15!

And finally, reminder. Probability is likelihood that risk is going to happen. Impact means: “If it happen – how hard is going to hit me?” So 1 can be – very low, 2 can be – low, 3 can be – medium, 4 can be – high, and 5 can be – critical (of, course this is just an example).

Anyway, with Project accelerator, Project Manager, and the rest of the team can do much more! Risk management is just one example. Others are going to be explained in my future Posts, so stay tuned!

Regards.

## How to customize choices for Project Requests, Programs and Project using Project Accelerator

Hello,

Project Accelerator has many different choices for Project Request, Programs, and Projects. But, very often, I will need different choices, or even new ones.

And, of course there is a way to customize it.

Let me start with a Project Request. I will create a new one:

and:

As we can see, for Priority, I have four options, but I need fifth: (5) Very Low.

First of all, all those fields, like Name, Request State, Priority are stored in Tables, in Dataverse.

For Project Request, there is a table which can be accessed:

and:

since I want to modify the Priority field, I will choose it and I will follow next steps:

and:

and:

That is it. Now back to the Project Request:

and here it is!

Now let’s look at the Program:

and:

What? The same value is available in Program as well. Why? Because both tables are using the same field. And I can see all those Choice fields here:

and:

So I can add, edit or delete them from here, as well.

Finally, the Project!

and:

As you can see, for Project Type I can choose, between: Security, Cloud Computing, etc. Now, let’s say that this Project is Construction type. But, I don’t have this option available. No big deal. I will add it.

and::

and:

I will add Construction as a choice:

and:

Now, let’s get back to my Project:

Voila! Here it is.

So, as you see, if you have right permissions, you will be able to customize many choice fields for your own purpose

Regards!

## How to Create Projects using Project Accelerator !

Hello,

Today I will show you how to Create new Project using Project Accelerator, and then how to analyze them using Program, also within Project Accelerator.

First I will create my first  Project:

and I will get:

Summary Tab

• Name: The Project Name
• Owner: The Project Owner (I can choose anyone from my Azure Active Directory)
• Project Type: I can select:
• Security
• Cloud Computing
• Application Development
• Maintenance
• Other
• Program: The Program to which the Project belongs I can select from the list of Programs which I already created (see my Post: Programs in Project Accelerator and Microsoft Project for the Web | Nenad Trajkovski (ntrajkovski.com))
• Business Unit: To which Business unit Project bellows. I can select:
• IT
• Product Development
• Operations
• State: The Project current state. I can select:
• (1) Proposed
• (2) Active
• (3) Closed
• (4) On Hold
• Stage: The Project current stage. I can select:
• (1) Create
• (2) Select
• (3) Plan
• (4) Manage
• (5) Close
• Priority: The Program Priority. I can select:
• (1) Critical
• (2) High
• (3) Moderate
• (4) Low
• Executive Sponsor: The Project Sponsor. I can choose from the user list in My
Azure Active Directory
• Manager: I can choose from the user list in My Azure Active Directory
• Project Manager: I can choose from the user list in My Azure Active Directory
• Calendar Template: The Calendar Template which the Project will use.
• Funding Available: Is funding for the Project Available (Yes or No)
• Estimate Start Date: Expected Project Start Date
• Duration (Days): Project Duration in Days (this field is going to be calculated)
• Finish Date: Project Finish Date (this field is going to be calculated)
• % Complete: The Project completeness in %  (this field is going to be calculated)
• Effort (Hours): The Effort in hours (this field is going to be calculated)
• Effort Completed (Hours): The Effort completed in hours (this field is going to be calculated)
• Effort Remaining (Hours): The Effort remaining in hours (this field is going to be calculated)

• Description: Project Description
• Business Case: Here I can type Business Case for the Project
• Value statement: Here I can type Value statement for the Project
• Strategic Alignment: I can select:
• Extreme
• Strong
• Moderate
• Low
• None
• No Rating
• Improve Employee Retention: I can select:

• Extreme
• Strong
• Moderate
• Low
• None
• No Rating

• Lower Cost:
I can select:

• Extreme
• Strong
• Moderate
• Low
• None
• No Rating

• Risk: I can select:

• Extreme
• Strong
• Moderate
• Low
• None
• No Rating
• Prioritization Score (this field is going to be calculated), according to Formula:
• No Rating = 0
• None = 0
• Moderate = 50
• Strong = 75
• Extreme = 100

Prioritization Score = (Strategic Alignment * 0,25) + (Improve Employee Retention* 0,25) + (Lower Cost * 0,25) + (Risk * 0,25)

Financial Tab

I don’t have to explain those field, except ROI which is calculated as (Benefit – Budget) / Budget. I did not put anything in Actual field, because I am creating the Project, and so far I don’t have any actual costs for the Project.

Funding is available, and Funding Source is Internal (I could also choose External)

I will not show Resources and Task Tab, because there is nothing to show for now, and I will explain Risks, Issues and Changes in separate Blog Posts.

Status Tab

I can choose Overall Health, Issue Health, Schedule Health, Effort Health, and Financial Health and choices are:

• (1) On Track
• (2) At Risk
• (3) Off Track

I can also choose if the Project need staffing (YES or NO). Finally I will save the Project. After the Project is saved, I can jump to the Task  Tab, and create some Tasks:

Task are created in the exact same way as they are created in Microsoft Project for the Web!

Now, let’s look at the Resources Tab:

As you can see here I can see every single Resource and they total effort for the Project!

And finally, what will happen if I open Project for the Web? I will get:

and:

Regards!

## Programs in Project Accelerator and Microsoft Project for the Web

Hi,

Today I will show you how to create Program for Projects using Project Accelerator and Project for the Web!

But First of all what is Program anyway? According to PMI Project is temporary endeavor undertaken for creating unique Product, Service or Result! On the other hand, Program is a group of related projects managed in a coordinated way to obtain benefits and control not available from managing them individually. Programs may contain elements of work outside of the scope of the discrete projects in the program. So Projects in a Program have to be related!

Let me create Marketing Program:

I will get new screen with following fields:

• Name: The Program Name
• State The Program State. I can select:
• (1) Proposed
• (2) Active
• (3) Closed
• (4) On Hold
• Priority: The Program Priority. I can select:
• (1) Critical
• (2) High
• (3) Moderate
• (4) Low
• Business Unit: To which Business unit Program below. I can select:
• IT
• Product Development
• Operations
• Manager: The Program Manager. I can choose from the user list in My Azure Active Directory
• Program Type: I can
select:
• Customer
• Development
• Support
• Enhancement
• Program
• Other
• Program Type: I can select:
• Customer Satisfaction
• Transformation
• Other
• Program Start: Expected Program Start Date
• Program Due: Expected Program End Date
• Description: Program Description
• Business Case: Here I can type Business Case for the program

So it can look like this:

Now, I will choose Financial Tab, and I can edit following fields:

As you can see, I can only put Budget and Benefit amounts, and everything else is going to be calculated, after I save the program. So I will do it, and I will get:

As you can see ROI is 2,00, because it is calculate as (Benefit – Budget) / Budget = (3.000.000 – 1.000.000) / 1.000.000 = 2.00, and Remaining Budget Allocation is 1.000.000 because nothing has been spent yet! And if you look at Project Financials you will see that Project Budget, Project Actual Cost, Project Remaining Budget, Project Benefits, and Project ROI is zero, because there is no single Project assigned to the Program yet, and all Last updated fields are the same, and it is 5/2/2021 which is the date when I last saved the Program (for now).

I can choose KPIs for Overall Health, Financial Health, Effort Health, and Schedule Health, and choices are:

• (1) On Track
• (2) At Risk
• (3) Off Track

Active Projects, Projects At Risk, Projects On Track and Project in Trouble are zero, again because there is there is no single Project assigned to the Program yet, and all Last updated fields are the same, and it is 5/2/2021 which is the date when I last saved the Program (for now).

As you can see, nothin is displayed here, again because there is there is no single Project assigned to the Program yet. Be aware that I can have a lot of Projects opened / Created, but I can not add them to the specific Program here. Where can I assign them? Well, that is what I am going to show you in my next Blog Post

Finally, the Notes Tab:

When I create a note, I can put the Title (in my example: My note), a note itself (in my example: Here is my note) and if I click on Add note it will be saved. After it is saved you will see it is shown on the screen below:

I can also attach a file with my note, ad you can see in my example above.

OK, I created a Program. Now what? Well, wait for my next Blog Post to find out!

Regards!

## Project Request with Project Accelerator and Microsoft Project for the Web

Hello,

as we all know, in real life we have always many Project Requests, but not all of them are approved (e.g. we are not going to execute each and every of them). The very first step in Project Management is – Project Request. We can do it with Project Accelerator in PowerApps.

and:

I will enter my Project Request:

First of all, I gave a Name for Requested Project. Then, I choose New as a Requested State, and I put Ellen as Requestor for this Project. I put some details, and if I wanted I can put a Business Case.

On the second half of this screen I have:

• Strategic Alignments – Options are: Extreme, Strong, Moderate, Low, None, and No Rating
• Lower Cost – Options are: Extreme, Strong, Moderate, Low, None, and No Rating
• Improve Employee Retention – Options are: Extreme, Strong, Moderate, Low, None, and No Rating
• Risk – Options are: Extreme, Strong, Moderate, Low, None, and No Rating
• Budget
• Benefit
• Funding Available – Options are: Yes and No
• Funding Source – Options are: Internal and External

I’m done, and I’m going to save this:

and I will get:

As you can see Prioritization Score, and ROI are calculated fields, so they are visible after saving.

But how did I get Prioritization Score = 62.50? Well, according to Formula:

• No Rating = 0
• None = 0
• Moderate = 50
• Strong = 75
• Extreme = 100

Now I have:

• Strategic Alignment = Extreme = 100
• Lower Cost = Strong = 75
• Improve Employee Retention = Strong = 75
• Risk = None = 0

Prioritization Score = (Strategic Alignment * 0,25) + (Lower Cost * 0,25) + (Improve Employee Retention * 0,25) + (Risk * 0,25) = (100 * 0,25) + (75 * 0,25) + (75 * 0,25) + (0 * 0,25) = 25+ 18,75 + 18,75 + 0 = 62,5

ROI is calculated according to formula: (Benefit – Budget) / Budget = (2.500.000,00 – 1.000.000,00)  / 1.000.000,00  = 1.5

And here it is:

Now I will open Microsoft Project for the Web:

As you can see My Third Project is note here. and that is perfectly normal because it is not Approved yet. It can be also seen in PowerApps:

OK! Let’s say that someone decided that this Project is good one, and it should be approved! To do that I follow next steps:

and:

and here it is:

and it is also in Microsoft Project for the Web:

Be aware that Requested Project is not gone form Project Request Screen in Project Accelerator, after it was approved. So when you will have lot of Project you can distinguish them by filtering:

So here I can choose which Project Requests do I want to see.

Final word. This is GREAT! Without Project Request we were able to create Project after it was approved, or if we did it before it was approved, and it was not approved we had to delete it, which was a bad practice.

## Project Accelerator and Microsoft Project for the Web

Hi,

If you jump at the: GitHub – OfficeDev/Project-Accelerator: An Accelerator solution for Project for the web, you will find detailed instructions for the Project for the Web Accelerator. What is this?

The Project for the web Accelerator applies useful customizations to the Project for the web Power App. The Accelerator can easily be deployed to any environment that has Project for the web already in it. Scenarios included in the Accelerator are…

Project Requests. Create a list of ideas for Projects that include a business case and expected impact. Pro-tip: Create an Approvals flow using Power Automate to convert Project Requests into Projects.

Programs. Create a hierarchy of programs and projects see how work fits into the bigger picture.

Risks and Issues. Manage the surprises that accompany every project. Create and assign risks and issues to minimize impacts to a project’s schedule.

Changes. Use change tracking processes to help understand the history of a project.

Status. Centralize recording of project status to keep stakeholders up-to-date.

This is copied from the link mentioned above.

Let me show you how does it look. First I will create a simple Project using Microsoft Project for the web:

If you are familiar with Microsoft Project for the Web app, you already know that it is powerful but yet, a lot of things for proper Project Management is missing. On the other hand if you are using Project Accelerator, you will see that there is much more data needed.

Project Accelerator can be found in PowerApps:

and:

As you can see there is a lot of stuff here.

Where is my Project?

If I want to edit it, I will get:

Wow! That is something! I can do a lot of things. I will show you what and how in my next Posts, so stay tuned!

Regards!

## Notifications with Microsoft Project for the Web

Hi,

new Feature in Microsoft Project for the Web is here – notifications.

Let me show you how it works. First of all I will login to a Project:

I will set up my preferred settings:

So, I will get an email whenever a Task is Assigned to me!

Now I will login as Ellen, I will create a new Project, and assign Task to me:

Here I can edit Task which is assigned to me (whatever I need).

In my email if I click on Open Project or Ellen’s Project (the Project name) I will get:

And that’s it! from my point of view this is great feature, because I do not have to worry if and when someone assign any Task to me, and I don’t have to check on Project frequently, because I will get a mail!

Regards!

## Assigning Tasks through buckets in Microsoft Project for the Web

Hi,

today I will show you how to see Task assignments, and how to Assign Tasks automatically using Buckets in Microsoft Project for the Web.

Fist of all I will create a new Project, and some Tasks with some assignments:

I will switch to Buckets, following next steps:

and I will get:

As you can see, here I can see Tasks grouped by assignees. Notice, for example, Task 4. Since Ellen, John, and Mary are assigned to that Task it is show under each of those Resources. So, this does not mean that I have three Tasks with name: Task 4, but it means that it is one Tasks assigned to multiple Resources.

Let’s say that I want to assign Task 5 to myself. The easiest way is to drag and drop this Tasks to the Column with my name, and I will get:

But what if I want to assign this Task to Jim, as well? Then I will click on that Task and I will follow next steps:

and I will get:

As you see Tim’s Column is added and Task 5 is placed in this Column as well.

This is a great thing in Microsoft Project for the Web, because you can see who will work on which Tasks, and also it it easy to assign or reassign Tasks directly to the right person.

Regards!

## Can we change a Group in Microsoft Project for the Web?

Hi,

today I will show you how to handle the situation in which you assign wrong Group to the Project, using Microsoft Project for the Web!

First, I will create a simple Project:

As you know, resources can be assigned Via Groups, so I will now choose a Group:

OK, now I can assign anyone from this Group to any Task:

Now, let’s say that you choose wrong Group, and you want to change it for the right one! How can you do it? Well, you can’t!

So what are the options? Of course you do not want to recreate the same Project from the Scratch! What you can do is to copy Project:

After this action, you will have a Copy of your Project but without any Group, so you can choose the right one!

Regards!

## What is not copied when you Copy Project in Project for the Web?

Hi,

today I will show you what is happening when you copy a Project in Microsoft Project for the Web!

Let’s say that I have Project like this:

¸

For this particular Project, I am using following Group:

I also have attachment in Task 2:

Now, I will going to copy this Project:

and I will get:

Notice that % Completeness are not copied (e.g. all Tasks are in not started state). As you can see there are no assignees to Tasks. Why? Because there is no group Associated with this copied Project. So, Group is not inherited form the old Project. And last, but not least:

Calendar template is not copied, as well.

To conclude, when you copy a Project follow next steps:

1. Rename a Project
2. Assign Calendar Template
3. Associate the Group for the Project

Regards!