Project management software

Microsoft 365 for Construction Management Case Study Part 2: Project Online

Case Study | November 7, 2022

This article is part two of our case study examining how we helped one of our clients manage their construction projects better with Microsoft 365. If you have not read the first installment, you might want to check out part one of the case study before proceeding.

The client in this case study contracted Lydon Solutions to develop a Microsoft 365 project management solution for a multi-billion-dollar program with over eighty active projects. In our first post, we outlined the client’s project needs, including how they currently handled these tasks and how we planned to help them improve their workflows with Microsoft 365 and its related applications.

One primary requirement of our client was integrating Microsoft Project into their overall project management solution. This article will detail our approach to creating a solution centered on Project.

A quick primer on Microsoft Project

Before we get into our client’s challenge, it might be helpful to review the evolution and status of Microsoft Project since the nuances affect the solution you can implement.

Microsoft Project is several different applications rolled into one:

Microsoft Project desktop application

The desktop version of Project is the application we all have used for years. Most construction companies have Project Standard or Project Professional installed locally on their computers.

The desktop version of Project is the most feature-rich version of the application but is not connected to the internet unless you pay for a Project Online subscription (see below). You need the more robust Project Professional to create complex schedules (beyond predecessor logic) and assign organizational resources and custom fields. You can do project-specific reporting in either desktop version of Microsoft Project.

Microsoft Project Online (Project Web App or PWA)

Microsoft Project Online is the web-enabled version of the application. With this version, you can manage a portfolio of projects, create Microsoft Project and SharePoint templates and sites, create and share company resources and custom fields, implement timesheets, and connect to the desktop Project application.

You can update schedules in PWA, but the functionality is limited to predecessor logic. You need Project Standard or Professional for more complex scheduling, organizational resource management, custom fields, and project-specific reporting. Note: PWA schedules do not integrate with Project for the Web (described below) since the app stores schedule data in SharePoint sites. You need Power BI to do multi-project reporting.

Microsoft Project for the Web (PFTW)

Microsoft Project for the Web is a more flexible, dynamic, and modern scheduling version of Microsoft Project. PFTW appears to be the future of Microsoft Project, but the development roadmap has been moving at a glacial pace.

Organizations trying to use both PWA and PFTW can confuse users since PFTW is a lightweight scheduling tool that looks and behaves differently than PWA, but both are considered Project Online. PFTW has similar functionality as PWA, but it does not integrate with PWA schedules or schedules made in the desktop version. PFTW is a stand-alone modern application that stores data in the dataverse, not SharePoint. You need Power BI to do multi-project reporting.

Now that we got that out of the way, you can see why the complexity of the Project ecosystem and how the various features and differences between the versions can create additional challenges when trying to develop a solution.

How our client used Microsoft Project

Our client was using Microsoft Project Online (PWA) to manage their portfolio of projects. The other factors we had to consider included the following:

The client’s project managers (PMs) did not want to use Project to update their schedules and instead leveraged construction coordinators to provide schedule updates on their behalf. Management wanted to change this behavior so that PMs were responsible for their updates but the solution needed to be as easy as possible.
The PMs did not have the desktop version of Microsoft Project to update schedules.
The PMs wanted to use Project for cash flow forecasting across projects.
The PMs wanted weekly reporting on all scheduled milestones and late tasks by Project but had not set up zero-duration milestones in their schedules.
There were over 80 active projects in their Project Online project center

Our approach to making Microsoft Project the core of the client’s solution

From experience and discussions with the client, we knew that email was the easiest way for PMs to update schedules.

We designed a solution to aggregate project schedule and task data across all projects from PWA into a centralized SharePoint list daily. We developed a Power Automate workflow to send emails with adaptive cards to the PMs when their tasks were due so that they could update them in Outlook without having to go into Project. The SharePoint list received the task updates, and another Power Automate workflow processed the updates back into PWA. Other parts of the solution leverage this same SharePoint list, providing a single source of truth for projects without users needing to interact with the Project application. We will explain further in a future post.

Next, we needed to use Project schedules for cash flows. For this, we had to be able to assign a cash flow resource to the schedules. Doing so would allow the schedules to drive the cash flow amounts. So, we created new cash flow enterprise resources for the organization in the PWA resource center. We created both budget and generic resource types. We established cost budget resources as the overall project budget at the project summary level (task 0) in Project. We used cost generic resources to assign the cash flow amounts for cash flow milestone activities at the task level.

