Functions

To Base-64 String

To Binary

Converts a base-64 encoded string to an array of bytes.

To Boolean

Converts a value to a Boolean data type.

To Bytes

Converts a string to an array of bytes using the default character encoding.

To Date

To DateTime

To Decimal

To Double

To Integer

To K2 FQN User

Example 1:

Input Value: c:0-.f|ldaproleprovider|legal

Result: K2LDAP:legal

Example 2:

Input Value: c:0-.f|ldaproleprovider|legal;i:0#. f|ldapmembershipprovider|holly

Result: K2LDAP:joe;K2LDAP:holly

To K2 FQN User

Example 1:

Input Value: c:0-.f|ldaproleprovider|legal

Result: K2LDAP:legal

Example 2:

Input Value: c:0-.f|ldaproleprovider|legal;i:0#. f|ldapmembershipprovider|holly

Result: K2LDAP:joe;K2LDAP:holly

To Long

To SharePoint Claims User

To SharePoint Claims User

To Short

To String

To Time

Generate GUID

Generates and returns a GUID in string format.

Add Days

Add Hours

Add Minutes

Add Seconds

Day

Day Difference

Example 1:
First Date: 01/01/2017 00:00:00 AM
Second Date: 01/02/2017 00:00:00 AM
Result: 1.0

Example 2:
First Date: 01/01/2017 00:00:00 AM
Second Date: 01/01/2017 12:00:00 PM
Result: 0.5

End of Month

End of Quarter

Year: 2017
Quarter: 1

Result: 03/31/2017 11:59:59 PM

End of Year

Format Date and Time

Formats a date and time to a text representation using a specified date and time format.

Use the links to see lists of the date and time abbreviations and standard date and time specifiers recognized by the Format Date and Time functions.

Maximum

Result: 01/02/2017 00:00:00 AM

Minimum

Result: 01/01/2017 00:00:00 AM

Month

Now

Quarter

Start of Month

Start of Quarter

Start of Week

Start of Year

Subtract Days

Subtract Hours

Subtract Minutes

Subtract Seconds

Today

Tomorrow

Week Number

Weekday

Year

Yesterday

Get File From Content

Get Process Attachments

Contains

Returns true if the input values are found.

Count

Counts the number of items in a list of values.

Values - Input

Number - Return type

See How to use the Count Function for further information.

First Item

Gets the first value in a list.

Values - Input

Expected When Empty - Object type. This is returned when the input value is invalid

Object - Return value

Values: {1, 2, 3}

Expected When Empty: 0

Result: 1

Index Item

Gets the last value in a list.

Values - Object of array type. e.g. output from a Split() function call can be passed into this parameter. When using an XML node, make sure to use the lowest node in the tree.

Index - Number of long type. This specifies the 1-based index of the item in the array.

Expected When Empty - Object type. This is returned when the input value is invalid or when the index specified is out of bounds.

Object - Return value (Object) is the selected object in the array if there are no errors.

Example 1:

Values: { "a", "b", "c" }

Index: 1

Expected When Empty: "empty"

Result: "a"

Example 2:

Values: { "a", "b", "c" }

Index: 4

Expected When Empty: "empty"

Result: "empty"

Last Item

Gets the last value in a list.

Values - Input

Expected When Empty - Object type. This is returned when the input value is invalid

Object - Return Value

Values: {1, 2, 3}

Expected When Empty: 0

Result: 3

And

False

No

Not

The Not function changes false to true and true to false. Returns a true value if the condition evaluates to false and a false value if the condition evaluates to true.

Or

True

Xor

Yes

Absolute (Decimal)

Absolute (Number)

Average

Format Number

Number: 0.111
Format: "C"
Result: "$ 0.11"

For more examples, see the Format Number Function - Examples table below.

Formula

Use Formula to execute mathematical formulas as a part of rules, mappings, and in notifications. You can only use the following four basic math functions [*, / +, -, and ( )]. You can nest mathematical functions inside another. The exception is you cannot drop a formula function directly into another formula.

