Like Us
Plus One
Follow Us
Search
 Name Mike Smith  Blog Tech Training Notes
 Location United States  Category SharePoint
 Articles 129  Views 86797

Articles from Tech Training Notes

s
  A JavaScript project to use with a Content Editor Web Part to test SharePoint REST API calls, and create AJAX sample code and SharePoint Designer 2013 Workflow steps. It includes over 40 ready t...
SharePoint Date Search Tips #sharepoint #office365      31-Mar-2017     189  
  Applies to SharePoint 2013 and later.   A few SharePoint Search Tips!   Time Zone Search internally stores dates in Universal Time. Because of this, a file uploaded at “2/7/2017 10:50 PM EST” w...
  One of my examples for tonight’s Cincinnati SharePoint User Group meeting! See you there!   I wanted to add a "motivational" message to a list of new sales. To be "fair" (i.e. I did not want to t...
  A story about a bug, an inconsistency and a solution…   I recently did a demo of using PowerShell's Invoke-RestMethod to create, read, update and delete (CRUD) data to a REST service written usi...
  A "Can't see the tree for the forest" problem. There's an old phrase, "Can't see the forest for the trees", that in reverse, "Can't see the tree for the forest", applies to a recent "demo fail" o...
  It looks like "modern pages" are now rolling out to the tenants with the preview options on. You can still create Wiki Pages and Web Part Pages in addition to the new "Site Page" type. Here's bot...
  Tested in SharePoint 2013, 2016 and SharePoint Online.   The Windows Explorer view of a SharePoint library has so many issues that I'm often asked to hide it. Turns out that this is pretty easy t...
  This was tested in SharePoint 2013 and 2016. Had a list with 100,000 items with a State column. I found that some of my users did not know their state abbreviations. (KE is Kentucky?) After clean...
  SharePoint 2013 had a default List View Threshold that used the number 5,000 for a lot of limits. SharePoint 2016 has made a few changes to the List View Threshold to give us a little more flexi...
Get the Version Number of a PowerShell Module      15-Aug-2016     401  
  When a PowerShell script works for one person, but not for another, sometimes it's because the PowerShell module is a different version. To find the version number:Get-Module -ListAvailable "Micr...
  (For SharePoint 2013, 2016 and SharePoint Online.) It's generally a good idea to use relative URLs when creating something that you will want to use in more than one place. While not real obvious...
  Have any of your site owners been trying to create views with more than 5000 items? Have you changed the row limit to more than 5000 and have decided to set it back? Here’s some PowerShell to fin...
  One of my PCs cannot display any of the new “Modern Lists / Library Experience” pages, including the OneDrive for Business pages. The pages are just blank. The issue turned out to be a URL that w...
  You may already know that you can access the core .NET libraries like System.Math from PowerShell:   As “System” is the default namespace, you could just type [Math]::Sqrt(2). But what if you wa...
  SharePoint Online Latest Change of the Week / Day / Hour / Minute… If you use Office 365 / SharePoint Online then you should now be used to the constant tinkering with the user interface. I’m sta...
SharePoint Column Validation Examples      12-Jun-2016     525  
Update 11/2/2015… added "Date must be the first day of the month" and "Date must be the last day of the month". The following applies to SharePoint 2007, 2010 and 2013. Column Validation SharePoint...
  The typical SharePoint end user knows less than 1% of the SharePoint Search feature set. In other words, they know how to do a Google search. They just type a word or two, press Enter and hope fo...
SharePoint Folders Are Not EVIL!      17-May-2016     303  
  It seems that everyday I run across another blog article, forum post or social media that says “Never Use Folders!” While one of the common analogies for SharePoint is the Swiss Army Knife, a bet...
  Ed Wilson, the Microsoft Scripting Guy, will be presenting at the Cincinnati PowerShell User Group meeting on June 15th at MAX Technical Training. Topic: Configuration Management with Azure Autom...
  I’m often chasing one SharePoint rabbit or another down a rabbit hole and spending hours there when I only wanted to ask the rabbit one simple question. In this case the question was who is “Eve...
New SharePoint 2016 Courses Coming from Microsoft      11-Mar-2016     524  
  Microsoft is releasing two new SharePoint 2016 administrator courses in July. The courses have a new numbering scheme to better reflect the “Part 1” and “Part 2” nature of the pair. 20339-1 and 2...
  SharePoint 2016 is so similar to SharePoint Online / Office 365 that it’s sometimes hard to tell which version you are in. I just ran across an odd change from the past versions. How do you share...
SharePoint: Undocumented Pending Shares Page      10-Mar-2016     440  
  Article applies to SharePoint 2013, SharePoint Online and SharePoint 2016.   Did you ever wonder after using the Share buttons in SharePoint if the Site Owner ever responded to your request, res...
  If you have followed this blog, you know that I’m kind of a SharePoint nut who’s also a PowerShell nut. Over the years I have created a lot of PowerShell scripts while working with SharePoint an...
  Something for the SharePoint trivia department… What do you call this: I had always thought that calling the App Launcher button in Office 365 and SharePoint 2016 the “waffle button” was a bit o...
  The problem… While we do want site visitors to see the list items, we don’t want them to see or click the list’s attachments. More SharePoint Customization tricks!More Site Owner articles.More ar...
  Microsoft is “expiring” a long list of exams in September. This means that: Anyone working on the related certifications has six months to complete these exams, or never be able to finish cert...
  Working on your Azure certifications? Take a break and go look at the list of announced updates. While they are listed as being updated as of March 16th, 2016, at least some the listed changes ha...
Azure Cloud – 5TB free space      17-Feb-2016     485  
  You have to think a little differently when working in the cloud… (and sometimes I’m easily impressed with big numbers…) Created an Azure Storage File Share. Went to a VM running in Azure and co...
All About Office 365 Groups      14-Feb-2016     674  
  I’ve been collecting some notes on Office 365 Groups for my classes for a while. Here’s what I’ve got so far. Keep in mind that this feature is still evolving. Please post any corrections or upda...
  Not an obvious error message: New-AzurermAutomationCredential -AutomationAccountName "PStest" -Name "myPsredential" New-AzurermAutomationCredential : Input string was not in a correct format. Tu...
Azure: PowerShell to List All Blobs in Storage      15-Jan-2016     623  
  I have an Azure account for development and testing purposes that I want to keep as clean as possible. Part of my routine is clearing out unneeded blobs in the Storage Accounts. To do this using ...
The following applies to SharePoint 2013, 2016 and SharePoint Online.   The Error “Unable to display this Web Part. To troubleshoot the problem, open this Web page in a Microsoft SharePoint Foundat...
  I wrote a PowerShell script to create views. It worked in PowerShell 3 on SharePoint 2013. It failed in PowerShell 2 on SharePoint 2010. To play it safe, I copied values from an existing view to ...
  The following works in SharePoint 2013, 2016 (beta 2) and SharePoint Online.   One of the common reasons to enable the Publishing Feature was to get the Navigation page so you could have dropdown...
This article applies to SharePoint 2013, 2016 and SharePoint Online. This article is a work in progress!   It seems I’ve been writing a lot of JS Link lately and I’m always playing a guessing game...
Test Post for the New Office Live Writer!      18-Dec-2015     468  
  Google Blogger.com broke Microsoft Live Writer earlier in the year with an update to their login security. They then reversed the change and Live Writer users were back in business. Yea! Then las...
Some error messages are no help at all! While working on a Visual Studio 2013 MVC project I got this error: When running in Debug mode Visual Studio reports: An exception of type...
Get short lists of PowerShell cmdlets      07-Dec-2015     475  
  I write a lot of documentation and I’m always looking for ways to make lists of things easier to read. Long lists of PowerShell commands have always been a problem as they usually should be sorte...
This article is for SharePoint 2007, 2010, 2013, 2016 and SharePoint Online/Office 365. (2007 users see the note at the end of the article.) Cleaning up inactive sites is a common best practice adm...
SharePoint Content Type Inheritance      28-Nov-2015     552  
This article applies to SharePoint 2010, 2013 and 2016. If you have worked around SharePoint for a while then you have heard the phrase "Everything is a list…". If everything is a list then everyt...
  Updated the following article to include SharePoint, 2007, 2010, 2013, 2016 and SharePoint Online. http://techtrainingnotes.blogspot.com/2011/06/sharepoint-how-to-change-default-home.html ...
This article applies to SharePoint Online, SharePoint 2013 and 2016.   Let's start with a couple "did you knows"… Did you know: All users with Edit and Contribute permission levels can edit the ho...
PowerShell Get-Date vs. [DateTime]      18-Nov-2015     744  
  The Cincinnati PowerShell User Group (@CincyPowershell) opens each meeting with a review of a cmdlet. Tonight is was Get-Date's turn. Many of the examples were done with both Get-Date and [dateti...
Add a Crumb Trail to SharePoint 2013      17-Nov-2015     503  
  Solution #1: Restore the SharePoint 2010 Navigate Up button See here: http://techtrainingnotes.blogspot.com/2014/06/sharepoint-2013-restoring-2010-navigate.html   Solution 2: Add an always displ...
  Sometimes the obvious just does not work… I was doing some work with SharePoint publishing sites, trying to find some of the data in the SPWeb AllProperties property. AllProperties looks like a c...
Weird SharePoint Icons = Timeout!      14-Nov-2015     610  
Have you ever had a SharePoint page "explode"? Odds are something from the server timed out. In the example below the CSS files never got loaded. The links timed out. A simple refresh should fix it...
Fifty+ SharePoint 2013 Sample Background Images      09-Nov-2015     595  
The following applies to SharePoint 2013 and SharePoint Online / Office 365. Theme Background Images When designing a theme for your site you can use a background image for the page. Did you know t...
  I was searching through around 400 folders with thousands of files for all of the files that contained "_files" in their names. Should be easy… open Windows Explorer and type in the search box *_...
  When trying to load the SharePoint Online PowerShell module into the ISE or an existing shell you may get the error below. Simple problem with a non-obvious error message… The fix is easy… after ...
  Every once and a while I work a little on my next book, SharePoint 2103 Security. At the pace I'm going it may never get done. As I'm always a bit surprised at the response and disbelief I get wh...
This article includes both 2010 and 2013 examples. Let's say you wanted to display a Date/Time down to the minute or second, but you wanted the column heading to filter by days or months. By defaul...
The following has been tested with SharePoint 2010 and 2013… There are a lot of questions in the various forums on how to start a Site Workflow, mostly because it is a bit hard to find in SharePoin...
The following applies to SP 2010 and SP 2013 and should work in SP 2007. You want a calculated column for a hyperlink, but can't create one. (you can't embed working HTML into the calculation.) So…...
  The following screen captures are from SP 2013. SP 2010 behaves in the same way except for the error message.   Scenario: You grant Contribute or Edit permissions to a user to a list or library,...
