February 17, 2020

What’s in that patch? February 2020

NOTE – PDF format updated to include both SharePoint 2013, 2016, and 2019 notes.

Ever wondered what fixes are inside of a given CU? Please see attached PDF with full detail. I wanted a new format for easy reading. Show management and make the business case for why downtime should be taken to apply CUs. Also posted at https://sharepointupdates.com/

If you found this helpful, please leave a comment.

Download

What’s in that patch – Feb 2020.PDF

February 12, 2020

VIDEO – Load PNP the Right Way

Quick blog post about detecting if PowerShell PNP is available on the local PC and installing is missing (for new systems) to make PS1 script more portable across servers. (1) Detect command (2) Install module if missing (3) Import module. Cheers.

Video

Code

# Load PNP module, the right way
Add-Type -Assembly "System.IO.Compression.FileSystem" -ErrorAction SilentlyContinue | Out-Null
$pnp = Get-Command Connect-PnPOnline -ErrorAction SilentlyContinue
if (!$pnp) {
    Install-Module "SharePointPnPPowerShellOnline" -Force
}
Import-Module "SharePointPnPPowerShellOnline" -ErrorAction SilentlyContinue | Out-Null

1

2

3

4

5

6

7

# Load PNP module, the right way

Add-Type -Assembly "System.IO.Compression.FileSystem" -ErrorAction SilentlyContinue | Out-Null

$pnp = Get-Command Connect-PnPOnline -ErrorAction SilentlyContinue

if (!$pnp) {

Install-Module "SharePointPnPPowerShellOnline" -Force

}

Import-Module "SharePointPnPPowerShellOnline" -ErrorAction SilentlyContinue | Out-Null

References

February 9, 2020

VIDEO DEMO – PowerApps Expense Report Demo

Wanted to share demo for the install and configuration of Expense Report sample application. PowerApps and MS Flow leveraged to create validated input, mobile ready, rich forms input experience. MS Flow applied for approval routing and audit trail. Easily submit new request, automate approval, and enable full tracking with PowerApps and MS Flow working together. Cheers.