In this session we will demonstrate how we can use the Power Platform (Power BI, Flow, PowerApps) to build a complete business solution with data store on SharePoint lists.
We will use as example a projects lifecylce site. It's a SharePoint Online site where we can 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.