Tip: When you work with the formula function, always keep in mind the order or operation. PEMDAS (Parentheses, Exponents, Multiplication, Division, Addition, Subtraction) or BODMAS ( Brackets, Of or Order, Division, Multiplication, Addition and Subtraction).

Input Value: 4*4

Result: 16

Maximum (Decimal)

Maximum (Number)

Minimum (Decimal)

Minimum (Number)

Power (Decimal)

Power (Number)

Random (Decimal)

Random (Number)

Random Between (Decimal)

Random Between (Number)

Root (Decimal)

Root (Number)

Round

Round Down

Round Up

Square (Number)

Square (Decimal)

Square Root (Decimal)

Square Root (Number)

Sum (Number)

Sum (Decimal)

Match

For doing a regular expression pattern match of a value. e.g. to check if the input value is a valid E-mail address.

Input – Input text to search on. This is a string type.

Regex Pattern – Regular expression pattern to use for the search.

Case Sensitive – Option to indicate whether the search should be case sensitive or not.

Return value (Boolean) - is true if a match was found, otherwise false.

Example 1:
Input: "Examples"
Pattern: "\\b\\w+es\\b"
Case Sensitive: true
Result: true

Example 2:
Input: "Example"
Pattern: "\\b\\w+es\\b"
Case Sensitive: true
Result: false

Example 3:
Input: ""
Pattern: "[a-z]*"
Case Sensitive: true
Result: true

Note that * will always return a match

Example 4:
Input: ""
Pattern: "[a-z]"
Case Sensitive: true
Result: false

Example 5:
Input: "Examples"
Pattern: "\\b\\w+es\\b"
Case Sensitive: false
Result: true

Matches words ending in 'es'

Example 6:
Input: "Example"
Pattern: "\\b\\w+es\\b"
Case Sensitive: false
Result: false

Matches words ending in 'es'

Match Multiple

To match multiple values from the input string value using a regular expression pattern. e.g. Finding all claim codes in a text form that has “CLM” in front followed by a fixed 5 digit number.

Input – Input text to search on. This is a string type.

Regex Pattern – Regular expression pattern to use for the search.

Case Sensitive – Option to indicate whether the search should be case sensitive or not.

Return value (String[]) - is the array of string values that matched the pattern. If there is no match, it returns No match found.

Example 1:
Input: "example"
Pattern: "[a-z]*"
Case Sensitive: "true"
Result: { "example" }

Example 2:
Input: "Example"
Pattern: "[a-z]*"
Case Sensitive: "true"
Result: { "xample" }

Example 3:
Input: "example"
Pattern: "[a-z]*"
Case Sensitive: false
Result: { "example" }

Example 4:
Input: "Example"
Pattern: "[a-z]*"
Result: { "Example" }

To

To match a single value string from the input string value using a regular expression pattern. e.g. Finding a user’s name specified in a text form.

Input – Input text to search on. This is a string type.

Regex Pattern – Regular expression pattern to use for the search.

Case Sensitive – Option to indicate whether the search should be case sensitive or not.

Expected When Empty – String type. This is returned when there is no match found or the matched value is empty.

Return value (String) - is the matched string if there is a match.

Example 1:
Input: "Example"
Pattern: "[a-z]*"
Case Sensitive: true
Expected When Empty: "empty"
Result: "empty"

Example 2:
Input: "An example"
Pattern: "\\b\\w+es\\b"
Case Sensitive: true
Expected When Empty: "empty"
Result: "empty"

Example 3:
Input: "example;"
Pattern: "[a-z]*"
Case Sensitive: true
Expected When Empty: "empty"
Result: "example"

Example 4:
Input: "Example"
Pattern: "[a-z]*"
Case Sensitive: false
Expected When Empty: "empty"
Result: "Example"

Example 5:
Input: "example"
Pattern: "[a-z]*"
Expected When Empty: "empty"
Result: "example"

Hyperlink

Contains

Empty String

Find

Insert

Join

Left

Length

Mid

Pad Left

Pad Right

Proper

Replace

Right

Split

To Lower

To Upper

Trim

URL Decode

URL Encode