Author: Jimmy Hang

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

Change SharePoint Online root site collection to use the new “Communication Site Template”

My tenant just got the new Communication site template. Thank you @SharePoint As I've built numerous Intranet sites both with SharePoint On-premises and SharePoint Online, I want to see if I can use the new template on the root team site. Because the root SPO site is a team site, it turn out no matter … Continue reading Change SharePoint Online root site collection to use the new “Communication Site Template”

Orphaned SharePoint Online Site Collections after an O365 Group

O365 Groups or Unified Groups is a cool O365 feature, except when it don't work as expected. You just deleted the Group, but the hidden SharePoint Online Site Collection connected to the group didn't got deleted automatically with the group. Guess what it's now an orphaned site collection in locked state. To Remove these sites, … Continue reading Orphaned SharePoint Online Site Collections after an O365 Group