We then created new cash flow milestones in Project with the schedule logic of how pay apps would be submitted and approved. Since cost generic resources represented our budget at the task level, the actual cost would update automatically when a user marked a cash flow milestone task as 100% complete.

For reporting, we leveraged Power BI to provide cross-project cash flow reports. There is a Power BI web app connection that you can leverage to access PWA data. This connection includes the Microsoft Project data lists so you can generate reports in Power BI. We’ll get into the details of how we developed the reports in a future post.

Do more with Microsoft 365 and Project

Find out how to take Microsoft 365 and Project to the next level by submitting a free consultation request. If you prefer a turnkey project management solution powered by Microsoft 365 and SharePoint, check out Construction Viz and our extensive lineup of construction apps.

Track construction project issues and tasks using Microsoft Lists

How-To | March 21, 2022

Microsoft 365 Lists is a simple and easy-to-use application that can help you keep up with all the items you need to track on a construction project. Read on to understand how Lists work and some considerations when implementing the tool on your next project.

Microsoft Lists is an app within Microsoft 365 that allows you to create a configurable grid of data shareable with your team members. You can use it to track just about anything on a construction project, from action items to submittals. Lists might be the right solution if you are looking for a simple way to collect data and share it with your project teams.

Microsoft Lists UI

Microsoft released Lists in 2020 as a separate but still connected app to SharePoint. While Microsoft has upgraded the UI for the app, the underlying settings menu system remains the same as the SharePoint List app. There are web-based, desktop, and mobile versions (for iOS now and Android soon) of the Lists app so you can interact with the data across all of your devices.

SharePoint List Settings

As it relates to construction, Lists is excellent for spinning up a quick issue tracker or simple item/asset tracker with data viewable in a grid UI. The app has all the features you would find in a SharePoint Lists, including adding custom forms, workflows, and reports by leveraging Microsoft 365 Power Platform (Power BI, Power Apps, and Power Automate), which deeply integrates into the Lists menu system.

Lists integration with the Power Platform

Create your first list with Microsoft Lists

You can create your lists from SharePoint, the List app, or even Microsoft Teams. To add a list within Microsoft Teams, click "add a tab" and select the Lists app (see screenshot below).

Microsoft Lists app in Teams

To create a list from the Lists app, click "Create a List." You have the option of selecting different list types, including an empty list, a list from Excel, an existing List, or a template. Once you choose a list type, you will have the option to save the data to either SharePoint, Teams, or your personal storage.

If you want to customize the list further, the cog in the upper right-hand side of the screen displays the settings. Since Lists operates on top of Microsoft SharePoint, the cog directs you to the familiar SharePoint list settings page, where you can add columns, grouping, filters, and sort your list as needed.

List types available in Microsoft Lists

List types and how to use them for construction projects

Blank list

If you want to start from scratch, you can name the list and configure it as needed. This approach might be best if you are still brainstorming the columns (metadata) you would like to track or don’t want to use the list templates available.

List from Excel

If you have an Excel file that you have been using to manage issues on a project, you can upload your existing Excel file into a list. To do this, you must first create a table within the Excel file to identify what rows and columns you want to upload. You can let Lists assign column types to the data, such as single line of text, number, etc., or you can edit the table when it is uploaded.

Defining the correct column types is critical to ensure the list behaves as you intended if you want to group and summarize values which won't work if the column is a single-line text field. The column names will be used from your Excel table by default, but you can change these before importing the data. Note: if you take this approach, SharePoint will assign internal columns names using the convention field_n, where n is a sequential number for the list columns from left to right. Meanwhile, the 'real' column names you assigned will display on the list. Remembering this detail is important because in many cases (such as Power Automate, Power BI, and PnP, for example), you need to know the internal names to interact with the list.

From an existing list

If you have already built out a list, like an issue tracker, you might not want to create a new one for every project. You can re-use an existing List that resides in a SharePoint site or Teams. Note: Be aware that although document libraries are also lists, you cannot connect the Lists app to a document library!

List from a template

Microsoft Lists has several pre-defined templates that are available to use as a starting point, such as issue tracker, asset manager, and content scheduler. You can also create your own list templates that you might want to make a standard across your projects.

What to consider before using Microsoft Lists for construction projects

While Lists is an app that users can access directly, you can also create and share lists through SharePoint or Teams. Don't forget to consider how lists get updated and how users generate reports as part of the overall solution.

Microsoft Lists allows users to attach files to lists. Depending on the complexity of the list solution needed, you may want to have attachments stored separately in a location where you can better manage them, such as a SharePoint document library or OneDrive.

