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