Author: Jimmy Hang

Connect-PnPOnline : For security reasons DTD is prohibited in this XML document

Just changed my internet provider, and got this error again. Connect-PnPOnline : For security reasons DTD is prohibited in this XML document. To enable DTD processing set the DtdProcessing property on XmlReaderSettings to Parse and pass the settings into XmlReader.Create method. Just want to document the solution: 127.0.0.1 msoid.tenantdomain.onmicrosoft.com 127.0.0.1 msoid.onmicrosoft.com   Cheers

SharePoint Online Hub Site

SharePoint Online Hub site is almost GA, 😉 This is the stuff that the Hub site brings to the table for the Modern Intranet. Using SharePoint Online PowerShell run the following command Connect-SPOService -Url https://tenant-admin.sharepoint.com Register-SPOHubSite "siteURL" After this magic happens, we get a new top Navigation for the Hub site Site setting now have … Continue reading SharePoint Online Hub Site →

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 →