How to Use

SharePoint Workflows for Project Management

When planning a project, it’s easy to get excited about the outcome – a new website, launching your product into a new market, an overhaul of the company intranet.

 

Regardless of the outcome, duration, or project management approach, all projects rely on tasks to reach the end-point.

Tasks are the essence of project management. Improve task management and you can save time, avoid rework, and deliver better results.

Implementing workflows to automate tasks is a significant step towards controlling and improving project outcomes.

In this practical guide, we’ll cover the basics of workflows before reviewing SharePoint workflows for project management. You’ll learn how to get started with out-of-the-box workflows before moving onto SharePoint Designer, Microsoft Power Automate, and Nintex for more complex automation.

Free SharePoint Project Management Template

Get started in minutes with a simple project management template for teams using SharePoint 2019/2016/2013/2010

Chapter 1.

Workflows: An Overview

A workflow is an optimal way of getting work done in a logical sequence. Often represented as a diagram, a workflow links together small tasks to achieve a larger end goal.

 

You are likely using workflows on a daily basis without realizing it!

Examples of workflows include:

  • Submitting a vacation request.
  • Sending a purchase order to accounts for approval.
  • Collecting feedback on a document.
  • Moving documents uploaded to the wrong library in SharePoint to the correct library.

 

 

Project Request Mgt Workflow

 

Above is an example of a workflow for managing new project requests. The process starts with a draft and moves through each stage using automated emails. Once reviewed, the reqest can be sent back to a previous stage for more details. The workflow ends when the request is rejected or approved.

Workflows can take any length of time and can be delivered by one person or an entire team. It really depends on the goal at-hand.

However, the aim is always to move between steps efficiently, freeing up time and energy for important tasks.

Workflows frequently combine human and automated actions.

  • The task of creating a new project presentation may be assigned to a member of your team (a human, manual input).
  • Once the document is uploaded to the system, an approval workflow could be trigged, which sends an automated email to the relevant person (an automatic action).

 

Each part of a workflow must have a relationship with a previous step.

Using the example of a vacation request, imagine you receive an automated email to review a new request from a team member.

This email is trigged when the request is added to an online system and requires a response from the approver (you). You can choose to approve or deny the request, which will trigger another automated email to the original requester. Each piece of the workflow depends on a prior action until the workflow is complete.

Workflows allow users to return to a previous step in the process as needed. Let’s say you reject the new vacation request as it clashes with a key project milestone.

You simply mark the request as ‘rejected’ to send an automated email to the original requester. The individual can amend the dates and resubmit the request, thus re-starting the process.

Workflows were invented by Henry Gantt in the 1920s as a way of optimizing work. Gantt documented processes by asking three key questions:

  • What tasks were being done?
  • Who was responsible for each task?
  • How long did each task take?

 

The same principles still underpin workflows today.

Workflows represent business processes, ways of completing work in your organization. They provide a framework for completing a task the same way every time by any individual. Once the process is mapped as a workflow, issues are more easily identified and addressed.

However, a workflow and a process are not the same:

  • A process refers to the data, reports, forms, decisions, and so on needed to complete the task.
  • A workflow is a sequential ordering of the tasks and is part of processes.

 

Imagine you need to create a detailed project plan for review by senior management. You can easily build an approval workflow to share the document when it is uploaded to a document library. In addition to sending an initial email, you can also automatically send reminders if the document is not reviewed by a certain date.

However, you will use a larger process for creating the project plan such as gathering data for a business case and creating a draft schedule.  Going even further back, you may need to ask an internal subject matter expert for their input and speak to senior managements to gain support for the project.

A process defines all of the deliverables for a task. A workflow helps to deliver that task in an optimized way.

 

Elements of a Workflow

Workflows are made up of four components. Let’s take a closer look at each component using the above example of a vacation request.

  • Actors, people or software responsible for the task. In this case, team members log a new request to a HR portal. This triggers an automated email to managers for review.
  • Activities, the task that is performed, often represented as a step. Here, this includes logging and reviewing the request.
  • Results, the desired outcome of each step – ideally, approval for a vacation!
  • State, the movement between step. In this case, the request moves from ‘draft’ to ‘review’ to ‘approved or rejected’ with minimum effort.

 

