Articles → UiPath → Filter Table Activity In Uipath

Filter Table Activity In Uipath






Purpose





Scenario




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




Example




  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
  5. Picture showing the Filter Table activity inside the Excel Application Scope
    Click to Enlarge

  6. In the properties of the "Filter Table", mention the "FilterOptions" attribute
  7. Picture showing the properties of the Filter Table activity
    Click to Enlarge

  8. 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/FeedbackCharacters remaining 250