SharePoint
SharePoint is where a huge amount of team work actually lives, and I want to help you get the most out of it. Here you find my hands-on articles on lists, document libraries, permissions, and the automation that ties everything together. If you manage files, I walk through how to add properties to SharePoint files, check whether a document library already exists, and create nested folders while copying templates using Power Automate. Love a tidy interface? I cover advanced column formatting, calculated fields, and how to color-code your columns so a list tells its story at a glance. There are fixes for the little things that trip people up, like images not showing in Gallery View, plus bigger ideas such as publishing news straight from an RSS feed and setting up automatic document management. You will also find best practices and reference pieces like lookup and reverse lookup tables.
SharePoint: Trim Function
Removes leading, trailing, and extra internal spaces from text.
Power Automate: Get dynamic information from SharePoint
SharePoint: Round Function
Rounds a number to a given number of decimal places.
SharePoint: Int Function
Converts a value to an integer by rounding down.
Power Automate: SharePoint - When a file is created (properties only) Trigger
Fires when a SharePoint file is created. Returns metadata only, not content.
SharePoint: RoundUp Function
Rounds a number up. Negative values round away from zero.
Power Automate: SharePoint - List folder Action
Returns the files and subfolders inside a folder. Goes one level deep and needs the folder ID, not its path.
Power Automate: How to parse an array more efficiently
How to add Forms uploads into a SharePoint list as attachments?
Power Automate: SharePoint - When an item is created or modified Trigger
Fires when a SharePoint list item is created or modified. Polls on an interval, not instant
SharePoint: RoundDown Function
Rounds a number down. Negative values round toward zero.