SharePoint: ISERROR Function
Returns true when a formula evaluates to an error.
CATEGORY
Reference
This is my reference library, the place I send people when they need precise, dependable answers about how a specific function, action, or trigger actually behaves. Tutorials teach you a workflow, but a reference tells you exactly what a piece does, what it expects, and where it bites. My Excel Function Reference breaks down worksheet functions like the "Count" function with clear syntax and examples. The Power Apps Function Reference covers the Power Fx functions you use to build canvas apps, and the SharePoint List Function Reference explains the calculated column functions that shape list data. For automation, the Power Automate Trigger Reference documents how each trigger fires, while the N8N Node Reference and N8N Trigger Reference do the same for the open-source world. An OData Reference handles the query syntax for filtering and sorting data. Every page delivers real syntax, real parameters, and the gotchas I have hit.
Power Automate: toUpper Function
Converts a string to uppercase.
Power Automate: min Function
Returns the lowest number in an array. Works with integers and floats.
Power Apps: DateDiff Function
Returns the difference between two dates in days, hours, months, or other units.
SharePoint: CONCATENATE Function
Joins strings, numbers, and dates into a single value. Up to 30 items.
Power Apps: Today Function
Returns today's date with time set to midnight. Volatile.
Power Automate: addToTime Function
Adds seconds, minutes, hours, or days to a date in one call.
Power Automate: formatDateTime Function
Converts a date into any format using specifiers or custom patterns like 'ddd MM yyyy'.
Power Apps: Mod Function
Returns the remainder of a division.
Power Automate: addSeconds Function
Adds or removes seconds from a date with a custom format.
SharePoint: REPT Function
Repeats a string N times. Result capped at 2000 characters.
Power Apps: Now Function
Returns the current date and time. Volatile.