SharePoint / PowerShell List Item Update Note      16-Oct-2015     491  
  Sometimes it's the forests and sometimes it's the trees…   I have gotten so used to using shortcuts like chaining of properties in PowerShell that I forget some of my .Net fundamentals. The Titl...
  SharePoint 2013 took away the people picker search tool and replaced it with an autocomplete feature. Type a few letters and matching names appear. The problem is that this only works when you ...
SharePoint PreCancelAction      15-Oct-2015     1101  
  SharePoint does not have a PreCancelAction. I created what I needed for one project, and present it here for your creative uses and enhancements. No warranties and no support… but the price is ri...
SharePoint Online… Where's My Tree View?      14-Oct-2015     1282  
  As you are probably aware by now… SharePoint Online is a member of the "change of the day" club. My Tree View is missing in my online sites! In my on-premises SharePoint 2013 I can go to Settings...
  64 bit programs have to be better than 32 bit programs, right? This is a question that keeps popping up in my classes and the various support forums, usually in the form of "xxxxx does not work i...
  SharePoint Saturday Cincinnati is almost here! In fact… it's tomorrow. I thought I'd do something a little different this time and put out a little teaser on my topic. To be fair though… there's ...
SharePoint Column Validation Examples      08-Oct-2015     561  
The following applies to SharePoint 2007, 2010 and 2013. SharePoint does not include column types for phone numbers or part numbers, nor does it include support for Regular Expressions to test for ...
SharePoint: Who can't you hide things from?      28-Sep-2015     660  
  You just created a new subsite. You broke inheritance. You removed all of the inherited permissions. You gave only three people access. Can anyone else see this site? Yup… Your Site Collection ...
SharePoint Saturday Cincinnati… Boo!      20-Sep-2015     1043  
If you don't put this in your calendar right now… ScarePoint Saturday is going to sneak right past you! SharePoint Saturday Cincinnati is a FREE one day conference. The event is open to the public...
  A while back I posted an article on downloading files from SharePoint using PowerShell (see here) that generated a few questions about uploading files. So… here's a few uploading scripts. Don't s...
  Got to love error messages… especially when one occurs while processing another.   . ...
New SharePoint 2013 Search for Power Users Class      08-Sep-2015     516  
  I'm very pleased to announce my latest Courseware Marketplace course! 55141AC SharePoint 2013 Search for Power Users. While the class has not shown up yet on the Microsoft Learning site, it shoul...
Cincinnati PowerShell User Group Meeting      19-Aug-2015     514  
  Register here: (free!) http://www.meetup.com/TechLife-Cincinnati/events/224705451/ Cincinnati PowerShell Users group – August Meeting When: August 27thWhere: Max Technical Training Mason, OH PS C...
  Just as they have gotten everyone to call everything an "app", they have to change it again. Lists = apps, libraries = apps, web parts = app parts… everything was to be an app. Now everything is ...
Hiding the Evil SharePoint 2013 Share Buttons!      08-Aug-2015     1103  
  SharePoint introduced Share buttons to make it easy for users to quickly share a site, folder or document. This introduced several administration, security and governance problems for administrat...
  Weird what you stumble across in SharePoint! There is no end to finding things! Center or Centre? Organization or Organisation? Harbor or Harbour? SharePoint 2013 search, both On Prem and Office ...
  This is an update to an older article to include support for SharePoint 2013. Hiding Column Headings I had a request to hide the column headings of a list displayed in a web part. First though...
  Did you ever wonder if there's more to SharePoint? Sites you may have permissions to, but no one ever told you about? Sites like the rumored jokes site and the "free stuff" site? You can use sear...
  A continuation of the "Search Weirdness" series! How many Announcement Lists do I have? In the first article of this series I showed how something like a series of Purchase Orders that differ in ...
  A continuation of the "Search Weirdness" series!   Search Alerts are Different! Unlike list and library alerts: You cannot create them for other people. There's no place to type an email add...
  A continuation of the "Search Weirdness" series!   Can't Find My Videos! I have a bunch of videos in my site. They could be anywhere: A document library An Assets library An Office 365 Vide...
  This is a 2013 version of the 2007 and 2010 article found here: http://techtrainingnotes.blogspot.com/2010/10/sharepoint-create-quote-of-day-web-part.html   Quote of the Day / Tip of the Day Want...
