SharePoint Online Site Owner with Power Platform

Course Length: 2 Days

Course Format: Instructor–Led and In-Person

Course Hours: 9:00 a.m. – 5:00 p.m.

Back to class dates and registration.
Download a PDF of this course outline.

Course Description

Course Overview: Microsoft® SharePoint®, in conjunction with the Microsoft 365 suite of productivity and office automation tools, provides tools to create and manage a corporate intranet, facilitate content sharing and collaboration, and enable users to create, access, store, and track documents and data in a central location. By default, SharePoint provides end users with a generous set of permissions, enabling users to create and customize their own sites as site owners, and create and collaborate on team site content. Users who have grown comfortable with these fundamental content-authoring capabilities may want to move on to more advanced features, such as connecting multiple SharePoint sites through a hub, importing list data from external sources, implementing user input validation features, applying conditional formatting, and using Power Apps® to provide custom user interfaces for data collected in SharePoint. This course focuses on issues related to planning and implementing an intranet with multiple communication sites and team sites interconnected through a hub site to provide unified navigation search, and formatting.

Target Student: This course is designed for Microsoft SharePoint site users who are already comfortable using SharePoint as a site user (site visitor or site member), but who want to advance to creating new sites and integrating them with features like Power Apps.

Prerequisites: To ensure your success in this course, you should have basic end-user skills with a current version of Microsoft Windows. You should also have basic SharePoint site user skills such as the ability to view and enter data in SharePoint lists and libraries, and to navigate a typical SharePoint site. You can obtain these skills by taking the following CompuTrain courses:

Using Microsoft® Windows® 10
Microsoft® 365 Office for the Web (with Teams®)
Microsoft® SharePoint® Online: Site Basics

Course Objectives

In this course, you will create a SharePoint team site and a communication site, connect them with a hub site, create custom page layouts, perform advanced tasks in libraries and lists, and integrate a Power Apps custom application with SharePoint. You will:

Plan and create a SharePoint-based multi-site intranet, including team and communication sites.
Associate multiple sites with a hub site to provide unified navigation, search, and theme.
Use advanced SharePoint features to manage content creation in lists and libraries, including custom page templates and various methods to import data.
Configure lists with various input validation features to improve the quality of data entry and presentation.
Use Power Apps Studio to create a custom user interface for entering data in a SharePoint list.

Course Content

Lesson 1: Setting Up a Multi-Site Intranet

Plan Your Organization’s Intranet
Create and Configure SharePoint Sites

Lesson 2: Connecting Sites to a Hub

Create a Hub to Connect Multiple Sites
Apply a Site Template
Change Site Themes and Navigation

Lesson 3: Populating a Site with Content

Create Custom Page Layouts
Manage Library Files
Manage List Data

Lesson 4: Assigning Permissions and Access Rights

Secure Sites with Permissions
Secure Apps, Documents, and Files

Lesson 5: Improving List Data Entry and Presentation

Limit What Users Can Enter
Create Calculated Columns
Use Formulas to Validate Entered Data