Microsoft is looking to release a new stand-alone version of Lists that does not require a Microsoft 365 license. So, if you like Lists but don't want to have to pay for a Microsoft 365 subscription, you might be able to save some money by waiting for this version to be released. This stand-alone version is now in preview, and you can take a look here: Try Microsoft Lists with your Microsoft account Preview.

If you are using Microsoft 365, then the Lists app is a no-brainer for simple tracking. There are many different uses for Lists that can benefit a construction project. Give it a try!

Also, if you need help setting up Microsoft 365 to manage your construction projects, you can check out this three-part blog article series or reach out to us directly for a free consultation.

Got Microsoft 365? Use it to Manage Your Construction Projects

Construction Viz News | February 14, 2022

If you have Microsoft 365, it’s a no-brainer to leverage your investment to manage your construction projects. Unfortunately, most organizations don’t have the time or resources to build even small construction-specific solutions in-house, never mind a complete project management information system (PMIS).

Construction Viz makes it easy to manage projects in Microsoft 365

Construction Viz is a powerful and flexible construction project management software solution optimized for YOU and your workflows. We designed it to include everything you need to manage your construction projects, including document management, dashboards, reports, forms, workflows, and more.

Construction Viz features include:

Can be delivered as a hosted solution or deployed to Microsoft 365
Extensive catalog of construction applications for any size project
Powerful reports and dashboards
Responsive on any device
Offline capable
Built-in integration with Microsoft 365
Full construction document management

Construction Viz is available in the cloud, on-premise, or as à la carte apps for Microsoft 365 and SharePoint.

What makes Construction Viz different from every other PMIS on the market?

Construction Viz is an enterprise PMIS for Microsoft 365. It has all the features you need to manage your construction projects at less cost than competitors because it can be deployed into your Microsoft 365 tenant.

Construction Viz is all about providing organizations with the ability to choose where and how they want to work.

Construction Viz gives you the power to decide each of the questions below.

Where do you want to work?

Construction Viz empowers you to work where and how you prefer:

Construction Viz can be deployed to your Microsoft 365, on-premise SharePoint, or hosted in Lydon Solutions’ data center. We can even deploy your uniquely configured solution to other Microsoft 365 tenants (owners, contractors, etc.).
Want to work offline without an internet connection? Not a problem. Because Construction Viz is a progressive web app (PWA), the entire solution can go offline.
Want to work entirely in email or Microsoft Teams? We can extend the functionality of Construction Viz using adaptive cards, so you don’t even have to log in to the application.

What features do you want in your PMIS?

Construction Viz lets you decide which features you need:

Unlike most PMIS systems, where you only use 10% of the product but pay 100% of the cost, Construction Viz is app-based, so you only pay for the apps you need.
We have a full suite of construction apps for any size project, from an owner to a contractor across any sector.
Want a custom solution? We have you covered. Construction Viz is a framework designed to adapt to your processes. All our apps are configurable and customizable to your needs and are extendable with Microsoft 365 services such as Power Automate.

What if you are already using Microsoft 365 and SharePoint?

If your organization already uses Microsoft 365 and SharePoint, Construction Viz can take your project management practices to the next level:

Already have a solution and only need a few apps? No problem. You can pick only the ones you need from our list of robust construction applications.
Want to leverage what you have developed in SharePoint or the Power Platform? Also, not a problem. We can bring your prebuilt functionality into Construction Viz.
Aren’t ready to deploy in your Microsoft 365 just yet? Again, no problem. Start with a hosted deployment, and we can move to your Microsoft 365 when ready.

Sounds great. Where do I start?

You can submit a free consultation and demo request here.

If we seem like a good fit, we’ll move into the Formulate phase of our FOCUS Methodology. As part of our FOCUS Methodology, we’ll evaluate your current Microsoft 365 infrastructure and determine the best approach. Construction Viz might not be the best fit at this time, and that’s OK. You might just need a tune-up of your Microsoft 365 with redesigned SharePoint project templates, or maybe a couple of Power Automate Flows, Power Apps, or some Power BI reports. Either way, we are here to help.

If you still aren’t ready, you can join our newsletter in the footer below. We mail out helpful Microsoft 365 tips and tricks, updates on Construction Viz features, and Microsoft 365 and Construction Viz news each month.

The 1 tool you should consider for project brainstorming

Reviews | January 18, 2022

