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

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. 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 […]

Set multiple choices as default values for checkbox fields in SharePoint forms

I recently worked on a project for a client that needed 2/3 checkbox options checked by default on a new form. While not as straight-forward as other field types, it’s still certainly possible. Go to List –> List Settings (server/on-prem) or settings wheel –> List Settings (online/O365) Click the name of your checkbox/choice column to edit […]

Automatically open SharePoint 2013 workflow tasks in Edit mode for easy one-click approvals

On one of my recent projects, a client asked if it would be possible for the link to a task within a workflow notification email to open the task in “edit” mode instead of “display”. If you’re unfamiliar with SharePoint 2013 task processes built in SharePoint Designer, here’s what their process looked like prior to […]

Win a free full-conference pass to SPTechCon in Boston Aug 26 – 29

SPTechCon is one of the largest SharePoint and O365 conferences available. You can win a free full-conference (4-day) pass simply by tuning in to next week’s Lawrence SharePoint User Group (LSPUG) meeting. Microsoft MVP Melissa Hubbard and April Dunnam will be presenting “Microsoft Flow and SharePoint: Integration and Automation”. Learn more about the session here.

How to create a powerful date table or DateKey in Power BI

DateKeys are essential for relative time measures. In “manage relationships” you tie the ‘DateKey'[Date] to a date field in each of your data sources. Giles Walker shared an excellent solution for a robust DateKey that includes measurements and calculations you’re sure to find useful. Here’s that same solution I’ve modified and expanded to be as […]