SharePoint: CONCATENATE Function
Joins strings, numbers, and dates into a single value. Up to 30 items.
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 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.
Power Automate: addMinutes Function
Adds or removes minutes from a date with a custom format. No date range limits.
SharePoint: Now Function
Returns the current date and time as a serial number.
Power Apps: Round Function
Rounds a number to a given decimal place using half-round-up.
Power Automate: addDays Function
Adds or subtracts days from a date. The day count must be an integer, not a decimal.