Free SharePoint Tips and Tricks

Free SharePoint Tips and Tricks

Posted by ESW Team | May 31, 2018 | SharePoint
SharePoint Tips and Tricks

SharePoint Tips and Tricks

It seems like every day at eSoftware we are learning or explaining an endless list of SharePoint Tips and Tricks to our clients. We’ve decided to start this article and continue to add and organize it over time. Check back often to see what the latest tips and tricks are that we discover.

Can’t Delete a SharePoint Site

Applies To: SharePoint 2010, SharePoint 2013, SharePoint 2016, SharePoint Online

If you are trying to delete a SharePoint site, you may get a message saying “There was a problem deleting web site ‘your site’. Sites that have subsites or certain apps can’t be deleted. Please try again after deleting all subsites and removing the apps.” What if there are no subsites and really doesn’t appear to be any apps? If you have a drop off library, which was created using the Content Orgnanizer feature, this is your reason. You cannot delete a drop off library using conventional methods. The option doesn’t even exist. You must first run a PowerShell script to enable the feature to delete the drop-off library and then delete the library. After this, you can then delete the website.

Link to PowerShell to delete a Drop-Off Library



Setting a SharePoint Date to Empty or Null

Applies To: SharePoint 2010, SharePoint 2013, SharePoint 2016, SharePoint Online

Lots and lots of failed attempts out on the internet for this one. To set a SharePoint Date to Empty or Null:

  1. Create a SharePoint 2010 workflow. You cannot do this with a SharePoint 2013 workflow! If you must use a SharePoint 2013 workflow, you will need to use the “Start a SharePoint Workflow” action and call the SharePoint 2010 workflow.
  2. Add a String workflow variable and name it ‘BlankDate’
  3. Add an action to Set a Workflow Variable, choose ‘BlankDate’ and set its value to 1/1/0001 00:00:00 – note that the 00:00:00 is only needed if you are clearing a date and time field. If you are only clearing a date field, set BlankDate to 1/1/0001.
  4. Set the current item date field or fields to the workflow variable ‘BlankDate’.

It’s amazing how many failed attempts this took. Things we tried and know that do not work from various internet articles:

  • Trying the above trick with a SharePoint 2013 workflow
  • Using a blank date variable in a workflow
  • Adding a dummy date field to your list or library and attempting to set your field to that blank date field


Want more insights like this?

Get notifications of our Office 365 & SharePoint updates!

Another interesting power admin trick for Office 365:
Using Repeating Tables in PowerApps

Related Blogs

Posted by russell | May 7, 2018
Use Today in Calculated Columns in SharePoint Today we are putting to rest the question, and myth, of if you can use today in calculated columns in SharePoint.  This question...
Posted by russell | April 4, 2018
March 2018 Office 365 Updates We’re Excited About March was a busy month for Office 365. There were 33 new additions to the Office 365 roadmap with a heavy focus on...
Posted by markertingadmin | March 30, 2018
After all, Microsoft SharePoint consulting services help companies implement SharePoint migrations, SharePoint design services and SharePoint workflows. Most companies don’t have the time or money to create these platforms on...