Variables actions

To manually create a variable in a desktop flow, deploy the Set variable action. This action requires you to provide a name and a value for the new variable.

Screenshot of the Set variable action.

To increase or decrease the value of a numeric variable, use the Increase variable and Decrease variable actions, respectively.

Screenshot of the Increase variable action.

Most actions output their result into a variable. For example, the Create new list action produces an empty list.

Similarly, the Generate random number action produces a random numeric value. If you enable Generate multiple numbers in this action, you'll create a list variable containing multiple random numeric values.

Screenshot of the Generate random number action.

To add items to an existing list, deploy the Add item to list action, and populate a hard-coded value or a variable to define the item to add. Likewise, you can remove items from a list with the Remove item from list action.

Note

List indexes start from 0, meaning that the first item in the list always has an index of 0. Use the notation %ListName[0]% to refer to the first item in the list, %ListName[1]% to the second, and so on.

If you want to create a data table variable, deploy the Create new data table action and specify the initial items of it using the visual builder.

To manipulate a data table variable, use the actions of the respective action subgroup, such as the Find or replace in data table and Update data table item actions.

Screenshot of the Create new data table action.

Create new data table

Creates a new data table variable.

Input parameters

Argument Optional Accepts Default Value Description
New table No Datatable The input data table

Variables produced

Argument Type Description
DataTable Datatable The new data table

Exceptions

This action doesn't include any exceptions.

Insert row into data table

Inserts a row at the end or before a specific index value.

Input parameters

Argument Optional Accepts Default Value Description
Data table No Datatable The data table variable to work with. This variable must have been previously specified by an action that produces a data table variable
Into location N/A End of data table, Before row index End of data table Specify whether to insert the new row at the end of the data table or before a specified row index
Row index No Numeric value Insert the row index value to be used when before row index is specified as the into location parameter
New value(s) No List, Datarow This parameter accepts a list or datarow variable where the column count should match the column count in the data table

Variables produced

This action doesn't produce any variables.

Exceptions

Exception Description
Item index is out of range Indicates that the provided item index is out of range
Invalid input arguments Indicates that there's an invalid input parameter
Incompatible type error Indicates that an input parameter of an incompatible type has been provided

Find or replace in data table

Finds and/or replaces data table values.

Input parameters

Argument Optional Accepts Default Value Description
Data table No Datatable The data table variable to work with. This variable must have been previously specified by an action that produces a data table variable
Search mode N/A Find, Find and replace Find The mode to search with (find or find and replace)
All matches N/A Boolean value True Specify whether to find or replace text in all the matching cells found or the first matching cell only
Text to find No Text value The text to find in the data table
Find using a regular expression N/A Boolean value False Specify whether to use a regular expression to match the cell contents with the text to find
Match case N/A Boolean value False Specify whether to search for case-sensitive data
Match entire cell contents N/A Boolean value False Specify whether to search for cells that contain just the specified text
Text to replace with No Text value The text used to replace the matching cells
Search by N/A Everywhere, On column Everywhere The order in which to search for the text (everywhere, or on column)
Column index or name No Text value The column header or index value

Variables produced

Argument Type Description
DataTableMatches Datatable The data table containing the row and column indexes for matches

Exceptions

Exception Description
Provided regular expression is invalid Indicates that the provided regular expression is invalid
Column name doesn't exist Indicates that the provided column name doesn't exist
Column index is out of range Indicates that the provided column index is out of range
Incompatible type error Indicates that an input parameter of an incompatible type has been provided

Update data table item

Update a data table row item on a defined column.

Input parameters

Argument Optional Accepts Default Value Description
Data table No Datatable The data table variable to work with. This variable must have been previously specified by an action that produces a data table variable
Column No Text value The column name or index of the item to update
Row No Numeric value The row index of the item to update
New value No Text value The new value to update at the specified row index and column

Variables produced

This action doesn't produce any variables.

Exceptions

Exception Description
Item index is out of range Indicates that the specified data table item is out of range
Column name doesn't exist Indicates that the provided column name doesn't exist
Column index is out of range Indicates that the provided column index is out of range
Incompatible type error Indicates that an input parameter of an incompatible type has been provided

Delete row from data table

Update a data table row item on a defined column.

Input parameters

Argument Optional Accepts Default Value Description
Data table No Datatable The data table variable to work with. This variable must have been previously specified by an action that produces a data table variable
Row index No Numeric value The row index within a data table that should be deleted

