Sort Table

This activity helps the user to sort the specified table values in Ascending or descending order in the specified sheet. It functions within the “Excel Scope” activity and only table values can be sorted. 

Properties

INPUT

Column Name: *Specify the column name where the data needs to be sorted, and it accepts values of the String datatype. 

Order: *This parameter indicates to choose the order in which the values need to be sorted. Select the values from the drop-down, 
Ascending: Sorts the values from smallest to biggest order (A to Z). 
Descending: Sorts the values from biggest to smallest order (Z to A). 

Sheet Name: *Specify the sheet name where the table is available, and it accepts values of the String datatype. 

Table Name: *Specify the table name where the column needs to be sorted, and it accepts values of the String datatype.  

MISC

DisplayName: Displays the name of the activity. The activity name can be customized, which aids in troubleshooting.

SkipOnError: Specify the “Boolean” value as “True” or “False.”
True: Continue executing the workflow regardless of any errors thrown.
False: Halt the workflow if it encounters any errors.
None: If the option is left blank, the activity will, by default, behave as if “False” were chosen.

Version: It indicates the version of the feature being used.

OUTPUT

Result: This parameter allows you to view the execution status of the activity and returns a value in “Boolean.”
True: Indicates that the activity has been executed successfully without any errors.
False: Indicates that the activity has been unsuccessful due to an unexpected error being thrown.

* Represents mandatory fields to execute the workflow.