SharePoint Online Site Collection owner Report

We have a requirement to extract sharepoint online owner report but it should exclude office 365 group sites and include only the sites that we are creating thru Sharepoint online administration control panel. We can achieve this by excluding the site collections that are using the Template¬†“Group#0”. Download and extract the script zip file from…

SharePoint Online Communication Site

Some of the users contacted us that they want to create a communication Site on SharePoint online. In one of the office 365 environment we have blocked the self-service site creation for the time being. What I thought that If We know the template of the Communication site, We will be able to create it…

SharePoint Online Common Shell Commands

Sharing a few SharePoint online common shell commands that can be used by SharePoint administrators for day to day operations. First Download the Sharepoint Online Management Shell from below link https://www.microsoft.com/en-us/download/details.aspx?id=35588 ones above is done connect to the online Shell –>Connect-SPOService -Url https://orgName-admin.sharepoint.com To get ALL Sharepoint Online sites use below: Get-SPOSite -Limit ALL To…

Microsoft flow and SharePoint lists

Last week I was working on automation that include SharePoint online list, workflow using SharePoint designer and PowerShell back-end to finish the automation flow. Fortunately my Sharepoint designer was broken so I was not able to create a workflow. I started reconsidering my options without the designer and thought to try Microsoft flow as an…

Performance Point Error – Code Blocks are not allowed in this file

We have ¬†implemented Performance point for our Sharepoint farm as requested by one of our departments. They want to use it as a Business Intelligence tool, therefore¬†wanted to explore its capabilities. We have configured it as documented by Microsoft by creating Secure Store Service Starting Performance point services Configuring Performance point service application After that…

Export Sharepoint List to CSV

This script will assist in exporting the Sharepoint List contents in csv format. It would be useful in scenarios where you want to export list & further feed some other system to complete further processing. Example which is being shared was used in one of the automation where IT people can fill the form for…