Microsoft Whiteboard is a brainstorming and collaboration tool for Microsoft 365. It is available as a browser-based application and a standalone tool that integrates with Microsoft Teams. The Whiteboard app allows for real-time collaboration with team members, in an easy to use non-structured way, across devices using a mouse, stylus, keyboard, or even your hands.

To fully appreciate the Whiteboard app, it is interesting to consider the evolution from capturing notes on a chalkboard to show to people in the same room to an easy-to-use app that you can download and within minutes share your ideas with the entire world. Let's consider the history:

1800s – The invention of the chalkboard. Most of us grew up with chalkboards made from slate and written on with sticks of chalk derived from calcium sulfate or calcium carbonate. Chalkboards still find a use today, mainly because they are relatively inexpensive, but the downside is that you still must take notes before someone erases your work.
1960s – The coming of the whiteboard. Albert Stallion created the dry erase board from enameled coated steel. He went on to start Magiboards, a company selling whiteboards in the mainstream. Whiteboards are relatively low cost and, just like chalkboards, are still in use today. They provide a more natural surface for writing, do not create dust, can be magnetized, and work well with overhead screens but, like the chalkboard, they still require taking notes to retain work.
1990s – PCs and the introduction of SMART Boards. The advent of personal computing created new opportunities for capturing and sharing notes. SMART Technologies introduced the SMART Board, interactive whiteboards using LCD screens attached to computers. Like whiteboards, they are still in use today. When SMART Boards came to market, they were expensive, but they allowed users to save images of the screen and application files and then share them via email or hard copy with participants of the meeting.
2000s – The Internet, touch screens, Microsoft 365, and the Whiteboard app. When all the right technologies line up, you have the opportunity to redefine the space. The Microsoft Whiteboard app leverages the latest technologies to the fullest and addresses all the shortcomings of prior technologies by providing the ability to collaborate in real-time across multiple devices of varying types.

Why Microsoft Whiteboard is great for construction projects

So, what’s so great about the Microsoft Whiteboard, and how would you use it for your construction projects?

The Whiteboard app shines when your team is on Microsoft 365, your users have touch screen devices, and your team needs an easy way to share ideas fluidly. Getting started is simple. You simply create a canvas and invite your team members. Your team can add images, documents, tasks, notes, text, lists, and freehand drawings. The app saves those files to the cloud automatically, and they can be opened and edited at any time. Further, you can share your canvas with users, with the ability to post to Teams and export as SVG and PNG image files.

For a construction project, you could use the Whiteboard app for the following:

Mark up PDF drawings using text and insert notes as needed.
Create a plan of the day (POD) for fieldwork, complete with images, maps, documents, and a formal task list.
Brainstorm new ideas and processes using free-form text, notes, and related images.
Review documents by adding pages from a Word document to your canvas and then using free-form text to insert notes as needed.

Once you create a Whiteboard canvas, you can post it to Microsoft Teams, where a link will display in the Posts tab of a Team. Team members can click the Whiteboard link in the Post, and the canvas will open for viewing and further editing.

While Whiteboard is a powerful tool and a technology revolution since the chalkboard days, there are a couple of concerns to keep in mind. First, you cannot currently access the actual Whiteboard files that the app automatically stores in Microsoft Azure. Second, you do not have the ability to permission control the files outside of the users with whom you have shared the Whiteboard files.

I encourage you to give the Whiteboard app a try. Like any other Microsoft software, they will likely continue to enhance it over time. If you need any help with Microsoft 365, check out our Microsoft 365 Managed Services and sign up for a free consultation.

If you are interested in a prebuilt enterprise-ready project management information system for your Microsoft 365, have a look at Construction Viz. You can submit a demo request there to find out more.

Using Microsoft Power BI for Reporting with Project Online

How-To | December 7, 2021

More than likely, your organization uses the project-specific reports available out of the box with the Microsoft Project desktop application. But as your portfolio grows, you may need to move to Microsoft 365 Project Online. Project Online offers many advantages over the desktop version, including enterprise resources and codes, permissions management, project templates, and integration with the Microsoft 365 Power Platform. Unfortunately, you will quickly realize that there are no canned reports in Project Online like those you are familiar with in the desktop application. So, what do you do?

Using Microsoft Power BI to create Microsoft Project Online reports

The “official” reporting solution for Microsoft Project Online is Power BI. Power BI is another Microsoft 365 subscription. If you are going to build custom reports, you may want to have at least one Power BI Pro license. Note: Power BI Pro comes with a Microsoft 365 E5 subscription or is available for $9.99/user/month for an individual license.

Next, you will want to install the Microsoft Project add-in for Power BI, which you can download here. The add-in includes some key data fields from Project and some visually appealing pre-defined dashboard report templates.

Project Online Add-In for Power BI

So, you are all set to create your custom reports across your portfolio! Well, not exactly…

You will find out pretty quickly that if you want to create a “simple” report like a monthly resource cash flow across all your projects in Power BI, it is much more complicated than you would think. The good news is that Lydon Solutions has built several configurable Power BI solutions that can generate monthly expenditures for any resource or activity across your portfolio. The report can be further customized to your organization’s needs and added to Teams or SharePoint.

Project Online Cash Flow Report for Power BI

Get Help with Microsoft 365, Project Online, and Power BI

As you know, setting up a portfolio cashflow report in Microsoft Project Online is more than just building a report in Power BI. Lydon Solutions can assist you with everything from Microsoft 365 configuration to delivering custom Power BI reports so you can focus on managing your construction projects. You can find out more by requesting a free consultation here.

Use AI to Help Manage Your Construction Projects with Microsoft SharePoint Syntex

Microsoft News | August 24, 2021

Microsoft SharePoint Syntex is an AI tool available as an add-on for Microsoft 365 that construction organizations can use to manage project data more efficiently.

Information management is one of the biggest challenges for any organization. But in construction, it is not just about internal project information management. Compounding the problem's complexity for construction managers and owners is the additional burden of managing the flood of data that their vendors and contractors submit daily (e.g., submittals, RFIs, change orders, and invoices).

Shortcomings of typical project data management methods

Construction organizations have typically processed and managed external project information in one of two ways:

Option 1 – Ask contractors to use the construction manager or owner's project management information system (PMIS)

This approach centralizes data, ensuring that project information resides in a single system of record for processing.

However, using this method adds significant costs and raises the risk of errors. For example, it entails considerable effort in training and hand-holding for every contractor using the PMIS. It also often requires additional document control staff to review and correct technical and data input issues. Finally, contractors typically increase their bids to account for the redundant data entry required to support two systems.

Option 2 – Have contractors email project correspondence (usually as PDFs) to the construction manager or owner for manual entry into their PMIS

This second approach has document control specialists entering data into the system-of-record PMIS, providing a clean and centralized repository for project information.

Unfortunately, this method only shifts the burden of processing project records from the contractors to the owner or construction manager. Thus, while it improves data accuracy, there are still issues of increased cost and significant manual effort.

Using Microsoft SharePoint Syntex to automate project data management

If your organization is on Microsoft 365 and uses SharePoint for construction project management, the good news is that there is a better way to manage your data. Microsoft has recently released SharePoint Syntex, an AI tool for automating content processing.

With SharePoint Syntex, once you train your AI model to classify and extract data from PDFs, the tool will be able to take over and run on a specific document library in SharePoint. The AI model will extract metadata from a PDF document and add it to SharePoint columns once you upload new files.

What does Microsoft SharePoint Syntex mean for construction?

With SharePoint Syntex, there is now a third way to manage and process your construction project information. Using SharePoint Syntex, contractors do not have to learn a new system, nor would the owner or construction managers have to process project correspondence from the contractor manually. Instead, contractors could email project correspondence to the owner or construction manager. A trained Syntex AI model could then review the documents and automatically classify them based on a predefined set of rules. While this may sound like science fiction, it's not, and it's available right now for SharePoint in Microsoft 365.

What does Microsoft SharePoint Syntex cost?

Syntex for SharePoint is available as a cost-per-user add-on in Microsoft 365. The pricing posted on the SharePoint Syntex pricing page at the time of this article is $5/user per month or $60/year.

How to get started using Microsoft SharePoint Syntex?

Once you pay for a SharePoint Syntex user license and create a content center in SharePoint, you can start building AI models.

We'll get into the details in future posts on this subject and possibly some online training sessions.

Get Help Using Microsoft SharePoint Syntex to Manage Your Construction Projects

Lydon Solutions always embraces leading-edge Microsoft technology to improve construction projects' efficiency. We have already built AI models that extract invoice data from PDF invoices emailed into a Microsoft 365 group mailbox. As soon as the file is uploaded, the AI tool automatically extracts data for reporting and analysis. It's exciting stuff!

If you have any questions about setting up SharePoint Syntex for your Microsoft 365 or need a turnkey enterprise PMIS integrated with SharePoint like Construction Viz, don't hesitate to reach out to us for a no-obligation consultation and demo. We're here to help!