Archive for SharePoint Online

Microsoft Ignite 2017 – SharePoint

Quite excited. Below are some of announcements that were made at Microsoft Ignite 2017

SharePoint 2019: Yes. Yes and Yes. Preview version will be available by mid of 2018.

Hub site: Group together related sites to share navigation and look and feel. Bring together announcements, news and activities. Making search easy and can associate team sites / communication sites.

DIP: Document Information Panel is back for Word 2016.

Threshold Limit: Predicative indexing will automatically index columns once increased 5000 items. Yes, we are getting rid of paging and contents will load as scroll.

Columns Formatters: Script to format columns.

Custom Forms with Power Apps: Not sure how much powerful but we can built custom forms using power apps as previously accomplished by InfoPath or code.

Flow Launch Panel: This is existing. A form to get input when starting workflow using Flow.

Attention View: View that list items with missing required columns.

New Admin Center: As usual, a new admin center to learn and find desired info.

Migration Tool: This is unexpected. Free of cost migration tool to migrate data from File Server, SharePoint On-Premises and CSV file to SharePoint Online. Migration tool can be downloaded from @

Session Timeout Policies: Enables to set up policies to sign out a session after a certain time of inactivity.

Device Access Policies: Enables to set up policies on site collection level to limit access of devices.

Geo-Capabilities: Good news for government sector to meet data residency requirements. A single O365 tenant can span to multiple regions based upon user or site.

Shorter Url: Shorter Url for file sharing.

Sharing Files: Share file with people outside organizations using simple email based verification.

O365 Groups and Existing sites: Existing sites can be connected with O365 groups.

MS Teams: Can open pages of SharePoint sites in MS Teams.

New Web Part: Yammer web parts, file viewer web parts, Planner and connector web part.




Leave a Comment

SharePoint Online – List of Sites & Webs


Need to create a PowerShell script that iterates through all SharePoint Online site collections and webs and generate info. regarding site collection size, last time site/web update and other.


Tweaked script by Jose Quinto @

Output is two CSV files in temp folder on C drive root. One with the details and other with site collection on which account gets 401 error.

$Global:webinfo = @()

function AuthenticateUserProfile($siteUrl, $tenantAdmin, $secureAdminPassword)
$ctx = New-Object Microsoft.SharePoint.Client.ClientContext($siteUrl)
$credentials = New-Object Microsoft.SharePoint.Client.SharePointOnlineCredentials($tenantAdmin, $secureAdminPassword)
$ctx.Credentials = $credentials
return $ctx

function RecursiveWebs($ctx, $web){

foreach($w in $web.Webs)

$Properties = @{
Title = $w.Title
URL = $w.Url
NoOfSubsites = $w.Webs.Count
LastUserModifiedDate = $w.LastItemUserModifiedDate
LastItemModifiedDate = $w.LastItemModifiedDate
SiteCollection = ‘No’
SiteOwner = $w.Author.Title

$Global:webinfo += New-Object psobject -Property $properties

if ($w.Webs.Count -gt 0)
RecursiveWebs $ctx $w

$username = “”
$password = ConvertTo-SecureString “PASSWORD” -AsPlainText -Force
$O365Credential = New-Object System.Management.Automation.PsCredential($username, $password)

#SharePoint Online Admin site URL
Connect-SPOService -Url -Credential $O365Credential
$sites = Get-SPOSite -Limit All -Detailed

foreach ($site in $sites)
$site.Url.Equals(“”) -or

Write-Host $site.Url
$ctx = AuthenticateUserProfile $site.Url $username $password;
$web = $ctx.Web

$Properties = @{

Title = $site.Title
URL = $site.Url
SiteSizeLimitInMB = $site.StorageQuota
SiteUsageInMB = $site.StorageUsageCurrent
NoOfSubsites = $web.Webs.Count
SiteOwner = $site.Owner
LastContentModifiedDate = $site.LastContentModifiedDate
LastUserModifiedDate = $web.LastItemUserModifiedDate
SiteCollection = ‘Yes’
LastItemModifiedDate = $web.LastItemModifiedDate

$Global:webinfo += New-Object psobject -Property $properties

if ($web.Webs.Count -gt 0)
RecursiveWebs $ctx $web
Write-Host $_ -ForegroundColor Red
$Properties1 = @{

Title = $site.Title
URL = $site.Url


$site401 += New-Object psobject -Property $properties1



$webinfo | Select-Object Title, URL, SiteSizeLimitInMB, SiteUsageInMB, LastItemModifiedDate,
LastUserModifiedDate, LastContentModifiedDate, NoOfSubsites,
SiteOwner, SiteCollection | Export-Csv -notypeinformation -Path ‘C:\temp\SPOinfo.csv’

$site401 | Select-Object Title, URL | Export-Csv -notypeinformation -Path ‘C:\temp\SPOinfo401.csv’


Comments (1)

SharePoint Online – Synch is not working


Installed Office 2016 on computers and unable to Synch document libraries


First check the version of OneDrive. Please make sure when press synch, exe should be running OneDrive.exe not groove.exe. If OneDrive.exe is running, please make sure OneDrive sync client must be version 17.3.6674.1021 or higher. If not, please follow steps:

  1. Download and install the preview build of the new OneDrive sync client.
  2. Download and open TeamSiteSyncPreview.reg to enable SharePoint document library sync.
  3. Restart computer
  4. Use Chrome to Synch document library.


Comments (1)