SharePoint – Quick Edit – Missing Required Columns

Leave a comment

Have you ever tried to perform a quick edit on a SharePoint list and get the “Sorry, you can’t create a new item with Quick Edit because this view is missing one or more required columns. To create a new item, please click “New Item” or add required columns to this view.”?


You checked and indeed, your list contains a required column.

One of the main offenders is the missing “Name” field in the view. I found a method to get rid of this error without needing to add the “Name” field to your view via PowerShell.


#Get the site

$Web = Get-SPWeb -Identity “http://<Your Portal>/<Your Site>”

#Get the list that you need to work with – In my example below my list is called “Assets”

$List = $Web.Lists[“My Custom List”]

#To see the “Name” field

$List.Fields | Select Title, InternalName, Required | Sort Title

#It should look similar to this


#Change the field to not required and update

$Field = $List.Fields[“Name”]

$Field.Required = $False


Here’s a screenshot of what worked for me.SetNameField

That’s it!

Thanks for reading!


Retention and AIP Protected Documents

Leave a comment

This is a follow up to my previous post (Which Office 365 Retention Policy Should You Use?).

Before I jump in, I want to provide additional information on documents stored in my SharePoint site.

I configured Azure Information Protection labels and published them. Note that All Employees sub-label of Restricted label is configured with protection. I created several documents, applied these labels manually and automatically, and uploaded them to SharePoint.

AIP Labels2

After applying retention policies to these documents (my previous post), one thing I noticed after the retention policies automatically applied to these documents, two of my documents classified as ‘Restricted All Employees‘ have no policies applied to them.  I waited additional days thinking that I was just too impatient.  After several days, still nothing.

AIP RMS Enabled

I have always known that AIP protected documents are not viewable in Office Web Apps, but I couldn’t understand why retention policies were not able to apply to these documents.

After researching more on this behavior, I’ve learned that SharePoint is not able to index AIP protected documents.  Because of this there are no metadata available for the retention policies to query on these documents.

I hope this helps explaining why O365 retention and SharePoint don’t always give you the expected results.

Summary Links Web Part Malfunction

Leave a comment

Have you ever tried to add new columns to a Summary Links Web part and got an unexpected result?  Well, this happened to one of the clients I was working with.

It’s a simple task. Right?

When the user changed the layout of the Summary Links Web part to five columns per group, instead of getting five columns across the Web part, the columns were stacked on top of each other.


It made no difference when it was changed to any value greater than one, the columns continued to stack on top of each other.


After some research, it turned out that it was related to the theme applied to the site.  In my opinion, this is very strange.  The site’s theme was changed back to an OOTB theme, and the columns behaved the way they are expected.


Happy SharePoint-ing!

Office 365 – Sharing with External Users

Leave a comment

When it comes to collaborating, Office 365 allows colleagues to check availability in Outlook, schedule a Skype for Business meeting, and share files in SharePoint, OneDrive for Business, or Office 365 Groups.  While sharing within your own organization is fairly simple, sharing with external users requires some planning.  External users can be anyone outside your organization; this can include partners and customers.  A technical description of an external user, is a user who does not have an account registered or licensed in your Office 365 tenant.

There are two types of external users – authenticated and anonymous.

Authenticated users are users with a Microsoft account from another Office 365 subscription.  Authenticated users can have the same permissions as any of the internal users within your organization.  You can assign a license to them.

Anonymous users are users who can access a folder or document via a shareable link.  Anonymous users can view, edit, or upload to the folder without having to log in with a username or password.  Anonymous users cannot access sites, and you cannot assign licenses to them.

Where do you start?

Before you can start allowing external users to access your data, you should consider the existing policies set by your organization.  Some of these policies may include:

  • Is external sharing allowed for anyone (anonymous) or just authenticated users?
  • Which domains should be allowed or blocked in Skype for Business?
  • What types of content that cannot or should not be stored in O365?
  • Who can (and should) extend an invitation to an external user?

You may also find that your organization does not have policies in place that address the sharing of content with external users except through e-mail.  If this applies to your organization, it’s important that your Office 365 tenant is configured to limit external sharing until the proper policies and controls can be put into place, thus limiting the risk to the organization.

What are some of the security risks?

While external sharing is a great way to extend your organization to your partners, suppliers, and perhaps even your customers, there are risks that must accounted for.  Some of those risks include

  • Accidental sharing of sensitive content
  • External users with full control might be able to share content with other unintended external users
  • Changes made by anonymous users cannot be tracked

While these risks, and potentially others, apply to your organization, there are processes, settings, and tools within Office 365 that can mitigate the risks and protect your corporate assets and intellectual property.

  • Implement and enforce governance for external sharing
  • Consider using Azure Rights Management (RMS) to encrypt and restrict sharing of the data
  • Implement Data Loss Prevention (DLP) policies to automatically detect sensitive data
  • Send links, not attachments
  • Grant minimum level of permissions to external users
  • Disable external sharing on site collections with sensitive data
  • Disable anonymous sharing

What can you share?

