Content and script editor web parts missing in SharePoint

Missing two of your favorite web parts? Don’t fret.

Make sure the site collection feature “SharePoint Server Publishing Infrastructure” is activated

Make sure the site feature “SharePoint Server Publishing” is activated

Still not there? Check “Settings” in the admin center to see if custom scripts are allowed on personal and self-service created sites (allow both). This can take up to 24 hours to take effect.

If you can’t wait (and you’re using SharePoint Online), use PowerShell to make the change immediately, changing my site details to your own

$adminUPN="nate@sharepointlibrarian.com"
$orgName="sharepointlibrarian"
$UserCredential = Get-Credential -UserName $adminUPN -Message "Enter password"
Connect-SPOService -URL https://sharepointlibrarian-admin.sharepoint.com -Credential $userCredential
Set-SPOsite https://sharepointlibrarian.sharepoint.com -DenyAddAndCustomizePages 0

Repeat the last line for each site on which you need to quickly activate this setting. For example, I would run it again on https://sharepointlibrarian1.sharepoint.com/sites/AnotherSite

Your web parts should have now returned! Good luck.

SharePoint’s Content Query Web Part (CQWP) is missing!

Applies to: SharePoint Server/on-prem

I love SharePoint’s Content Query Web Part (CQWP) – but if you’re missing a feature in your site collection(s), you may not have it! Luckily you can get it back in just four clicks.

  • Go to Site Settings
  • Click “Site Collection Features” under “Site Collection Administration” (Note: Must have full control or site collection administrator permissions to see this option)
  • Activate “SharePoint Server Publishing Infrastructure
  • Now your CQWP should be available as a web part under Content Rollup.

If you need to activate the SharePoint Server Publishing Infrastructure across all site collections in a web app, I recommend checking out 
Salaudeen Rajack’s site, SharePointDiary.com, for instructions on doing this via PowerShell.

How to give SharePoint link lists a professional look out-of-the-box using the icon library

In the modern SharePoint experience, you can clean up ordinary link lists with very little effort, thanks to SharePoint’s icon library.

chrome_2018-10-23_15-30-53

Whether you need a Teams icon (teams), dog (fangbody), tooth (teeth) or football (football), you can search for icons and use those for adding visual cues and iconography to your sites. Here’s how you can implement this on your page(s):

Continue reading “How to give SharePoint link lists a professional look out-of-the-box using the icon library”

Embed quizzes and/or results in SharePoint using Microsoft Forms

Asset 1quiz.pngThis morning I looked around for either pure javascript or custom service solutions for trivia or quiz embeds for SharePoint. The out-of-the-box survey web part wouldn’t allow the kind of features I needed such as showing a message upon submission about correct and incorrect answers, and I wanted something more robust than a newsfeed or Yammer quiz. I also wanted users to easily be able to change their own quiz questions and answers and no high-maintenance code solution was going to cut it.

What I learned? There aren’t a lot of free solutions out there for quick quiz creation and embedding in SharePoint. And the ones that are out there don’t look the greatest. Then I remembered Microsoft Forms has a quiz function! Don’t these look great? Even better – you can embed in SharePoint Server/On-Prem or SharePoint Online/O365!

sidebyside

Microsoft Form’s quiz capabilities are incredible. In five minutes you can create a quiz that looks good, is easy to update and has features ordinarily only available with a premium subscription through other services. And as seen above, you can embed the results as well, making voting fun or showing a group how everyone is performing as a whole on a topic quiz. Here are some of the great features you get with Microsoft Forms:

Continue reading “Embed quizzes and/or results in SharePoint using Microsoft Forms”

Embedding Power BI Report Server (PBIRS) reports in SharePoint

02

If you’re on-premises and looking to embed a Power BI Report Server report in SharePoint, you’ll find it’s not as easy as O365 embeds. But it’s certainly possible; here’s how:

Continue reading “Embedding Power BI Report Server (PBIRS) reports in SharePoint”

Alerts/notifications for SharePoint site newsfeed webpart posts & replies

newsfeed3.png

One of the greatest business value features of a site newsfeed webpart would obviously be to know when people are participating, asking questions, etc. This way moderators or other interested parties could go in and respond in a timely manner. And while there’s no straightforward way to get these notifications from the webpart itself, there’s a workaround. Follow these steps once you have a newsfeed webpart on your site (by default, most team sites have them already).
Continue reading “Alerts/notifications for SharePoint site newsfeed webpart posts & replies”

Remove select/de-select checkmark column, column headers, edit/new options, and border in SharePoint list view web parts

tooltiplinkedtitlesIn a recent post, I discussed hyperlinking URL title text and adding tooltips. I used the above screenshot which also illustrates what we’ll accomplish in this post which is to remove the select/deselect checkmark column, column headers, toolbar edit/new options and chrome border. This leaves us with a simple title and list. Pick and choose what you’d like to remove for your specific needs, and let me know if you run into any issues.

Continue reading “Remove select/de-select checkmark column, column headers, edit/new options, and border in SharePoint list view web parts”

Creating hyperlinked titles with tooltips in SharePoint link lists using SharePoint Designer workflow

tooltiplinkedtitlesLet’s put those link lists to good use. I wanted one master or parent link list with a number of views. I would then use those views in different list view web parts across my site, removing the toolbar (view/edit/add options), column headers, chrome border and select/deselect checkmark column so that essentially I had a section of my page with a header/chrome title like “HR Forms” (removing default link to “parent” list) and then just a list of hyperlinked form titles with tooltips providing more info on each form as seen above. This post will cover how to get the hyperlinked title text with tooltip. Another post coming soon will cover the “clean-up” of the list view web part so that you’re left with a title and list items alone. Continue reading “Creating hyperlinked titles with tooltips in SharePoint link lists using SharePoint Designer workflow”

Including or excluding multiple property filters in SharePoint search results web part query

In one of my projects, we built a directory largely based on this article with content created by Stacy Deere-Strole of Focal Point Solutions. Something we ran into was wanting to include multiple departments in our base search query (not refiners, as that only narrows our results instead of expanding them). We also wished to eliminate multiple results in the JobTitle property within the query text. While this is a simple solution, hopefully it will save you some trial and error in writing your search language.

Continue reading “Including or excluding multiple property filters in SharePoint search results web part query”