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