Microsoft cloud engineer - SharePoint, Office 365, Azure, DotNet, Angular, JavaScript.
Microsoft cloud engineer - SharePoint, Office 365, Azure, DotNet, Angular, JavaScript.

Uncategorized

What’s in that patch? Dec 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.   

shades_smile_thumb_thumb_thumb_thumb[2]

Download

What’s in that patch – Dev 2020.PDF

VIDEO – Azure Automation Runbook to manage SharePoint Online SPO

Wanted to demo Azure Runbook with daily PowerShell PS1 that send SharePoint storage report email with HTML table and CSV attachment.   Features include:

  • Hosted on Azure Platform-As-A-Service (PAAS)
  • Read source data SharePoint Online (SAAS)
  • SMTP for routing email with Exchange online
  • Credential storage in Azure Automation secure string
  • Logging with full debug
  • Local execution with Visual Studio code to debug

Demo covers the creation of local PowerShell PS1 and execute to confirm functionality.  Script reads Tenant Site Collection from SharePoint Online leveraging Client App ID and App Secret.   Table of collected data is formatted with HTML and CSS then routed out with SMTP. 

Cheers. 

shades_smile

Source Code

Video

Screenshots

image
image
image
image
image
image
image
image
image

References

M365 Ultimate PowerShell

Loads all Microsoft 365 cloud PowerShell modules in a single window.  No more wasted time jumping between download pages and locating various Import-Module from each product team.  Collected all here centrally to provide M365 admins with a single PowerShell PS1 to install and import every command they might need.  Enables cloud admin productivity to quickly access every command. 

Cheers! 

shades_smile

Video

Screenshot

image

GitHub Repo

References

VIDEO – PowerApps Grouped Toggle (select only one)

Brief demo video to show how “OnCheck()” formula can be used to group Toggle controls.   Business goal is to check only one at a time.  When clicking to Check Toggle ON all others controls need to set OFF.    We can accomplish this with “OnCheck()” formula to disable all peers.   Video demo shows the construction of parameters for Patch() function with JSON values to toggle controls OFF and “Refresh()” formula to update display.  Cheers. 

shades_smile

Code

Toggle1 / OnCheck = Patch(Test,ThisItem,{Toggle2:false,Toggle3:false});Reset(DataCardValue15);Reset(DataCardValue16);

Toggle2 / OnCheck = Patch(Test,ThisItem,{Toggle1:false,Toggle3:false});Reset(DataCardValue14);Reset(DataCardValue16);

Toggle3 / OnCheck = Patch(Test,ThisItem,{Toggle1:false,Toggle2:false});Reset(DataCardValue14);Reset(DataCardValue15);

Screenshots

image
image

Video

© Copyright 2016
@ SPJeff

Return to Top ▲Return to Top ▲