External sharing can be configured separately for the different capabilities in Office 365, but primarily for SharePoint Online, OneDrive for Business, Outlook, Skype for Business, and Office 365 Groups.

SharePoint Online and OneDrive for Business: you can share an entire site, lists and libraries, and documents.  Keep in mind that the external users will need to authenticate to see all of these items while anonymous users can only see documents.  Additionally, SharePoint gives you the ability to limit users who can share with external users.


Office 365 Groups:

  • Conversations – no access to conversation history, but may participate by receiving an e-mail sent to the distribution list
  • Files, Notebook, and Site – you can share an entire site, lists and libraries, and documents
  • Calendar – no access


Exchange (Calendar): you can share free/busy information with time only, with subject and location, or full details


Skype for Business: you can schedule meetings or chat


When it comes to sharing, or collaborating with partners and customers, it is critical to include external sharing as part of your Office 365 governance and security planning.  Remember that a governance plan is not a guarantee for security compliance, users and administrators must observe and follow good practices and policies to minimize the risks.

SharePoint ReferenceError: ‘Strings’ is Undefined

Leave a comment

Earlier this week I ran across the most unusual error in SharePoint.  The strangest thing was that it impacted IE only while Chrome continued to work.

Here’s the site in IE:


And the same site in Chrome:


In the midst of troubleshooting, I did not get a chance to capture many screenshots. But the one thing I captured was the virus scan window; it popped up every time I refreshed IE browser window.


It was pretty obvious to me that it was not SharePoint as I was able to work in Chrome.  But I continued to comb through logs just to be sure.

After a couple of hours, the security team reported that they rolled back the Trend Micro pattern file due to the widespread errors reported globally.  SharePoint in IE was working once again.

Trend Micro released a new pattern to correct this issue.  It can be downloaded here.


SharePoint List Cell Borders

Leave a comment

I received a request from one of my clients to put borders around each cell in a SharePoint list.  There were no out-of-box styles that I could use to fulfill this request.  I ended up using a simple script for it.

The standard list with some content without any styling:


I added a Script Editor Web Part the page with the following code:

<style type="text/css"> {
border-right-width: 1px;
} > tbody > tr > td {
border: 1px solid black;
.ms-viewheadertr th {
border: 1px solid black;

The same list with borders:



Migrating SharePoint to Office 365 – Best (Recommended) Practices

Leave a comment

Microsoft Office 365 user population has recently hit 85 million commercial users ( As the user base continues to grow, we’ve seen a growing interest amongst our clients in moving their on-premises SharePoint farms to Office 365. The most critical part of a SharePoint migration project involves planning for the migration itself. With the different number of factors involved including the limitations of out-of-the-box migration options, this can complicate the project and introduce undesirable risk. It is critical to plan a SharePoint migration carefully and fully take into account all variables involved in the migration process.

Once a decision is made to move your SharePoint sites to the Office 365, you will need to consider – what does success look like to you? Whether the new platform is SharePoint Online or Hybrid, the following recommendations could be used as starting points for your migration.


  • If you have SharePoint On-premises, run the OnRamp for Office 365 Tool to assist you with discovery activities related to Office 365 deployment (screenshot below)


  • Custom domain – if you plan on using your own domain (ex:, make sure this domain has been verified
  • Make sure Office 365 tenant is ready – licenses, connectivity (network/firewall), and security must be in place
  • On-premises AD schema and forest functional level – MUST be at Windows Server 2003 or later if you plan on using Azure AD Connect
  • Prepare Active Directory before synchronize – run IdFix on your on-prem Active Directory and fix errors on accounts targeted to be synchronized
  • ADFS – if you consider deploying ADFS, you’ll need to use SSL Certificates
  • Take an inventory – this includes content, information architecture, design, and custom solutions
  • Decide what to move – take only what you will need – archive and delete redundant and/or legacy data
  • Prioritize and classify all content – tag content with metadata including Business Unit, and any other relevant data. Prioritize content with criteria such as business critical, important, nice to have, etc.
  • Select the right migration tool – Many commercial tools are available to assist with migrating to Office 365
  • Communication – some people tend to forget – make sure to communicate, communicate, and communicate


  • Start with a pilot migration – use a representative sample of data to confirm technical feasibility of the migration, and identifies gaps
  • Migrate in batches – for larger organizations, divide content in batches to migrate


  • Testing and validation – validates the success of the migration from the perspective of whether or not the infrastructure of the target environment meets the requirements of the business; this includes network latency, permission, custom solutions, etc. Repeat this process for each batch of the migration.
  • Transition of users – this includes ‘freezing’ the source environment, and perform one final synchronization of changes, and transitioning users to the target environment. Again, repeat this process for each batch of the migration.

In conclusion, migration of existing business content to SharePoint Online is not trivial. Ideally, organizations should spend time planning, discovering, and auditing the content, starting with the pre-migration checklist above. Lastly, whenever possible, comprehensive testing after each migration batch should be performed to minimize risk.

Centric has assisted many organizations with SharePoint and Office 365 upgrades and migrations. To learn more about how Centric Consulting can help with your upgrade or migration, visit us at

Older Entries