Unable to create SharePoint Online site with MobileExcelWebAccess feature error

This week there was an issue with creating SharePoint Online sites in our tenant as reported in Office 365 Tenant Message Centre for also other customers. There is a forum thread on this issue at the new Office 365 Network and thought I quickly blog this for those who are hitting this issue.

The issue was relating to a site template error, specifically in our case, it was when we were trying to create a project and its associated SharePoint site in Project Online. The error was:

image

So I had a look at Site collection features and site features settings and nothing was there. Having logged a support ticket with Microsoft they acknowledged the issue and their response subsequently was that the MobileExcelWebAccess feature is deprecated.

So as a workaround to fix the issue Microsoft provided the following powershell script to run which resolves the issue. The actual script is at the end of this post. You will need to install the following prerequisites before you run the script or ask your SharePoint Administrator.

1) Install SharePoint Online Management Shell from the below download link

https://www.microsoft.com/en-us/download/details.aspx?id=35588

 

2) Install The SharePoint Online Client Components SDK from the below download link

https://www.microsoft.com/en-in/download/details.aspx?id=42038

clip_image002

Hope this helps.

-Chirag

POWERSHELL SCRIPT

$host.Runspace.ThreadOptions = “ReuseThread”

#Definition of the function that allows to enable a SPO Feature
function Enable-SPOFeature
{
param ($sSiteColUrl,$sUserName,$sPassword,$sFeatureGuid)
try
{
#Adding the Client OM Assemblies
Add-Type -Path “C:\Program Files\Common Files\microsoft shared\Web Server Extensions\16\ISAPI\Microsoft.SharePoint.Client.dll”
Add-Type -Path “C:\Program Files\Common Files\microsoft shared\Web Server Extensions\16\ISAPI\Microsoft.SharePoint.Client.Runtime.dll”

#SPO Client Object Model Context
$spoCtx = New-Object Microsoft.SharePoint.Client.ClientContext($sSiteColUrl)
$spoCredentials = New-Object Microsoft.SharePoint.Client.SharePointOnlineCredentials($sUsername, $sPassword)
$spoCtx.Credentials = $spoCredentials

Write-Host “—————————————————————————-”  -foregroundcolor Green
Write-Host “Enabling the Feature with GUID $sFeatureGuid !!” -ForegroundColor Green
Write-Host “—————————————————————————-”  -foregroundcolor Green

$guiFeatureGuid = [System.Guid] $sFeatureGuid
$spoSite=$spoCtx.Site
$spoSite.Features.Add($sFeatureGuid, $true, [Microsoft.SharePoint.Client.FeatureDefinitionScope]::None)
$spoCtx.ExecuteQuery()
$spoCtx.Dispose()
}
catch [System.Exception]
{
write-host -f red $_.Exception.ToString()
}
}

#Required Parameters
$sSiteColUrl = “site collection URL”
$sUserName = “user name”
$sFeatureGuid= “e995e28b-9ba8-4668-9933-cf5c146d7a9f”
$sPassword = Read-Host -Prompt “Password” -AsSecureString
$sPassword=convertto-securestring “Password” -asplaintext -force

Enable-SPOFeature -sSiteColUrl $sSiteColUrl -sUserName $sUserName -sPassword $sPassword -sFeatureGuid $sFeatureGuid

Announcing #Azure #LogicApps general availability

Microsoft have announced Azure Logic Apps general availability.

Azure Logic Apps is the Integration Platform-as-a-service (iPaas) enabling quick hybrid application connectivity to various cloud services and application together with on-premises systems.

You can get started to explore further:
https://azure.microsoft.com/en-us/services/logic-apps/

Some of the out-of-the-box connectors includes Office 365, Salesforce, Dynamics CRM and many more to build rapid applications. With a new visual designer, the focus is more on building workflows and less coding to build process driven applications. Additionally, you can build more intelligent applications supporting business intelligence and many other disciplines. The opportunities are boundless.

Visual designer

Customers have the option to purchase Logic Apps as a standalone service or continue to use current pricing plans such as App Service or IoT Suite. To learn more about purchasing options, check out the Logic Apps pricing page.

You can follow Azure Logic Apps twitter handle for all the latest updates on @logicappsio

-Chirag

Categories: Azure Tags: , ,

Accessing Office 365 Group Hidden SharePoint Site Collection

Recently, one of my happy users of Office 365 Group published Access Web App using Access 2016 to their Office 365 Group. Instead of using SharePoint site link, an office 365 Group link was used and the app was up and running!

So I hear you say…”Sure SharePoint does that and behind the scenes for each and every Office 365 Group there is a SharePoint site collection”.

The issue here was:

  • how do you access this hidden site collection?
  • how do you delete this access web app from the Office 365 Group?

Well here’s how to!

Looking at the Office 365 Group Settings (screenshot below) and aside from Library Settings, all the other menu options listed (Site contents, Site Settings) within SharePoint settings redirect to the files page (i.e. Shared Document Library of this Office 365 Group).

3 menu options

In particular, I was interested to locate the Access Web App in site contents page so it can be deleted as this is not supported by Microsoft. Though the user was able to publish Access Web App in the first place but that’s the issue to resolve for another day!

I fired up the SharePoint Designer to check if Access Web App was present but nothing was there!

8 no access in SP designer

So in order to access the hidden settings you need to get around the redirect, by adding query string parameter for Office 365 Group SharePoint Settings menu options URL with ?noredirect=true

We can now access the Office 365 Group (you need to be an O365 Group Owner) Site Contents page by accessing the URL:
<O365tenant.sharepoint.com/sites/<o365GroupName>/_layouts/15/viewlsts.aspx?noredirect=true

