concat String
Joins two or more strings together and returns the combined result.
length String
Returns the number of characters in a string, or the number of items in an array.
substring String
Returns a portion of a string starting at the given index. If length is omitted, returns everything from startIndex to the end.
indexOf String
Returns the zero-based starting position of a substring within a string. Returns -1 if the substring is not found.
replace String
Replaces all occurrences of a substring within a string with a new value.
split String
Splits a string into an array of substrings at each occurrence of the delimiter.
toLower String
Converts all characters in a string to lowercase.
toUpper String
Converts all characters in a string to uppercase.
trim String
Removes leading and trailing whitespace from a string.
startsWith String
Returns true if a string begins with a specific substring.
endsWith String
Returns true if a string ends with a specific substring.
contains String
Returns true if a string contains a specific substring, or if an array contains a specific value.
guid String
Generates a new globally unique identifier (GUID) as a lowercase string.
padLeft String
Pads the left side of a string with a character until it reaches the specified total length.
nthIndexOf String
Returns the starting position of the Nth occurrence of a substring within a string.
first Collection
Returns the first item in an array or the first character in a string.
last Collection
Returns the last item in an array or the last character in a string.
skip Collection
Removes a specified number of items from the start of an array and returns the remaining items.
take Collection
Returns a specified number of items from the start of an array.
join Collection
Joins all items in an array into a single string, separated by a delimiter.
union Collection
Returns an array containing all unique items from all provided arrays. Duplicates are removed.
intersection Collection
Returns an array containing only the items that appear in all provided arrays.
empty Collection
Returns true if a string, array, or object has no items or characters.
createArray Collection
Creates and returns an array from the provided values.
range Collection
Returns an array of integers starting from a given value and containing a specified number of integers.
if Logical
Returns one value if a condition is true and a different value if the condition is false. Equivalent to an inline ternary operator.
coalesce Logical
Returns the first non-null value from the list. Very useful for providing fallback defaults when a value might be null or missing.
equals Logical
Returns true if both values are equal. Comparison is case-sensitive for strings.
not Logical
Returns the logical opposite of a boolean value. True becomes false and false becomes true.
and Logical
Returns true only if all provided expressions evaluate to true.
or Logical
Returns true if at least one of the provided expressions evaluates to true.
greater Logical
Returns true if the first value is greater than the second value.
greaterOrEquals Logical
Returns true if the first value is greater than or equal to the second value.
less Logical
Returns true if the first value is less than the second value.
lessOrEquals Logical
Returns true if the first value is less than or equal to the second value.
add Math
Returns the sum of two numbers.
sub Math
Returns the result of subtracting the second number from the first.
mul Math
Returns the product of multiplying two numbers together.
div Math
Returns the result of dividing the first number by the second number.
mod Math
Returns the remainder after dividing the first number by the second.
min Math
Returns the smallest value from an array of numbers, or the smaller of two numbers.
max Math
Returns the largest value from an array of numbers, or the larger of two numbers.
abs Math
Returns the absolute (positive) value of a number.
power Math
Returns the result of raising a base number to the power of an exponent.
utcNow Date and Time
Returns the current date and time in UTC as a string. An optional format string can control the output format.
formatDateTime Date and Time
Converts a date-time value to a formatted string using a .NET format pattern.
addDays Date and Time
Adds a number of days to a date-time value. Use a negative number to subtract days.
addHours Date and Time
Adds a number of hours to a date-time value. Use a negative number to subtract hours.
addMinutes Date and Time
Adds a number of minutes to a date-time value.
convertTimeZone Date and Time
Converts a date-time from one time zone to another using IANA or Windows time zone names.
dayOfWeek Date and Time
Returns the day of the week as an integer where 0 is Sunday, 1 is Monday, through to 6 for Saturday.
dayOfMonth Date and Time
Returns the day of the month as an integer from 1 to 31.
startOfDay Date and Time
Returns the start of the day (midnight, 00:00:00) for the given date-time.
ticks Date and Time
Returns the number of ticks (100-nanosecond intervals since January 1, 0001) for a date-time. Useful for comparing dates arithmetically.
string Conversion
Converts any value to a string. Useful for concatenating numbers or booleans with text.
int Conversion
Converts a string or number to an integer. The decimal part is truncated.
float Conversion
Converts a string or integer to a floating-point number.
bool Conversion
Converts a value to a boolean. The string 'true' returns true and 'false' returns false.
json Conversion
Parses a JSON-formatted string and returns the corresponding object or array.
array Conversion
Wraps a single value in an array. If the value is already an array, it is returned as-is.
base64 Conversion
Encodes a string as a base64-encoded string.
base64ToString Conversion
Decodes a base64-encoded string back to a plain text string.
encodeUriComponent Conversion
Encodes a string for safe use in a URL by replacing special characters with percent-encoded equivalents.
decodeUriComponent Conversion
Decodes a percent-encoded URL component back to a readable string.
body Workflow
Returns the body output of a previously run action. The action name must match exactly including case and spaces.
outputs Workflow
Returns the full outputs of a previously run action including headers, body, and status code.
triggerBody Workflow
Returns the body content from the trigger that started the flow. For form submits, webhooks, or manual triggers this contains the incoming data.
triggerOutputs Workflow
Returns the complete outputs from the trigger including headers, body, and any metadata.
variables Workflow
Returns the current value of a flow variable that was initialized with an Initialize variable action.
parameters Workflow
Returns the value of a flow parameter defined in the flow's parameter configuration. Use parameters to avoid hardcoding values.
result Workflow
Returns the results of all actions within a scope, including their status, inputs, and outputs. Used in error handling after a scope.