Variables produced

This action doesn't produce any variables.

Exceptions

Exception Description
Item index is out of range Indicates that the specified data table item is out of range

Truncate number

Get the integral or fractional digits of a numeric value, or round up the value to a specified number of decimal places.

Input parameters

Argument Optional Accepts Default Value Description
Number to truncate No Numeric value The number or variable that holds the numeric value to truncate/round up
Operation N/A Get integer part, Get decimal part, Round number Get integer part Specifies the operation to perform on the given number
Decimal places Yes Numeric value 3 The number of decimal places to round the given number up to. Enter 0 to return an integer as a result

Variables produced

Argument Type Description
TruncatedValue Numeric value The truncated or rounded number

Exceptions

This action doesn't include any exceptions.

Generate random number

Generate a random number or a list of random numbers that fall between a minimum and maximum value.

Input parameters

Argument Optional Accepts Default Value Description
Minimum value Yes Numeric value 0 The lower boundary for the random number(s) to generate
Maximum value Yes Numeric value 100 The upper boundary for the random number(s) to generate
Generate multiple numbers N/A Boolean value False Specifies whether to generate a single random number or a list of random numbers
How many numbers Yes Numeric value 10 Specifies how many random numbers to generate
Allow duplicates N/A Boolean value False Specifies whether to permit or prevent the same number from appearing more than once in the random numbers list

Variables produced

Argument Type Description
RandomNumber Numeric value The newly generated random number
RandomNumbers List of Numeric values The newly generated list of random numbers

Exceptions

Exception Description
Failed to generate random number Indicates that there's an error generating a random number

Clear list

Remove all items from a list.

Input parameters

Argument Optional Accepts Default Value Description
List to clear No List of General values A list variable to remove its elements

Variables produced

This action doesn't produce any variables.

Exceptions

This action doesn't include any exceptions.

Remove item from list

Remove one or multiple items from a list.

Input parameters

Argument Optional Accepts Default Value Description
Remove item by N/A Index, Value Index Specifies whether to remove the item at a specified index or the item(s) with a specific value
At index No Numeric value The index number of the item to remove
With value No General value The item to remove
Remove all item occurrences N/A Boolean value False Removes all the occurrences that match the item specified
From list No List of General values The list with items to remove
Variables produced

This action doesn't produce any variables.

Exceptions

Exception Description
Item index is out of range Indicates that item index is out of range
Item not found Indicates that item doesn't exist in the list

Sort list

Sort the items of a list. Use items of the same type.

Input parameters

Argument Optional Accepts Default Value Description
List to sort No List of General values The variable that holds the list to sort
Sort by list item's properties N/A Boolean value False If the list items are objects (such are files, folders, etc.), enable this option to sort the item by a specific property. Leave this option disabled to sort the elements by their default property (e.g., file objects will be sorted by their full path)
First property to sort by Yes Text value The name of an item's property to sort the list by. Refer to the help file for the property names of each object
Sort N/A Ascending, Descending Ascending Specifies whether to sort by the first property ascending or descending
Second property to sort by Yes Text value The name of a second property to sort the list by
Sort N/A Ascending, Descending Ascending Specifies whether to sort by the second property ascending or descending
Third property to sort by Yes Text value The name of a third property to sort the list by
Sort N/A Ascending, Descending Ascending Specifies whether to sort by the third property ascending or descending

Variables produced

This action doesn't produce any variables.

Exceptions

This action doesn't include any exceptions.

Shuffle list

Create a random permutation of a list.

Input parameters

Argument Optional Accepts Default Value Description
List to shuffle No List of General values The variable that contains the list to shuffle

Variables produced

This action doesn't produce any variables.

Exceptions

This action doesn't include any exceptions.

Merge lists

Merge two lists into one.

Input parameters

Argument Optional Accepts Default Value Description
First list No List of General values The first list of items to merge
Second list No List of General values The second list of items to merge

Variables produced

Argument Type Description
OutputList List of General values The merged list. The initial lists aren't affected

Exceptions

Exception Description
The lists supplied are of incompatible types Indicates that the lists supplied are of incompatible types

Reverse list

Reverse the order of the items of a list.

Input parameters

Argument Optional Accepts Default Value Description
List to reverse No List of General values The list whose items order to reverse
Variables produced

This action doesn't produce any variables.

