#MinuteMonday – Create Network Location-Based Conditional Access Policies in SharePoint Online

The days of the corporate boundary beginning at the firewall are over, today’s corporate boundary is the end user.  Connectivity is ubiquitous and with an endless number of devices available, people have an increasing number of options for staying connected at anytime, anywhere.

As a first step to providing administrators security and control in a mobile and connected world are conditional access policies.  Conditional access provides the control and protection businesses need to keep their corporate data secure, while giving their people an experience that allows them to do their best work from any device.

FileChecker Migration Assessment Sample Available for SharePoint Online and OneDrive for Business

Know before you go…

If you’re considering migrating file shares or other file-centric containers to OneDrive for Business or SharePoint Online it’s useful to understand if the source files are supported for storage or synchronization.  This code sample at https://github.com/wbaer/FileChecker helps to identify illegal characters, length restrictions, and more in one or more file names that can potentially prevent proper synchronization with Microsoft SharePoint and OneDrive for Business or fail to render through the Microsoft SharePoint or OneDrive for Business Web UX.

Extend FileChecker.exe at https://github.com/wbaer/FileChecker or download a working sample and read the documentation at http://wbaer.io/2oaQ9HP.



Command Line




jQueryUI Accordion Widget SharePoint Framework Client-Side Web Part Sample Available

The published sample at https://github.com/wbaer/jQueryUI-Webpart  combines the tutorials available at https://dev.office.com/sharepoint/docs/spfx/web-parts/get-started/build-a-hello-world-web-part and demonstrates how you can use the jQuery UI Accordion widget to render SharePoint list data using content panels for presenting information in a limited amount of space and supports the configuration of effects and interactions through the Property Pane.


jQuery UI is a set of user interface interactions, effects, widgets, and themes built on top of the jQuery JavaScript Library you can use to build highly interactive web applications.  To learn more about jQueryUI visit http://jqueryui.com.

New support for # and % in SharePoint Online and OneDrive for Business

As William Shakespeare wrote in Romeo and Juliet “What’s in a name? That which we call a rose by any other name would smell as sweet.”

Files are as unique as the people who create them and we’re constantly working in SharePoint Online and OneDrive for Business to support a broad array of types and naming conventions.

In the upcoming weeks, we’ll be shipping support for # and % as supported characters in file and folder names across document libraries in SharePoint Online and OneDrive for Business.  This will allow people to create, store, and sync files containing # and % characters whether those characters are used as a prefix or suffix to the file or folder name.  # and % will be limited to use in file names in addition to SharePoint Online and OneDrive for Business document libraries and related folders.  The use of # and % outside of document libraries is not supported at this time.


Getting Started with # and %

# and % support is not enabled by default in your Office 365 Tenant and will be gradually introduced over the next several weeks.  You can immediately opt in to this release starting today using the Windows PowerShell cmdlet provided later in this post.

For new Office 365 Tenants, in June 2017, support for # and % will enabled by default when the Tenant is provisioned.  If you would like to opt out of # and % support for your Office 365 Tenant using the Windows PowerShell cmdlet provided later in this post you must do so by September 2017.

All existing Office 365 Tenants that have not opted into # and % support by H2 2017 will have # and % support enabled by default.

Enabling # and % Support (Tenant Administrators)

To enable # and % support using SharePoint Online PowerShell commands, you must be a SharePoint Online global administrator.  There will be no initial administrator web-based user experience (e.g. SharePoint Online and/or OneDrive for Business admin centers).

Before you can run SharePoint Online commands, you must install the SharePoint Online Management Shell module and connect to the SharePoint Online service. For more information, see Connect to SharePoint Online PowerShell.


Prior to enabling support for # and % in your Office 365 Tenant, ensure any 3rd party solutions you are using have been updated to supported the new APIs necessary to support this change.  For information on updated APIs for # and % support see also https://dev.office.com/blogs/upcoming-changes-to-sharepoint-and-onedrive-for-business-apis-to-support-and-in-file-names.







Allows # and % characters in file and folder names in SharePoint Online and OneDrive for Business document libraries.


Disallows the # and % characters in file and folder names in SharePoint Online and OneDrive for Business document libraries.


# and % support will be enabled by Microsoft on your Office 365 Tenant when available.
NoPreference state is the default state before we enable # and % on behalf of Office 365 Tenants following the schedule mentioned previously. In this state, # and % are turned off and tenant admins can run Set command to switch it to either Allowed or Disallowed. Once it is set by tenant admins, we will not change the setting when we enable on # and % on behalf of Office 365 Tenants. In addition, this is a read-only state, so it can not be set by running the Set command.

Frequently Asked Questions

Q:  Is support for # % enabled by default in my Office 365 Tenant?

A:  No.  Support for # % must be enabled by the Tenant Administrator, unless your tenant is created after the June timeframe, as noted above.

Q:  As a developer are there any API changes I need to be aware of?

A:  Yes.  For developer documentation and updates refer to https://dev.office.com/blogs/upcoming-changes-to-sharepoint-and-onedrive-for-business-apis-to-support-and-in-file-names.

Q:  At what levels of the system is this support being added?

A:  Files and folders with SharePoint Online and OneDrive for Business document libraries will now be able to support # and % in their file name.  While SharePoint lists and libraries can have # and % in their URLs, there are no plans to enable their use through the SharePoint user interface at this time.  In addition SharePoint sites (Web objects) and site collections (Site objects) can not have # and ; in their URL.

Q:  Can I search for files containing # and % in the name(s)?

A:  Yes; however, # and % are escaped characters therefore cannot be used independently in the composition of a query.  I.e.  “where contains ‘#’”.

Q:  When will the rollout of # and % support be completed?

A:  Rollout will commence in June 2017 for new Office 365 Tenants and H2 CY2017 for existing Office 365 Tenants.  Scheduled completing depends on a number of factors and will be updated throughout the rollout.

Q:  Does the Groove sync client support # and %.

A:  No.  Support is limited to the new OneDrive for Business sync client.  To determine which sync client is best for your scenario or which sync client you are using see also https://blogs.technet.microsoft.com/wbaer/2017/03/23/which-onedrive-for-business-sync-client-is-right-for-me/.