4 site contents

However, it turns out after accessing the site contents page and as a Office 365 Group owner you cannot access its settings nor remove from the group. So for this you need to open a ticket with Microsoft who can delete this from their end.

7 cannotdelete access

Upon exploring further you can access other useful Office 365 Group settings. I’ve made it easy for you to access various settings. I found the storage metric useful to monitor capacity as the only document library exists in Office 365 Group is where all files reside.

CAUTION: I DO NOT RECOMMEND TO CHANGE ANY SETINGS WITHIN THE FOLLOWING SETTINGS.

Office 365 Group SharePoint Settings without redirection
Site Contents – <O365tenant.sharepoint.com/sites/<o365GroupName>/_layouts/15/viewlsts.aspx?noredirect=true
Site Settings – <O365tenant.sharepoint.com/sites/<o365GroupName>/_layouts/15/settings.aspx?noredirect=true
Storage Metrics – <O365tenant.sharepoint.com/sites/<o365GroupName>/_layouts/15/storman.aspx?noredirect=true
Audit Settings – <O365tenant.sharepoint.com/sites/<o365GroupName>/_layouts/15/auditsettings.aspx?noredirect=true
Site Collection Features – <O365tenant.sharepoint.com/sites/<o365GroupName>/_layouts/15/ManageFeatures.aspx?Scope=Site&noredirect=true
Site Features – <O365tenant.sharepoint.com/sites/<o365GroupName>/_layouts/15/ManageFeatures.aspx?noredirect=true

Hope you found this post useful and helps you troubleshoot any issues you may get.

Chirag.

Speaking at SharePoint Saturday Belgium 2016 #spsbe

I am very excited to be speaking for the first time on 15 October 2016 at SharePoint Saturday Belgium 2016 event in Brussels! I am lucky enough to be part of what I believe is a stellar line up of SharePoint and Office 365 speakers with great sessions! My thanks to the organisers BIWUG (Belux Information Worker User Group) and in particular Thomas Vochten and Elio Struyf for bringing this FREE SharePoint Saturday community event for the 6th time. My session is:

spsbe-2016

Session Title
Power Users Guide to Office 365

Session Details
Office 365 is powered by more productive apps than ever before when compared with SharePoint on-premises. In addition to the user interface and evolving collaboration landscape, this full of demos session will cover all the Office 365 collaboration tools and technologies such as Delve, Office 365 Groups, Power BI, Access and SharePoint with no-code and browser based configurations. You will gain invaluable insights and how-to determine what tools to use for what business requirements or scenarios.

To keep up with the latest event updates and developments you can follow on Twitter at#SPSBE and @BIWUG

I hope to see you there! so get registering!

Chirag Patel @techChirag

spsbe-speakers

Speaking at SharePoint Saturday London 2016 #SPSLondon #spsevents #spslondon16

This weekend I will be delivering two sessions (Power BI session & SharePoint Upgrade and Migration session) at the 2nd SharePoint Saturday London event in Imperial College (University of London) on 09 July 2016. Its my pleasure to contribute and catching up with SharePoint enthusiasts and training along the way by attending other sessions! I want to thank the organisers and sponsors for bringing this event and the volunteers – well done folks!

This year there are 4 session tracks (Business, End User, Developer, IT Pro) and some sessions will be delivered by well-known speakers.

My session topics are:

1. Bringing your data to life using Power BI
Power BI has evolved rapidly with cool features enabling business user to visualise data and using self-service business intelligence tools and capabilities through Office and dashboard designer. This demo rich session will focus on building a business focused data visualisation information and reporting.

2. SharePoint Upgrade or Migration, or is it both?
Most organisations use the terms SharePoint upgrade and migration interchangeably, but there are major differences that can have impact on project cost, effort required and skills on the desired outcome. This session aims to solve those hidden costs and differences by discussing the benefits and drawbacks for both upgrade and migration approaches.

For those who have never visited SharePoint Saturday event before, SharePoint Saturday Events (SPSEvents.org) are FREE one-day events held in different cities around the world, featuring sessions from influential and respected SharePoint professionals for End Users, Power Users, Project Managers, Business Analysts and many more. So what are you waiting for? Get registering and hope to see you on 9th July!

To keep up with the latest event updates and developments you can follow on Twitter at#SPSLondon #spslondon16 and @SPS_London
See you there!

Chirag

UPDATE: Slidedecks available below and pictures on Facebook

image

Power Users Guide to #Office365 Session Slides Recording from #Collab365 Summit

This week I had the pleasure of attending Collab365 Summit virtual conference which was held 10-12 May and broadcasted live from Microsoft in Redmond. I presented my session Power Users Guide to Office 365 and want to thank the entire team of Collab365 Summit event organisers, quality speakers and my attendees with great participation and Q+A.

image

You can access my session slides with recording on YouTube and hopefully it will be of benefit and help to you in what Office 365 collaboration tools has on offer.

Enjoy!

Chirag

SharePoint Saturday Madrid 2016 Session Slides

This weekend I had the pleasure of presenting my session “SharePoint Upgrade or Migration, or is it both?” at SharePoint Saturday Madrid in the cool offices of Microsoft. I’d just like to say thanks to all my attendees and can access the slides.

The event was very well organised by Juan Carlos González Martín, Miguel Tabera and Edin Kapić with the rest of the @SPS_Madrid staff. So I thank you for having me and would love to come back again next year!

It was also great to meet the regular speakers and other speakers for first time, and you can access some pictures that hopefully sums up the event!

Below were few twitter interactions from the #SPSMad too!

Thanks
Chirag Patel @techChirag

spsmadrid

Follow

Get every new post delivered to your Inbox.

%d bloggers like this: