Archive

SharePoint 2019 Solution: “Sorry, apps are turned off. If you know who runs the server, tell them to enable apps.”October 19, 2020
Hide the Browse and Edit buttons and/or the Share, Follow, and Focus/Full-Screen buttons from a SharePoint page’s ribbon menuOctober 19, 2020
Style embedded html iframe and border so it doesn’t look sunk on the pageOctober 19, 2020
Make full-width SharePoint hyperlink column clickable beyond just the link textOctober 19, 2020
Solution: SharePoint Designer email action’s To: line has a valid email address, but is removed and doesn’t send when triggeredOctober 16, 2020
SharePoint conditional column formatting with JSON: Beginner, intermediate, and advanced background colors exampleOctober 16, 2020
Auto-approval of Microsoft Teams Shifts requests using Power AutomateOctober 4, 2020
Delete random blank Excel cells and shift remaining cells left to fill the gapsSeptember 30, 2020
Export a report of all SharePoint lists, libraries, discussion boards, calendars, and more from all site collections with PowerShellSeptember 30, 2020
Free Microsoft 365 training for beginner level SharePoint, Microsoft Teams, Power Apps, Power Automate, OneNote, and Microsoft ProjectSeptember 22, 2020
Get a free e-book copy of my O365 Administration CookbookSeptember 21, 2020
Set default value of multiple lines of text (enhanced rich text type) field in SharePoint new item forms using jQuerySeptember 9, 2020
Create a custom permission level in SharePointSeptember 9, 2020
Change the email address used for Access Requests on all SharePoint sites and subsites in a web app using PowerShellSeptember 9, 2020
Solution: SharePoint site owner with full control unable to approve access requests; site is missing a default members groupSeptember 2, 2020
Disable modern page comments globally for all sites in SharePoint 2019 and SharePoint OnlineSeptember 1, 2020
How to save a SharePoint site as a templateAugust 21, 2020
The “Save site as template” action is not supported on this site solution for SharePoint 2013/2016/2019August 21, 2020
Where to find a SharePoint site’s solution galleryAugust 21, 2020
Read vs Restricted Read vs View Only Permission in SharePointAugust 10, 2020
Solution: “The server was unable to save the form at this time. Please try again.” error for individual SharePoint usersAugust 6, 2020
MS-500 Microsoft 365 Security Administration Exam Study GuideAugust 1, 2020
Image thumbnails not showing in SharePoint Server 2019 modern/new library experienceJuly 28, 2020
Get cooking with Office 365: Two new O365 “cookbooks” from Packt to add to your shelfJuly 25, 2020
How to clear the SharePoint Server configuration cache using PowerShellJuly 25, 2020
Elevate your career by attending the free #GlobalCon3 virtual summit this summerJuly 6, 2020
My imperfect Humans of IT (HoIT) blog postMay 22, 2020
Disable read receipts and typing indicators in LinkedIn messagesMay 20, 2020
How to make your LinkedIn profile private and only accessible to logged in usersMay 20, 2020
Personalize/customize your LinkedIn profile URLMay 20, 2020
Add a thumbnail column for documents and media in a SharePoint Online document libraryMay 14, 2020
How to filter a SharePoint list or library using URL parametersMay 9, 2020
Solution: Searching by ID column in SharePoint list not workingMay 6, 2020
Replace Microsoft Teams’ wiki tab with a OneNote notebook tabApril 24, 2020
Enroll in my FREE OneNote 101 7-day email courseFebruary 17, 2020
Don’t miss #GlobalCon1 Mar 2-6, 2020: A 100% virtual M365 conferenceFebruary 11, 2020
Solution: Survey app missing in SharePointJanuary 15, 2020
Solution: PerformancePoint Dashboard Designer “Cannot download the application…missing required files”January 9, 2020
Nate’s 2019 in ReviewJanuary 1, 2020
Top 10 posts of 2019 on NateChamberlain.comJanuary 1, 2020
Add a shortcut to a SharePoint document stored in a different document library (classic)December 31, 2019
Add a shortcut to a SharePoint document stored in a different document library (modern)December 31, 2019
Solution: SharePoint document library links/shortcuts to other documents go to a blank .aspx pageDecember 31, 2019
Send a weekly email of upcoming events with “Add to calendar” .ics download links using Power Automate (Flow)December 22, 2019
Creating iCal (.ics) calendar item links with a workflow (Power Automate or SharePoint Designer)December 22, 2019
Update a hyperlink or picture column in SharePoint using Microsoft Power Automate (Flow)December 21, 2019
Solution: Column validation error “Sorry, something went wrong. The formula cannot refer to another column.” when referencing today’s dateDecember 20, 2019
SharePoint column validation format difference between classic and modern experiencesDecember 20, 2019
Demystifying Microsoft 365 admin roles in Azure AD and the M365 admin centerDecember 17, 2019
Getting started with Shifts in TeamsDecember 16, 2019
Creating a Team from an existing O365 groupDecember 16, 2019
Reorder and organize SharePoint tasks and timelinesDecember 15, 2019
Remove background from images using Office appsDecember 14, 2019
Workaround: Export to Excel not working in Safari, Chrome, or other non-IE browsers for SharePoint server list exportsDecember 10, 2019
On-premises data gateway for Power BI, Power Automate (Flow), and Power AppsDecember 9, 2019
Restrict who can install on-premises data gateways for the Power PlatformDecember 9, 2019
Introducing the “File Upload” question type for Microsoft FormsDecember 6, 2019
Create a direct link/URL to version history for a SharePoint list item or fileDecember 3, 2019
Pass URL parameter to SharePoint new form (NewForm.aspx) to auto-populate a lookup fieldNovember 22, 2019
Microsoft Delve blogs to be retired; Existing Delve blogs to be deleted in 2020November 22, 2019
MS-101 Exam Study GuideNovember 11, 2019
New book! MS-101 Exam Study Guide AnnouncementOctober 14, 2019
Connect a Google Sheet spreadsheet to Power BI as a data sourceOctober 8, 2019
How to create a PTO/vacation request form and approval process in SharePointSeptember 17, 2019
Possible solution: “Sorry, something went wrong. The file is locked for exclusive use by…”September 17, 2019
GCC solution: “Your org doesn’t allow Microsoft Flow. You’ll need to use your personal email to sign up and get access.”August 8, 2019
Add or subtract hours from date/time values in Power BI using M formula in Power Query EditorAugust 2, 2019
Show/hide fields conditionally in PowerApps forms based on dropdown selectionJuly 18, 2019
Alertus integration in SharePoint via Microsoft FlowJuly 16, 2019
Capitalize whole words or first letters of each word in Excel cellsJune 24, 2019
Filter even or odd rows in ExcelJune 23, 2019
Remove duplicate values from an Excel columnJune 23, 2019
Adjust column widths in classic SharePoint lists using CSS (including “Quick Edit”/datasheet views)June 18, 2019
Join me at SharePoint Fest Seattle Aug 19-23, 2019June 10, 2019
Solution: “The embed code is invalid because the source of the embed content is not allowed” error when embedding Microsoft Stream video in SharePointJune 10, 2019
SharePoint search results showing wrong titleMay 20, 2019
Run Google Chrome as a different user to testMay 17, 2019
Run Internet Explorer (IE) as a different user to testMay 17, 2019
Check permissions for an individual or group in SharePointMay 17, 2019
Have you been pwned? Here’s how to update your Microsoft password(s) and upgrade your securityMay 7, 2019
Add a “project health” stoplight status indicator to your classic sitesMay 7, 2019
Use Microsoft Flow to automatically convert RTF files to DOCMay 6, 2019
“The selected file doesn’t contain template elements” error in Microsoft FlowMay 6, 2019
Remove specific people from people search results in SharePointMay 1, 2019
Manually start a full or incremental crawl of an on-prem content source in SharePointMay 1, 2019
Spam on the rise! GIFs to help you tell the cautionary taleApril 25, 2019
Set and manage notification alerts on SharePoint discussion boards, lists, & librariesApril 24, 2019
Clean up your Outlook! Quick tips to refresh your spaceApril 23, 2019
5 ways to improve your efficiency using OneNote & OutlookApril 19, 2019
Failing forward: Analyzing the aftermathApril 15, 2019
Create an external content type in SharePoint to connect to SQL dataApril 2, 2019
Solution: “Database Connector has throttled the response” error on external list in SharePointApril 1, 2019
Solution: “Feature requires a browser that supports ActiveX controls” when importing spreadsheet to SharePointMarch 26, 2019
The “new Outlook” in Outlook O365 looks a lot like personal Outlook online nowMarch 20, 2019
Updated share link options for SharePoint filesMarch 20, 2019
“Notify your team” option when you upload files to SharePointMarch 20, 2019
Preserve Excel hyperlinks when saving as PDFMarch 18, 2019
Improve the look of the likert rating question type in SharePoint surveysFebruary 27, 2019
Export SharePoint group membership names and email addresses to ExcelFebruary 26, 2019
Limited edition “SharePoint Champion” vinyl stickersFebruary 25, 2019

Spread the word:

Like this: