Help with Filter Pivot Table

Help Activities
, ,
1

Hey, i have a issue with the Filter Pivot Table Activity, I have a dynamic table in excel where i have to filer by position.

The image shows a screenshot of a workflow automation process in UiPath, featuring Excel activities like refreshing and filtering a pivot table, with various arguments and variables defined. (Subtitulado por IA)
The image shows a screenshot of a workflow automation process in UiPath, featuring Excel activities like refreshing and filtering a pivot table, with various arguments and variables defined. (Subtitulado por IA)1461×847 84.9 KB

As you can see in the image, im trying to filter by the position 10. The way i do that is, first step clear the filter, i have a “String.Empty” in the first filter, by executing i can see how it clears the dynamic table but manteining the position 80, after that i use in the second filter pivot table the value seen in the log message, in_Positions.Rows(0).Item(0).ToString.

This image shows a spreadsheet with various columns and rows open in Excel, depicting data entries, dropdown filters, and a large "ACTUALIZAR" button in the center. (Subtitulado por IA)
This image shows a spreadsheet with various columns and rows open in Excel, depicting data entries, dropdown filters, and a large "ACTUALIZAR" button in the center. (Subtitulado por IA)1908×512 59.6 KB

I dont know what else to try, thanks.

2

@itorre

in first one you just need to check the clear any filter option then in next one add the filters you need

cheers

3

I’ve tryied but doesn’t clear it

The image shows a workflow automation process involving a pivot table refresh and filter operation in an Excel sheet, alongside the Excel interface with a filtered pivot table displaying sales data. (Subtitulado por IA)
The image shows a workflow automation process involving a pivot table refresh and filter operation in an Excel sheet, alongside the Excel interface with a filtered pivot table displaying sales data. (Subtitulado por IA)1266×863 85 KB

4

@itorre,

This could be due to data is being filtered using excel slicer and not by pivot table filter

The image shows a spreadsheet with dropdown lists labeled "Doc. venta," "Pos.," and "Tipo Dato," alongside a blue button labeled "ACTUALIZAR." (Captioned by AI)
The image shows a spreadsheet with dropdown lists labeled "Doc. venta," "Pos.," and "Tipo Dato," alongside a blue button labeled "ACTUALIZAR." (Captioned by AI)1099×194 42.4 KB

You will have to use VBA code to filter the data by changing the slicer selections.

5

@itorre

  1. Clear filtwr is basically to have no filters that means all would be displayed
  2. Also if slicer are used other than gilter then filter pivot would not work

Cheers

6

So, what should i use?

7

@itorre

You need to go with macros and use invoke vba or execute macro activities

Cheers

8

@itorre please check this answer

  • Use Nothing (not String.Empty) to clear filter.
  • Ensure this is a string:
    in_Positions.Rows(0).Item(0).ToString.Trim
  • Add “Refresh Pivot Table” before filtering.
  • Double-check field name is exact match (“Position”).