Microsoft SharePoint 365 Advanced

Name: Microsoft SharePoint 365 Advanced
Author: Eddie Wantland

Learn the Advanced Skills of SharePoint 365

Preview the first lesson free — get full access to all 36 lessons.

Course: On-Demand

Hello, and welcome to SharePoint Online Advanced Course. My name's Eddie Wantland. I have been a SharePoint developer and consultant for 14 years, and it certainly is a pleasure to welcome you to the advanced course. Who is this course for? Well, it's for students who have completed the SharePoint Online Intermediate Course, or have a moderate understanding of on-prem versions of SharePoint, including PowerShell. Plus, it wouldn't hurt to understand some basic concepts behind web development, such as HTML, CSS, and JavaScript. The core structure, well, we started in the beginning by learning rudimentary end user tasks. Next, we engaged in hub and site development, as well as site design. And for this course, we are going to be looking at some SharePoint Online customization. Let's go ahead and get started by learning the difference between SharePoint Online versus PnP. Now, SharePoint Online is kinda steeped in 2013. It's the basic premise of SharePoint Online when you just use SPO commands. However, PnP, patterns and practices, is an initiative which includes samples and guidance as to how to transform your full trust code solutions to the added model. PnP is a community-driven open source project where Microsoft and external community members are sharing their learnings around implementation practices for Office 365, SharePoint, and Office. And if I could be visual for a moment, as wonderful as SharePoint Online is, it's out of the box. It's a cheese pizza. You add the PnP library to it, and you have so many more options. So what is PowerShell scripting? Well, PowerShell scripting is focused on leveraging an object-oriented automation engine and scripting language with an interactive command line shell designed to help IT professionals configure systems and automate administrative tasks. In order to reach this, we need to get past this right here. This is here to help you. I mean, let's face it, but when you're developing and you're working in the background, you need to go ahead and make sure that the computer knows you're one of the good guys. The way we do that is we find what our execution policy is. We get it, and then we set it to what we need it to be. Now, your execution policies are going to be one of these. It can be AllSigned, RemoteSigned, or Unrestricted. It can't be restricted for obvious reasons because you won't be able to run the scripts that are needed to engage in administrative development of SharePoint Online and the PnP library. So just remember that a commandlet always consists of a verb or a word that functions as a verb and a noun separated with a hyphen, the verb-noun rule. For example, some of the verbs include, these are the ones we're gonna be using, get, to get something, set, to define something, add, to add something, new, to create something. New is not a verb, of course, but it functions as one. Now, also keep in mind, we learned from last tutorial, last course in the moderate, that module's in there. So yeah, we'll have SPO, but then we're gonna have PnP inserted in there. You'll see what I'm saying. Finally, we're gonna be making use of for loops within our scripting example. And for loops are typically used to iterate through a set of commands a specified number of times, either to step through an array or object, or just repeat the same block of code as needed. It is extremely handy to have when you're looking to automate a business process. I don't know about you folks, but I'm ready for the demo.

Advanced Provider : Eddie Wantland 8 chapters · 36 Lessons · 2h 30m in Arabic, German, English, Spanish, French, Portuguese, Chinese

Course Description

This advanced course will focus on SharePoint Online customization. This course is designed for those with a moderate understanding of On-Prem versions of SharePoint, including PowerShell. Users will need to understand the basic concepts of web development, such as HTML, CSS, and Javascript. This course will cover the various aspects of SharePoint PnP (Patterns and Practices), PowerApp, metadata, Keyword Query Language, and other high-level functions of SharePoint.

Learning Objectives

What You'll Learn

Build and automate SharePoint sites using PowerShell, including setting execution policy, logging in, and creating sites with parameters
Create PowerApps connected to a document library, with camera, image, and metadata functionality
Add metadata fields, lists, and columns to SharePoint
Build automated flows that update file properties and respond to a PowerApp
Configure and add PnP Modern Search web parts in SharePoint
Write Keyword Query Language (KQL) queries using property restrictions and character/time-specific syntax

Key Takeaways

This advanced course focuses on SharePoint Online customization and high-level functions including SharePoint PnP (Patterns and Practices), PowerApps, metadata, and Keyword Query Language.
PowerShell is used to automate tasks such as setting execution policy, logging in, and building sites with parameters.
A PowerApp project connects an app to a document library and includes camera, image, and metadata field functionality, along with flows that update file properties.
The course covers Microsoft Search, the legacy search experience, and adding and configuring PnP Modern Search web parts.
Keyword Query Language (KQL) is taught for specifying property restrictions and writing character and time-specific queries.

Frequently Asked Questions

Who is this course designed for?

It is designed for those with a moderate understanding of On-Prem versions of SharePoint, including PowerShell.

What prerequisites do I need?

Users need to understand basic web development concepts such as HTML, CSS, and JavaScript, along with a moderate understanding of On-Prem SharePoint and PowerShell.

What topics does this course cover?

It covers SharePoint Online customization, including SharePoint PnP (Patterns and Practices), PowerApps, metadata, Keyword Query Language, and other high-level functions of SharePoint.

What will I be able to do with PowerApps after this course?

You will be able to build a PowerApp project connected to a document library, including camera and image functionality, metadata fields, and flows that update file properties and respond to the app.

Does this course teach search functionality?

Yes, it covers Microsoft Search, the legacy search experience, adding and configuring PnP Modern Search web parts, and writing Keyword Query Language (KQL) queries.