Windows 10      15-Jun-2015     543  
  I've had Windows 10 on my laptop for the last few weeks and thought I'd give a little report.   Hardware used for testing Most Windows 10 testers seem to be installing it in a virtual machine. I ...
Info. and RSVP here: http://meetu.ps/2JkRsx The PowerShell User Group is back! (But the future is up to you!)      PS C:\> Get-Speaker | Plan-Meeting | ShowUp-AndLearn! Sponsor:  SAPIEN ...
  Asset Libraries are… weird. When you just upload videos using only the Upload button, and just view the videos, then all is good. But if you want the link to the video file, or you u...
  This is part of the "Search Weirdness" series… Can't find my purchase order! I created several purchase orders and uploaded them to a library. I can see them in the library, and when I use the li...
SharePoint 2013 Search Weirdness      26-Apr-2015     733  
  In my presentation at last week's SharePoint Cincy 2015 I had a slide titled "Search Weirdness" that raised a few eyebrows. It had a list of things that are, well, unexpected at the least. As I ...
  My public Office 365 subscription shares resources with many other subscriptions. Somebody must be uploading a lot of stuff today! And I was not even uploading anything! Just navigating around t...
  Search Genie? OK, that's a bit of a corny title, and a bit of a deception. My SharePoint Cincy presentation is really about the powerful things you can do with SharePoint 2013's search feature se...
  In my Search Administration class I stress that admins should dump the search reports on a regular basis as the data is only kept in detail for 14 days and in summary form for 35 months. But who ...
  While the following example is for PowerShell, the same applies to C# code. Collections that are being modified do not like to be processed with FOR EACH."Collection was modified; enumeration ope...
  The SharePoint Group object has a property named "Description", but it appears to be ignored. When you edit a group in the browser there is no "Description" field, but there is one named "About M...
 Did you ever want to find all of the columns of a certain type? All Lookups, all Calculated or all Managed Metadata columns? All you have to do is look at the Fields object "TypeDisplayName" prope...