Each step of a workflow has three parameters as follows:

  • Input, the resources needed for a step.
  • Transformation, what actually happens to the input, for example, making a decision about the vacation request.
  • Output, the outcome of the step, which often act as input to the next step.

 

Finally, there are different types of workflows.

  • Process: A process workflow refers to predictable and repetitive tasks. The workflow has a clear path with few variations, for example, a project plan is either approved or rejected.
  • Case: A case workflow has an unclear path to conclusion, for example, a support ticket.
  • Project: Project workflows are similar to process workflows with a little more flexibility to meet the needs of individual projects. These workflows help to drive the project forward.

 

Now that you know more about workflows, it’s time to review the benefits of workflows and their application to projects.  As you’ll see, workflows are a powerful way to boost productivity and help your project team to work effectively.

 

Benefits of Workflows

As mentioned above, workflows create a framework for completing work in an agreed, repeatable way.

Workflows offer numerous advantages to organizations including:

  • Less time and effort on administration work.
  • Standardized processes across all teams.
  • Easier compliance with regulatory requirements.
  • Reduction in errors, rework, and risk.
  • Improved communication.
  • Opportunities for continuous improvement.
  • Increased transparency with clearly defined responsibilities.

 

Project teams can leverage workflows even further. When applied to projects, workflows help to:

  • Make deadlines easier to predict with clearer insight into the duration of tasks.
  • Improve resource management and allocation.
  • Increase visibility for stakeholders with approval workflows and notifications.
  • Provide easy-to-follow instructions for tasks.
  • Improve collaboration with more insight into individual responsibilities and progress.
  • Eliminate redundant or duplicated effort.
  • Create an audit trail for key decisions.
  • Quickly introduce new team members to the project.

 

Project managers can also use workflows to monitor the status of tasks using automated emails and track new issues, reducing the need to constantly ‘check in’ with the team.

Workflows help to streamline non-project work, such as blocking out time on a calendar, creating tasks from important emails, and tracking expenses in Excel.

With workflows running in the background for various tasks, you can focus on the project itself and deliver the expected results more smoothly.

 

Hopefully, you are ready to start using workflows on your project. There are two points to consider before jumping in – what processes do you want to automate with workflows and how will you manage these workflows?

We’ll take a look at best-practices for creating workflows in Chapter 2 and how to use SharePoint workflows in Chapter 3. SharePoint offers out-of-box workflows for a fast start, with the ability to build custom workflows as needed.

Chapter 2.

Best Practices for Creating Workflows

Before you can create a workflow using software, you need to explore and document the process you want to automate.

 

To do this, host a workshop with relevant end-users to walk through the process from start to finish as many times as needed. Use a whiteboard to draw and re-draw the process until everyone agrees on the steps.

The trick is to focus on the current process, not the ideal process. In time, you can identify improvements for the process but it must be documented in the ‘as-is’ state initially.

It’s also important to avoid focusing on exceptions – again, you have to figure the ‘as-is’ process.

Make sure to cover key elements like:

  • The start and end point
  • Inputs
  • Outputs
  • Key activities
  • Task owners
  • ‘What-if’ scenarios, for example, what if a developer is not available for a task?
  • Documents associated with any steps.

 

Once the as-is process is documented, it’s time to create a visual representation, like a flow chart.  This is your workflow.

Shapes are frequently used to classify elements of the process in an easy-to-understand way.

Depending on existing guidelines within your organization, you can use the standardized system of symbols for process maps from Business Process Model and Notation (BPMN)

According to these guidelines: 

  • A circle is used to mark an event, such as the start of the process.
  • Rectangles indicate  tasks.
  • A diamond is a decision point
  • An arrow marks the flow or movement between tasks.

 

 Below are some examples of business process maps from the BPMN site:

 

 

 

 

When documenting the various steps of the process, avoid too much detail. If one person can complete a task alone, it’s best to use a single box to represent this step.

Having created the workflow, it’s time to make improvements. Think about:

  • Automating tasks using software.
  • Removing unnecessary steps.
  • Tasks that can be completed simultaneously.

 

Ask the team to review the final workflow before automating tasks with software.

