Filter Table

This activity allows users to filter table values based on a specified column in an Excel sheet. It must be used within the “Excel Scope” activity. 

Properties

INPUT

Sheet Name: *Specify the sheet name where the filter options will be applied to the specified table. This field accepts values in the “String” data type, which can either be hardcoded or assigned to a “String” variable.

Table Name: *Specify the name of the table where the filter options will be applied. This field accepts values in the “String” data type, which can be either hardcoded or assigned to a “String” variable.

Column Name: *Specify the name of the column to apply the filter options. This field accepts values in the “String” data type, which can be either hardcoded or assigned to a “String” variable.

FilterOptions: *Provide the filter options to be applied to the specified column. This parameter accepts values in the “Array of String” data type, which can be either hardcoded or assigned to an array of “String” variables.
Note: You can specify a single filter value or multiple values, e.g., {“100”, “150”}. 

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