CATEGORY
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.
Power Automate: SharePoint - When a file is created in a folder Trigger
Fires when a file is created in a SharePoint folder, library, or site page.
SharePoint: Lower Function
Converts a string to lowercase.
Power Automate: SharePoint - Get File Metadata Action
Returns a SharePoint file's path, size, media type, and identifiers.
SharePoint: Import a new Excel automatically to a list
SharePoint: AVERAGE function
Returns the arithmetic mean of number columns. Up to 30 parameters.
Power Automate: Send an HTTP request to SharePoint Action
Calls SharePoint's REST API directly.
SharePoint: Hour Function
Returns the hour component (0-23) of a date or time value.
Power Automate: SharePoint Get Items Action
Returns SharePoint list items with OData filters, pagination, and folder scoping.
How to publish news in modern SharePoint sites from an RSS feed using Power Automate?
SharePoint: WEEKDAY Function
Returns the day-of-week number from a date. Three return-type options.
Power Automate: Create new folder Action
Creates a SharePoint folder. Auto-creates missing parent levels.