Articles → UiPath → Filter Table activity in UiPath

Filter Table activity in UiPath

In this article, we will discuss the "Filter Table" activity in UiPath.

Purpose

The "Filter Table" activity applies the filter on the column of the excel file.

Scenario

Consider the following excel file.

Picture showing the data in excel on which filter will be applied

Click to Enlarge

Our requirement is - apply the filter on the "Breakfast" column where value is "Poha".

Example

In this example, we will perform the following activities.

      1. Drag and drop the "Excel Application Scope" activity.

      2. Mention the excel file name inside the "Excel Application Scope".

      3. In the "Excel Application Scope" activity, drag and drop the "Filter Table" activity.

      4. Mention the sheet name, table name and the column name.

Picture showing the Filter Table activity inside the Excel Application Scope

Click to Enlarge

5. In the properties of the "Filter Table", mention the "FilterOptions" attribute.

Picture showing the properties of the Filter Table activity

Click to Enlarge

6. Save the file and run the bot.

Output

Picture showing the filtered record using the Filter Table activity

Click to Enlarge

Posted By -	Karan Gupta

Posted On -	Friday, January 22, 2021

Query/Feedback

Your Email Id

Subject

Query/Feedback	Characters remaining 250