Filter Table in excel data tables

hi @ask_565

You can use Filter Table Activity Within Available->App Integration ->Excel->Table->filter table and on Tables within an Excel File you can use it.

By using This you can filter the table.

It will require three data from your side:

  1. Sheet Name(on which sheet you wants to perform).
  2. Table Name(On which table you wants to use filter operation).
  3. Column Name( On which column basis you wants to perform the filter operation).

As you asked About its “Filter Operation” Properties so let me tell you by using this property you can Filter a particular column.

For example You have 3 columns name First Name, Last Name, Email having values in a table.
So if you wants to perform On First Name (You have already mentioned it in Filter Table activity) value like you wants to find abc name the pass it like this {“abc”}.

After this you will find that your excel file has been filtered with abc name. You can reset manually by click on that column filters again to see all values.

For further Understanding you can see this attached sample solution.
Filter Table.zip (9.2 KB)

Regards…!!

11 Likes