SharePoint: Choose Function
Returns one value from a set based on an index number. Up to 29 items.
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.
When to use OneDrive vs SharePoint Sites Libraries
SharePoint: IF Function
Returns one value if a condition is true, another if false. Nests up to 7 levels.
SharePoint: The balance between choice and lookup
SharePoint: ISERROR Function
Returns true when a formula evaluates to an error.
SharePoint: Different View for the same data
SharePoint: CONCATENATE Function
Joins strings, numbers, and dates into a single value. Up to 30 items.
SharePoint: Create a list based on folders
SharePoint: Properly translate your list column names
Power Automate: Save multi-choice Microsoft Forms
SharePoint: REPT Function
Repeats a string N times. Result capped at 2000 characters.
SharePoint: Now Function
Returns the current date and time as a serial number.