This is a little script that works on classic SharePoint lists (modern lists, you should really use PowerApps to customize it). It'll allow you to format a field row, label or the cell the value is in. Similar to: Yes, it's ugly, but I wanted to highlight it plainly: formatRow - allows you to format... Continue Reading →
Using Microsoft Forms Likert questions in Flow
The Likert question type is a great option in Forms, which gives users a matrix of sorts, to provide a valuable answer. Check out this example I use for our user group's feedback survey: Some fun facts about the Likert scale on Wikipedia. Using Microsoft Flow, I'd like to perform some automation when this survey... Continue Reading →
Showing users’ profile pictures in a SharePoint list
Special thanks to Joann for the question! A common use case is to have a list of people in a list in SharePoint, maybe they're members of a project, contacts for a department, your favorite people to talk to, whatever it may be, you have a list. This example is a listing of my teammates: Now I'd... Continue Reading →
SharePoint Script: Hide, Disable and Format your fields
last updated 10/7/2019 This one has been on my list for a while. I've used a collection of JavaScript methods to help streamline customizing forms in lists. I have created and compiled this little collection starting probably 5-6 years ago, and over time I'm constantly updating, tweaking, enhancing it, especially more so as of late... Continue Reading →
My Users Don’t Like SharePoint because they can’t find what they’re looking for! Part 2
This is Part 6 of my series on 'My Users Don't Like SharePoint...' Actually, this is Part 2 of Part 5, if that makes sense. This is a continuation of this post. In the previous post, we covered how easy it is to enhance search to assist your users in finding what they really want. Our... Continue Reading →
Use PowerShell to manipulate the values of a SharePoint choice field.
Thanks to Knoots for suggesting the idea for this post, from a comment on Using PowerShell to play with SharePoint Items.Using PowerShell, we're going to walk through handling a Choice field in a list. Specifically, this is a calendar list using the Category field. This may come in handy if you want to automate changing... Continue Reading →
Creating an item detail dashboard view of your joined lists in SharePoint 2010
Thanks to Stan for suggesting the idea for this post, by leaving a comment here.Our goal here is to take your joined lists and display them on a single page, so you can effectively review an item and its associated information. This is a useful task for creating views of projects with many tasks, milestones, documents,... Continue Reading →
Loading SharePoint lists from Excel using PowerShell
One of my biggest headaches with developing and testing in SharePoint is my lack of test data to work with. Sometimes I need to generate a load of test data so I can perform searches or test performance on custom code. Like in this blog post, I needed to load up a bunch of fake... Continue Reading →
SharePoint Metadata: Filter Page Web Parts
On my list of awesome SharePoint ideas that I want to try and do, was giving users the ability to filter a page based on selected metadata. I decided to hurry up and do it thanks to a question on MSDN forums. Special thanks to Stefan Bauer for the starting of some great code! I've... Continue Reading →
PowerPivot Walkthrough Using SharePoint Lists
Before we can just walk through using PowerPivot and SharePoint, we need to make sure things are in order. Some prerequisites PowerPivot has been installed and properly configured on your farm. Download PowerPivot for Excel 2010, SQL Server 2008 R2 version (SQL 2012 version WILL NOT WORK!) for free at http://www.microsoft.com/download/en/details.aspx?displaylang=en&id=7609. I am using the Northwind sample... Continue Reading →