Filter Pivot Table

This activity allows users to apply filters to a specified Pivot Table by selecting one column (field) names. It is used to refine and display only the required data within the Pivot Table. It must be used within the “Excel Scope” activity.

Properties

Input

Sheet Name: *Specifies the name of the worksheet where the Pivot Table is located. It accepts values of the String data type.

Pivot Table Name: *Specifies the name of the Pivot Table within the selected sheet that needs to be filtered. It accepts values of the String data type.

Column Name: *Specifies the name of the Pivot Table column to apply the filter, along with the condition defined in the configuration.

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.

Options

Configure Filter: Enables configuring a filter condition where the selected column value is matched against the specified value.

Disable filter: Removes the applied filter from the selected column.

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.