So far, we’ve covered the basics of workflows and how to create a workflow with your team. The next step is leveraging software to automate as many elements of the workflow as possible. In the next chapters, we’ll explore how to use SharePoint workflows for your projects.

Free SharePoint Project Management Template

Get your projects under control quickly with a pre-planned template for SharePoint 2019/2016/2013/2010

Chapter 3.

Getting Started with SharePoint Workflows

SharePoint workflows are “pre-programmed mini-applications that streamline and automate a wide variety of business processes.”

 

The purpose of SharePoint workflows is to help people collaborate on documents and manage tasks easily in a SharePoint site.  Uses of SharePoint workflows include:

  • Document approval
  • Collecting signatures or feedback
  • Managing new project requests.

 

SharePoint workflows run on lists and libraries. There are three types of SharePoint workflows:

  • A list workflow is used on a list or library. This type of workflow cannot be copied to another list. These workflows are often trigged by an event, for example, the creation of a new list item.
  • A reusable workflow is created at site level and is available in other sites.
  • A site workflow is not connected to a list or content type, and can be used anywhere in a site. Examples include archiving completed tasks in a project site at the end of each day. This workflow must be triggered manually.

 

Using SharePoint workflows depends on permissions:

  • To add a workflow, you will need the Manage Lists permission. This is added by default to the Owners group (full site control).
  • To start a workflow, you will need the Edit Lists permission, available to the Members and Owners group.

 

As explained below, a site administrator must add certain workflows to a site collection.

SharePoint ships with five types of workflows. These workflows are available with every version of SharePoint.

Note –  if you are using SharePoint 2010, you will build workflows on the SharePoint 2010 workflow engine only. SharePoint 2019/2016/2013/Online can use the SharePoint 2010 or 2013 workflow engine.

Let’s take a look at each workflow in more detail.

 

5 SharePoint Workflows

1. Approval

The Approval Workflow is used to a share a document or an item in a SharePoint list or library with one or more individuals for approval. When adding the workflow to your site, you can:

  • Specify how many people to include.
  • Decide if the tasks will run one after another (serial) or all at once (parallel).

 

The workflow can be trigged manually or automatically, for example, each time a document is added to the project library.

Once trigged, the approval workflow assigns a task to each specified individual. They can approve or reject the item, request a change, or cancel the task.

 

SharePoint Approval Workflow

 

Individuals involved in the workflow cannot change the item being review; instead, they can send the document back for updates. If you need to gather feedback, use the ‘Collect Feedback’ workflow as described below.

You can add multiple instances of the approval workflow to a site.

By default, this workflow must be activated by the site administrator at the site collection level.

 

2. Collect Feedback

The Collect Feedback Workflow is used to gather feedback on a document. The workflow set-up is similar to the approval workflow and you can add multiple instances of the collect feedback workflow to a site.

 

SharePoint Collect Feedback Workflow

 

 

When adding this workflow, you need to consider how the feedback will be collected:

  • Leave comments on the task form only.
  • Insert track changes and add comments to the item itself.

 

If individuals can edit the document directly, you will need to decide how this process will work. There are two options:

  • Collaborative environment, allowing multiple individuals at work on the document at the same time.
  • Sole-access environment, requiring each individual to check out the document for review.

 

This workflow must be activated by the site administrator at the site collection level.

 

3. Collect Signatures

The Collect Signatures Workflow is used with Word documents, Excel workbooks, and InfoPath forms.

 

SharePoint Collect Signature Workflow

 

Again, this workflow runs in a similar way to the above workflows and must be added to the site by the site administrator.

Before starting the workflow, you must add signature lines for each required individual.

Once a signature is added to the signature line, the document is locked from all changes aside from adding more signatures.

Inserting or deleting a signature line after the first signature is added counts as a change. If a line is inserted or removed, previously added signatures are removed from the document.

To add your digital signature to a document, you must have a digital certificate to prove your identity to relying parties. This can be obtained from a reputable certificate authority (CA).

 

 

4. Three-state Workflow

The Three-state Workflow tracks the status of a list item, like a task, through three states or phases.

The workflow can be used with any list that has a choice column with three or more values, for example, not started, in progress, and done.

 

SharePoint Three State Workflow

 

