Author: Jimmy Hang

SharePoint 101 – Confusions about SharePoint Online Site Group and Site Members Permissions

Lately I've got a lot of request regarding the confusions of SharePoint Site Group and Site Members. Basically when you create a modern Team Site via the GUI, what you are creating is also an “Office 365 Group” in the nature of this action your user account is automatically added to the SharePoint Site Collection(SC) … Continue reading SharePoint 101 – Confusions about SharePoint Online Site Group and Site Members Permissions

Fix Bluetooth on Windows 10 Fall Creators Update – Mac BootCamp

Just updated my Windows 10 BootCamp partition to Windows 10 Fall creators update, system running version 1709, build 16299.192. After the update my Bluetooth devices can't be used anymore, everything is connected drivers are up to date, bootcamp assistant up to date, but my Bluetooth mouse can only be use a couple of minutes, if … Continue reading Fix Bluetooth on Windows 10 Fall Creators Update – Mac BootCamp

Get client side Hero webpart PropertiesJson

First create a new page and configure your Hero webpart content as needed. Using PnP PowerShell connect to the site and get the page: Connect-PnPOnline -Url https://$tenant.sharepoint.com/sites/$siteUrl $homePage = Get-PnPClientSidePage -Identity $pagename $heroWebPart = $homePage.Controls | ? {$_.Title -eq "Hero"} $heroWebPart.PropertiesJson   Copy this Json content and add it to the following code to update … Continue reading Get client side Hero webpart PropertiesJson

SharePoint 101 – Importing Excel data to SharePoint Online List – CSOM

Business case: We have a lot of data in Excel files today, and we want to convert this to use SharePoint Online List, for obvious reasons like integration with @Flow and @PowerApps. With the right steps, the script below using SCOM will help you achieve this. Steps: In SharePoint Online Create a new List with … Continue reading SharePoint 101 – Importing Excel data to SharePoint Online List – CSOM

CSOM error Exception calling “ExecuteQuery”

If you are trying to run CSOM against SharePoint Online and gets the error below Exception calling "ExecuteQuery" with "0" argument(s): "Cannot contact web site 'https://tenant.sharepoint.com/' or the web site does not support SharePoint Online credentials. The response status code is 'Unauthorized'. The cause of this issue:  LegacyAuthProtocolsEnabled By default this property should be set … Continue reading CSOM error Exception calling “ExecuteQuery”

Creating a new Client side Page with PnP-PowerShell

Very often I came across business requirements to automation the creation of sites and pages in SharePoint, this process is not easy in Office 365 SharePoint Online. In this post I'm sharing my experiences with client side page creation with PnP-PowerShell. Many thanks to the #amazing #PnP team on providing us with this #great tool. … Continue reading Creating a new Client side Page with PnP-PowerShell