How to deal with filter on the excel pivot table - Studio X

Help StudioX
1

Hi team,

I’m trying to selecting several items on the filter in the excel pivot table.
I can change one item on the filter by typing in “the text” to pick up the item using UI element. However, it doesn’t work when I try to select mulptiple items on the filter.

Alternatively, when I try to select the items on the filter, I’m faced with the issue that UiPath doesn’t recognise the check mark (small square) on the left side of the item in the filter, and then UiPath replied with the error messsage like
“Unable to get the data on the element selector
Reason : Error HRESULT E_FAIL was returned from COM component”

I highly appreicate if you give me the help on this topic !

2

Hi @nadach02 ,

Welcome to UiPath Forum

Kindly check this suggestion

  1. Click on the filter drop-down arrow on the Pivot Table.
  2. Type in the first item you want to select in the search box, and press Enter.
  3. Hold down the Ctrl key on your keyboard, and click on the check mark (small square) on the left side of each additional item you want to select.
  4. Once you have selected all the desired items, click the OK button to apply the filter.

If UiPath StudioX still doesn’t recognize the check mark on the left side of the items in the filter, you may need to use a different selector or activity to select the items. You can try using the Click activity with a relative selector or anchor base, or the Select Item activity with a dynamic selector that includes the item text. You can also check if there are any Excel Add-ins or settings that may be causing the issue, and try disabling or adjusting them as needed.

Thanks,

3

Hi @RajKumar_DC

Thank you for the support !
Thanks to your assistance and advice, I have found what I want to do works fine with the repetitive cycle in the following.

  1. Use Click activity and recognize arrorw icon of the filter by using normal UI element
  2. Use Type into activity. Reconize “Search bar” in the filter by using normal UI element and Type “item’s name” we want to select in the search bar
  3. Use Click activity and select “OK” button in normal UI element
    — add items selected in the filter ----
  4. Use Click activity and recognize filter icon (former arrow icon) of the filter by using normal UI element
  5. Use Type into activity. Recognize “Search bar” in the filter by using normal UI element and Type “item name” we want to select in the search bar
  6. Use Click activity and press “F3” button to use image region recognition and circle “small square” of “add the current selected item on the existing filter”.
  7. Use Click activity and select “OK” button in normal UI element.
    ---- If we want to add more items in the filter, repeat 4 to 7 in the above.