List of string operations

Following are the string operations that you can use in the Power Automate Process Mining desktop app.

Note

These operations are available in Power Automate Process Mining desktop app only. They aren't available in other parts of Power Automate, which use Power Fx operations.

CONCAT([string1],...,[stringN])

Concatenates given strings.

Parameters:

• [string1] - input string

  Data type: STRING

• [stringN] - last input string

  Data type: STRING

Output Data Type: STRING

CONTAINS([string],[value])

Returns TRUE if the string contains the given value, else returns FALSE.

Parameters:

• [string] - input string

  Data type: STRING

• [value] - value to be matched in input string

  Data type: STRING

Output Data Type: BOOL

ENDSWITH([string],[value])

Returns TRUE if string ends with the given value, else returns FALSE.

Parameters:

• [string] - input string

  Data type: STRING

• [value] - value to match end of input string

  Data type: STRING

Output Data Type: BOOL

LEFT([string],[count])

Extracts a given number of characters from the left side of a supplied text string.

Parameters:

• [string] - input string

  Data type: STRING

• [count] - number of characters

  Data type: INT

Output Data Type: STRING

LEN([string])

Returns the length of the string.

Parameters:

• [string] - input string

  Data type: STRING

Output Data Type: INT

LOWER([string])

Returns a lower-case version of a given text string.

Parameters:

• [string] - input string

  Data type: STRING

Output Data Type: STRING

LTRIM([string])

Removes whitespace from the beginning of the string.

Parameters:

• [string] - input string

  Data type: STRING

Output Data Type: STRING

RIGHT([string],[count])

Extracts a given number of characters from the right side of a supplied text string.

Parameters:

• [string] - input string

  Data type: STRING

• [count] - number of characters

  Data type: INT

Output Data Type: STRING

RTRIM([string])

Removes whitespace from the end of the string.

Parameters:

• [string] - input string

  Data type: STRING

Output Data Type: STRING

STARTSWITH([string],[value])

returns TRUE if string starts with the given value, else returns FALSE

Parameters:

• [string] - input string

  Data type: STRING

• [value] - value to be matched

  Data type: STRING

Output Data Type: BOOL

SUBSTRING([string],[start],[count])

Returns substring from the specified start position and by the specified number of characters.

Parameters:

• [string] - input string

  Data type: STRING

• [start] - start position of substring

  Data type: INT

• [count] - length of substring

  Data type: INT

Output Data Type: STRING

TOINT([string],[default])

Converts a string to an integer. Returns 0 or default value (optional) if conversion error. occurs

Parameters:

• [string] - input string to be converted

  Data type: STRING

• [default] - default value

  Data type: INT, FLOAT

Output Data Type: INT

TOSTRING([int],[format]*)

Converts an integer to a string according to the formatting string (if an optional parameter is specified).

Parameters:

• [int] - input int value

  Data type: STRING

• [format]* - formatting string

  Learn more about formatting strings

  Data type: STRING (only fixed string is allowed)

Output Data Type: STRING

TOSTRING([float],[format]*)

Converts a float to a string according to the formatting string (if an optional parameter is specified).

Parameters:

• [float] - input float value

  Data type: FLOAT

• [format]* - formatting string

  Learn more about formatting strings

  Data type: STRING (only fixed string in allowed)

Output Data Type: STRING

TOSTRING([bool])

Converts boolean to a string - "True" or "False".

Parameters:

• [bool] - input boolean value

  Data type: BOOL

Output Data Type: STRING

TOSTRING([date],[format]*)

Converts a date to a string according to the formatting string (if an optional parameter is specified).

Parameters:

• [date] - input date

  Data type: STRING

• [format]* - formatting string applied on date

  Learn more about formatting strings

  Date type: STRING (only fixed string is allowed)

Output Data Type: STRING

TOSTRING([time],[format]*)

Converts a time to a string according to the formatting string (if an optional parameter is specified).

Parameters:

• [time] - input time

  Data type: STRING

• [format]* - formatting string applied on time

  Learn more about formatting strings

  Data type: STRING (only fixed string is allowed)

Output Data Type: STRING

TRIM([string])

Removes whitespace at the beginning and at the end of the string.

Parameters:

• [string] - input string

  Data type: STRING

Output Data Type: STRING

UPPER([string])

Returns upper-case version of a given text string.

Parameters:

• [string] - input string

  Data type: STRING

Output Data Type: STRING