Exceptions

This action doesn't include any exceptions.

Remove duplicate items from list

Remove the multiple occurrences of items in a list, so that in the resulting list each item will be unique.

Input parameters

Argument Optional Accepts Default Value Description
List to remove duplicate items from No List of General values The list variable to remove duplicate items from
Ignore text case while searching for duplicate items N/A Boolean value False Specifies whether to perform case insensitive comparison of text while searching for duplicate items (only applies to lists made of text items)

Variables produced

This action doesn't produce any variables.

Exceptions

This action doesn't include any exceptions.

Find common list items

Compare two lists and create a new list with the items that are common to both.

Input parameters

Argument Optional Accepts Default Value Description
First list No List of General values The variable that contains the first list to compare
Second list No List of General values The variable that contains the second list to compare

Variables produced

Argument Type Description
IntersectionList List of General values The new list of common items

Exceptions

This action doesn't include any exceptions.

Subtract lists

Compare two lists and create a new list with the items that are in the first list but not in the second.

Input parameters

Argument Optional Accepts Default Value Description
First list No List of General values The variable that holds the first list to compare
Second list No List of General values The variable that holds the second list to compare

Variables produced

Argument Type Description
ListDifference List of General values The new resulting list

Exceptions

This action doesn't include any exceptions.

Retrieve data table column into list

Convert the contents of a data table column into a list.

Input parameters

Argument Optional Accepts Default Value Description
Data table No Datatable The data table with the column to convert into a list
Column name or index No Text value The column name, if column names are defined, or the index number of the column to retrieve

Variables produced

Argument Type Description
ColumnAsList List of General values The new list that holds the contents of the specified data table

Exceptions

Exception Description
Column name doesn't exist Indicates that the column name isn't in the data table
Column index is out of range Indicates that the column index is out of range

Convert JSON to custom object

Convert a JSON string to a custom object.

Input parameters

Argument Optional Accepts Default Value Description
JSON No Text value A JSON text, or a previously created variable containing one, to convert it to a custom object

Variables produced

Argument Type Description
JsonAsCustomObject General value The converted custom object from the provided JSON

Exceptions

Exception Description
Error parsing the JSON Indicates that there's an error parsing the specified JSON

Convert custom object to JSON

Convert a custom object to a JSON string.

Input parameters

Argument Optional Accepts Default Value Description
Custom object No Custom object The custom object to convert to JSON

Variables produced

Argument Type Description
CustomObjectAsJson Text value The converted JSON from the provided custom object

Exceptions

Exception Description
Error parsing the custom object Indicates that there's an error parsing the custom object

Add item to list

Append a new item to a list.

Input parameters

Argument Optional Accepts Default Value Description
Add item No General value A value or a variable to add to the list. Provide a list of values to append multiple elements. If the list has a specific type of elements, the new element is converted over to that type
Into list No List of General values A list variable to append the new elements to

Variables produced

Argument Type Description
NewList List of General values The new list

Exceptions

This action doesn't include any exceptions.

Create new list

Create a new empty list.

Input parameters

This action doesn't require any input.

Variables produced

Argument Type Description
List List of General values The new list

Exceptions

This action doesn't include any exceptions.

Increase variable

Increase the value of a variable by a specific amount.

Input parameters

Argument Optional Accepts Default Value Description
Variable name No Numeric value The numeric value to increase
Increase by No Numeric value A numeric value, or a previously created variable containing one, to increase the variable by

Variables produced

This action doesn't produce any variables.

Exceptions

This action doesn't include any exceptions.

Decrease variable

Decrease the value of a variable by a specific amount.

Input parameters

Argument Optional Accepts Default Value Description
Variable name No Numeric value A numeric value, or a previously created variable containing one, to decrease the variable by
Decrease by No Numeric value A numeric value, or a previously created variable containing one, to decrease the variable by

Variables produced

This action doesn't produce any variables.

Exceptions

This action doesn't include any exceptions.

Set variable

Set the value of a new or existing variable, create a new variable or overwrite a previously created variable.

Input parameters

Argument Optional Accepts Default Value Description
To No * The value to assign to the variable

Variables produced

Argument Type Description
NewVar * The name of the variable to set

Note

Produced variable names can't contain special characters, white spaces, and non-latin characters. Also, they can't start with arithmetic characters.

Exceptions

This action doesn't include any exceptions.