Excel Surveys for "Office 365 Groups"


I came across an interesting issue when trying to use an Excel Survey from an Office 365 Group.  Details below.

If you create an Office 365 Group

1

...and build a Document Library (https://tschauer.sharepoint.com/sites/tomtest/TomTest_Doc_Library), you will NOT see Excel Survey under +New.

2

For Excel Surveys to be present certain permissions need to exist in SPO, see KB2890031.  The cause of this issue was due to the default Sharing Capability of Office 365 Groups.

Manage external sharing for Office 365 Group site collections

https://support.office.com/en-us/article/Manage-external-sharing-for-your-SharePoint-Online-environment-C8A462EB-0723-4B0B-8D0A-70FEAFE4BE85/#bkmk_groupsitecollections  

By default, all SharePoint site collections that are part of an Office 365 Group have the sharing setting set to Allow sharing only with the external users that already exist in your organization’s directory.

To change this setting, you can use the Set-SPOSite Windows PowerShell cmdlet.

Example: Set-SPOSite -Identity https://contoso.sharepoint.com/sites/site1 -SharingCapability ExternalUserAndGuestSharing

This example updates the external sharing capability of the site collection "https://contoso.sharepoint.com/sites/site1" to allow sharing with all external users, and by using anonymous access links. This cmdlet is executed immediately.

To view the existing sharing setting, use the Get-SPOSite Windows PowerShell cmdlet.

Example: (Get-SPOSite -Identity https://contoso.sharepoint.com/sites/site1).SharingCapability

For detailed information about these cmdlets and their parameters in Windows PowerShell, see Set-SPOSite and Get-SPOSite.

After using the above cmd in the SPO PowerShell Module to change my Office 365 Group Sharing Capability.  The Excel Survey is now present.

3

Comments (0)

Skip to main content