The workflow will only work with one choice column and three choices. You will need to specify the column and choices when adding the workflow to a list.

When the workflow is started, the relevant individual is assigned a task, for example, write new copy for a website. Once the task is marked as complete, the workflow updates the status, and moves the task into the next step, such as review.

To help relevant individuals work on their tasks, you can add extra information to each step of the workflow. This can include:

  • Task title
  • Description
  • Due date
  • Assigned to.

 

5. Publishing Approval

The Publishing Approval Workflow is used for publishing new sites. It is not used for publishing site collections.

 

Managing workflows is quite straightforward using the Workflow Status Page. This page lists the following information:

  • Name of the person who started with workflow.
  • Start date and time.
  • Date and time of the last run.
  • Name and link to the document or item used in the workflow.
  • Current status.
  • List of tasks assigned to the workflow participants.
  • List of all events in the history of the workflow, for example, task creation.

 

 

Note – the history of a workflow is maintained for 60 days after the workflow is complete.

 

Video: Collecting Document Feedback Workflow

It’s time to get practical with a short demonstration. In this video, see the Collect Document Feedback Workflow in action.

 

SharePoint Document Feedback Workflow

 

 

These five out-of-the-box SharePoint workflows should cover most requirements on a project, helping to save time and improve collaboration.

They are an easy-to-use starting point. If you need to create custom or complex SharePoint workflows for your project, you can use SharePoint Designer, Microsoft Flow, or Nintex.

We’ll delve a little deeper into each application in the next three chapters.

Chapter 4.

SharePoint Designer

SharePoint Designer is used to build and customize SharePoint sites and applications, including workflows.

 

The free program is a powerful way to manage SharePoint sites without the need to write code.

Although Microsoft no longer make this application, you can continue to use the 2010 version with SharePoint 2010, and the 2013 version with SharePoint 2019/2016/2013/2010/Online. Microsoft support for SharePoint Designer will end in 2026.

SharePoint Designer uses several common elements in a workflow.

  • Events: how the workflow is triggered.
  • Conditions: A clause that determines the action, for example, if a new document is uploaded to the library, send an email to the project manager.
  • Actions: Tasks that do something, such as send an email.
  • Variables: A way to store values, like a name of a project manager, in a workflow.
  • Steps: Steps are used to group conditions and actions together. The rules in one step are applied before moving to the next step. In SharePoint Designer 2013, stages replace steps.
  • Forms: Workflows often use forms to collection information, for example, updating the status of a task.

 

To use SharePoint Designer 2013, install the free program onto your desktop and connect to a SharePoint site.

SharePoint Designer 2013 also well works with Visio 2013 (a diagram tool), allowing you to import workflows from one program to another and vice versa.

 

Video

In this training video, see how to build a custom workflow to update the project statement with comments from the project status report using SharePoint Designer 2013.

 

SharePoint Designer 2010

Free SharePoint Project Management Template

 Leverage your existing SharePoint 2019/2016/2013/2010 environment with a best-practice template 

Chapter 5.

Microsoft Power Automate 

Microsoft Power Automate is a new way to automate workflows across apps and SaaS services.

 

A no-code solution with numerous pre-planned templates, Microsoft Power Automate (previously Microsoft Flow) connects to over 200 apps, including SharePoint. The application can be used with SharePoint On-Premises with the on-premises data gateway.

Microsoft Flow

 

Unlike SharePoint Designer, Microsoft Power Automate also works with non-Microsoft apps, such as Google Drive and social media platforms like Twitter.

Microsoft Power Automate includes several types of workflows, called ‘flows’:

  • Automated, trigged by an event.
  • Button, manually trigged and used to create flows on the mobile app.
  • Scheduled, which run at certain times.
  • Approval, used to manage approvals for key documents.

 

You can customize existing templates or create a flow from scratch as needed. However, Microsoft Power Automate is not as mature as SharePoint Designer, so you may wish to use the latter for more complex workflows.

The addition of robotic process automation (RPA) was announced during the 2019 Microsoft Ignite conference. RPA refers to the use of bots to emulate how people complete tasks. Users can record and play back how they interact with software systems, and then create bots to automate these tasks.

Pricing for Microsoft Power Automate starts at $15 per user per month.

To start using Microsoft Power Automate, log into Office 365 and use the app launcher to open the program. From the Microsoft Power Automate homepage, you can:

  • Get started quickly with templates.
  • Check available connectors.
  • Manage your flows.
  • Create a new flow.

 

Let’s create a flow using an existing template.  In this example, we’re going to create a task for high priority emails. This could be useful for staying on-top of urgent requests from project stakeholders!

Start by accessing Microsoft Power Automate in the Office 365 app launcher.

 

MS Flow Office 365 Launcher

 

You can use the search bar to find a template or click the Outlook.com icon on the homepage to view existing flows.

MS Flow homepage find a template

 

 

Next select the template called ‘New Task for High Priority Emails’.

Sign into Outlook.com and Outlook tasks with your Microsoft account and press continue.

MS Flow Create a Task Flow

 

 

On the next screen, you’ll see how the workflow is constructed. Microsoft Power Automate is a highly-visual tool, simplifying the management of workflows.

Here, you can add extra information such as email sender, subject filter, and a date for the task reminder.

MS Flow Create a Task Flow Options

 

Save the flow.  The next time you receive an email marked as high-importance, a task will be automatically added to your calendar.

In the image below, a task, ‘Latest Project Feedback’, was added to a calendar from a high-importance email.

MS Flow Create a Task Flow New Task

 

You can also customize the flow by adding new steps with actions and triggers.

At any time, you can check the status of a flow under ‘My Flows’.

 

MS Flow Manage Flows Menu

 

In this area, it’s easy to:

  • Edit individual flows
  • Share flows with a team member
  • Check the history of a flow.

 

To see more details on a flow, simply click the name of the flow.

 

MS Flow Manage Flows Status

 

How can you use Microsoft Power Automate to easily create workflows for your project? Here are some templates to consider using. Remember, you can customize an existing template or build a flow as needed.

 

There are several SharePoint templates to try, such as:

Chapter 6.

Nintex Workflows for SharePoint

A third option for creating SharePoint workflows is Nintex, a platform for optimizing business processes.

 

Nintex is a no-code, point-and-click solution used to automate project management processes such as status reporting and risk management.

 

Nintex interface

Creating a status reporting workflow with Nintex

 

Nintex integrates with BrightWork, a project and portfolio management solution for SharePoint.

Nintex workflows can be added to BrightWork project site templates, helping to improve project standards throughout the organization.

Let’s look at three ways to use Nintex to create project management workflows on SharePoint: automated status reporting, automated exception reporting, and project request management.

 

Automated Status Reporting

Projects are often tracked by phase. As tasks are completed, the team moves towards the completion of a phase.

With Nintex workflows, it’s easy to set an automated alert to stakeholders about the completion of a phase and the requirements for the next phase.

Automated Status Reports

 

Automated Exception Reporting

Senior executives use BrightWork portfolio templates to get high-level visibility into the health of projects throughout the organization.

Nintex workflows increase visibility even further, for example, creating a new activity when a risk is logged or a key milestone is missed.

Automated Exception Reporting

 

Project Request Management

The Project Request Management template from BrightWork allows senior executives to review and approve or reject new projects in one place.

When combined with Nintex LazyApproval, approving projects is even faster. Using this workflow, stakeholders can approve new project requests via email by simply replying with the word “Approve”. This also creates a new project site automatically.

 

Flexible Project Request Management

 

 

Conclusion

Workflows are powerful productivity tools with significant benefits for project teams. If you are using SharePoint for project management and have not yet dived into workflows – what are you waiting for?

Start with the out-of-the-box workflows described in Chapter 3, and in time, evolve to complex workflows with SharePoint Designer, Microsoft Flow, and Nintex.

Below are additional resources and on-demand webinar recordings to help you get started.

Resources 

Introduction to Workflows

 

SharePoint Workflows 

 

Microsoft Flow

 

Nintex

Free SharePoint Project Management Template

Get started in minutes with a simple project management template for teams using SharePoint 2019/2016/2013/2010

Created By

GW Pillar page

Grace Windsor

Read more SharePoint and project management articles from Grace!

Pin It on Pinterest

Share This