My SharePoint Log

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 what I did I cannot get rid of the left NAV bar, even though I’ve got all the new webparts and layouts.

com01

Tried with PowerShell, still no luck..

New-SPOSite -Title “Comsite2PowerShell” -Template SITEPAGEPUBLISHING#0 -Url “https://jimmydev.sharepoint.com/sites/Comsite2PowerShell” -Owner jimmy@hangconsult.com -StorageQuota 1000

com02

Until Microsoft release a means to change this, my work around is as follows, remember that this works best for new customer or customer with an empty root SPO site, existing customer need to plan a migration of content.

First, create a new site using the Communication Template

com03

Navigate to the “Save site as a template” page, this page is hidden from the menu so use the following URL

https://tenant.sharepoint.com/sites/comsite/_layouts/15/savetmpl.aspx

Give the new template a name | click OK

com04

When completed click “Solution gallery”

com05

Click on the name of the template to download it, save it to a location on your computer, you’ll need it later

com06

In SharePoint Admin | delete your root site collection | then create a new one | for template for “Custom | Select template later”

com07

After the site has been created, start a new browser tab and navigate to the new site.
It will now ask you to choose a template | click solution gallery |

com08

 

Now choose to upload your “template.wsp” file you downloaded earlier | then Activate the Solution

com09

Navigate back to the root site | now choose the “Custom” tab | you should see your template | choose the template | then OK

com10

Wait for it

com11

Choose your SharePoint Security Groups | OK

com12

That’s it enjoy your Root site with the brand new communication template, It’s quite beautiful!

com13

 

 

 

 

 

 

Orphaned SharePoint Online Site Collections after an O365 Group

itsbrooken

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, follow the script below:

 

##Connect to SPO

Connect-SPOService -Url https://tenant-admin.sharepoint.com

#Get all SPO Sites | find your orphaned O365 Group Site Collection
Get-SPOSite

#The SPO site Collection is actually locked, unlock it
Set-SPOSite -Identity https://tenant.sharepoint.com/sites/site -LockState Unlock

#If you were not Site Collection Admin before the O365 Group was deleted
Set-SPOSite -Identity https://tenant.sharepoint.com/sites/site -owner tenant-admin@yourdomain.com

#Then remove the orphaned site
Remove-SPOSite -Identity https://tenant.sharepoint.com/sites/sites -NoWait

 

FIX THIS MICROSOFT!!

SharePoint 101 – Image Column in SharePoint list view

SharePoint list is a really powerfull tool, now and then we want it to do even more.

Example:

  • I want the list the have a picture column
  • This column is should contain a link to a picture
  • But I don’t want the picture to be shown in full size as it will “destroys” the list view
  • I don’t want to use code or workflow or css/javascript fix

I want something like this:

imagecolumn001

Step by step:

  1. Create you list, then you will need a column of type “Hyperlink or Picture”| choose format url as “Picture”
  2. Create a standard SharePoint picture library
  3. Go to Site Settings | Image Renditions | If you don’t see it, turn on publishing featureimagecolumn002
  4. Create a rendition of your choiceimagecolumn003
  5. Then navigate to your Picture library and upload your image, when you select the image, in the ribbon you will se Design | Edit Rendition | Click “Edit Renditions”. This will give you the full link of available renditions og the selected image
    imagecolumn004imagecolumn005
  6. Copy the URL and paste it in the Picture Column and you’re doneimagecolumn006