Comments in SharePoint are a bit of a can of worms. There’s two types of comments: Modern comments My issue with the new modern comments is that they do not exist as real list data to be referenced by Power Automate or any kind of automated notifications. People interacting with the items only get notified… Continue reading: Techniques for managing comments in SharePoint lists
Request management (a.k.a. ticketing) can be extremely useful as a tool to manage and track work on a team. At the end of the day, this is essentially a form with a status field to track progress and automated alert rules. This is a replacement for email-based intake of work: the act of putting requests… Continue reading: How to create a request management system in Microsoft 365 with SharePoint
When you’re setting up conditional formatting for columns in SharePoint lists (a.k.a. Microsoft Lists), you are only given the option of configuring rules based on the current column settings that you’re looking at. But what if you want to create a formatting rule that looks at multiple fields? For example, if you want to highlight… Continue reading: Conditionally format a list based on multiple column conditions (no coding required!)
If you work with SharePoint lists, you’ve probably bumped into the list view threshold at one point or another. The gist is: SharePoint can only display 5000 items at a time in a list view. What’s the easiest way to deal with the list view threshold? In my opinion, the easiest way to handle this… Continue reading: Working with the SharePoint 5,000 item list view threshold
SharePoint lists will always come with a “Title” field for its items. This field can’t be deleted, but it can be renamed or hidden. I tend to err on the side of keeping it and renaming it to something more meaningful to the end-user over hiding it, because it’s the field that’s used to open… Continue reading: How to hide the “Title” field in a SharePoint list in SharePoint Online