Do you have SharePoint Online and want to better automate and streamline your business processes? Have you worked with PowerApps, Microsoft Flow, or Power BI, but you're not sure how to use them with SharePoint Online? You've come to the right place! This series of tutorials explores how to build out a basic project-management app based on SharePoint lists and three key technologies that integrate with SharePoint Online: PowerApps, Microsoft Flow, and Power BI. These technologies work together, making it easy to measure your business, act on the results, and automate your workflows. When you're done with this series, you will have a cool scenario like the following:

Diagram of completed scenario

Business scenario

In this series of tutorials, the company Contoso has a SharePoint Online site where they manage the lifecycle of projects, from request, to approval, to development, to final review. A project requestor, such as a department head, requests an IT project by adding an item to a SharePoint list. A project approver, such as an IT manager, reviews the project, and then approves it or rejects it. If approved, the project is assigned to a project manager, and additional detail is added to a second list through the same app. A business analyst reviews current and completed projects using a Power BI report embedded in SharePoint.  Microsoft Flow is used to send approval email and respond to Power BI alerts.

Getting started quickly

The scenario we present in this series of tutorials is simple compared to a full-blown project management and analysis app, but it still takes some time to complete all the tasks. If you just want a quick introduction to using PowerApps, Microsoft Flow, and Power BI with SharePoint, check out the following articles:

When you're done, we hope you'll be back to check out this full scenario.

Even within the scenario, you can focus on the tasks that interest you, and complete the tasks as you have time. After you set up SharePoint lists in task 1, you can work through tasks 2-5 in any order; then tasks 6-8 are sequential. Lastly, we have included two finished apps and a Power BI Desktop report as part of the download package for this scenario. You can look at these and learn by example even if you don't go through all the steps in each task.

Prerequisites

To complete the scenario, you need the following subscriptions and desktop tools. The Office 365 Business Premium subscription includes PowerApps and Microsoft Flow.

Subscription or tool Link
Office 365 Business Premium subscription Trial subscription
PowerApps Studio Use PowerApps Studio for web (no download required) or PowerApps Studio for Windows
Power BI Pro subscription Trial subscription (click TRY FREE)
Power BI Desktop Free download (click DOWNLOAD FREE)

Ideally, you have basic familiarity with each technology, but you can still complete the scenario if you're new to some of these technologies. Use the following content to get up to speed:

Next steps

The next step in this tutorial series is to set up the SharePoint Online lists that we use throughout the series.