June 13, 2021

What’s in that patch? May 2021

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 – May 2021.PDF

June 6, 2021

Modern SPList JSON column format to VIEW FORM / ATTACH buttons

Video demo for how to apply Modern SPList JSON column formatting. Show the creation of “VIEW FORM” and “VIEW ATTACH” buttons for creating a great user experience. Each button provide high contrast custom HTML/CSS look and feel with drill down to gain more detail. Cheers.

Video

Source Code

https://github.com/spjeff/office365/tree/master/office365-spo-modern-column-JSON

Screenshots

May 8, 2021

VIDEO – MS Graph (Sites.Selected) demo AngularJS create SharePoint List Item

Tour of the process to invoke MS Graph API with Sites.Selected including Azure App Registration, SharePoint Online, MS Graph Explorer, VS Code, and AngularJS web application to create SharePoint List Item.

Goal is to demonstrate coding example:

How to create Azure App Registration with GUI
How to grant “Sites.Selected” for given SharePoint Online URL with PNP PowerShell
HTTP POST for Azure logic to get Access Token
HTTP POST for MS Graph “Sites.Selected” granular API to create SharePoint list item
Tools needed to develop and debug all of the above.

With Microsoft’s release of “Sites.Selected” for MS Graph we have more granular permission options beyond classic “Sites.ReadWrite.All” and “Sites.FullControl.All” which could enable an application to read every document in the SharePoint Online tenant. Least privilege security practices would encourage us to only grant what is actively needed, nothing more.

Testing the full process end-to-end requires a sample application sending HTTP to read/write SharePoint data. For that, we are employing a simple AngularJS 1X web Single Page Application (SPA) with only 1 HTML and 1 JS file. Enables us to view JS values, click button to send, and trace network traffic with F12 Chrome tools. NPM and LITE-SERVER are leveraged for http://localhost:3000/ website hosting to provide front end interface and local debug. Also, Chrome is launched with CMD parameters to disable CORS providing unrestricted network traffic and for simpler debug experience.

Cheers.