Word Stemming in SharePoint 2013 Search      15-Mar-2015     1879  
  Word Stemming Word stemming is when a search engine resolves a word to its root form and then returns variations of the word. For example, search for one of these and return the rest: run, ran ...
  In SharePoint 2010, Removed was Removed! In SharePoint 2010 there's a search feature called "Search Result Removal" that made an item immediately disappear from user's search results. All you had...
SharePoint 2013: Missing Search Box      06-Mar-2015     887  
  You have a search box over your list or library and I don't! Why? SharePoint 2013 has added a search box to most lists and libraries that is scoped to the current list. When the user performs the...
SharePoint 2013 Search File Extensions      05-Mar-2015     878  
  Just a simple list of file extensions that have some kind of default support in the SharePoint 2013 Search Service. FH = SharePoint 2013 has a File Handler and can index the content of this file...
  Over the last three months I have been working on a Search Administration class that has a focus on improving the end user search experience. If you have attended one of my governance classes or...
SharePoint: Create a View for Only Last Month      03-Mar-2015     580  
  You have to learn some real tricks to get views filtered just the way you want, especially with dates. Dates are fun in that the filter can only compare a date column to an exact date or [Today]....
SharePoint 2013 Query Suggestion Files      02-Mar-2015     619  
  Over the last three months I have been working on a Search Administration class that has a focus on improving the end user search experience. If you have attended one of my governance classes or...
Working with Quick Launch from PowerShell      22-Feb-2015     663  
  The following will work with both SharePoint 2010 and 2013. It will also work with SharePoint 2007 if you "manually" create the SPWeb object. The basic steps to add a new link to Quick Launch: G...
  Note: The following will work in SharePoint 2010. For SharePoint 2013 you will need to use PowerShell. See here: http://techtrainingnotes.blogspot.com/2015/02/working-with-quick-launch-from.html ...
Looking for __REQUESTDIGEST?      20-Feb-2015     816  
  When the minimal Download feature is enabled, you cannot find the __REQUESTDIGEST by using Internet Explorer's View Source feature. But there are two quick options: You can find it using this J...
  Title:somekeywords You find the strangest things in SharePoint when you are looking for something else! I'm writing the labs for a new SharePoint 2013 Search Administration class and was looking...
  Back in 2008 I created a list of SharePoint list and library registration IDs here. I updated it again in 2009, 2010 and 2014, and every time finding more list types to document. Well, I'm back a...