Hey Guys,
with a filter in Excel, I need UiPath to always select the last checkbox option of a filter.
Is there anyway to tell the Robot to do that?
Thank you,
Rebekka
Hey Guys,
with a filter in Excel, I need UiPath to always select the last checkbox option of a filter.
Is there anyway to tell the Robot to do that?
Thank you,
Rebekka
@rebekka.haendel Is it the Last Checkbox Option or is it the Value that is always constant that needs to be filtered?
@rebekka.haendel Can you show the Last option that you want to Filter in a Screenshot, If the Options in Filtering are based on a Order, then we can Sort the Datatable based on that order and get the Last Element Value According to it.
I am looking at the following pivot-table
and the last filter option (22020) to be checked. It is always the last one.
@rebekka.haendel I donāt think i have the best Solution , I have done it using a Sample File. To Filter Only the Last Value in the Filter Options by using UI Automation activities. I think thereās a better way to filter using Macros. I can send the sample Workflow but it Still Requires more Stability.
A way to this, is to go to the cell with the header of the table, in the specific column and from there use hotkeys:
[alt] + [down] (opens the drop down menu)
[shift] + [tab] repeated three times (changes focus to āSelect Allā)
[space] (unselect all)
[End] (goes to last entry)
[space] (selects last entry)
[Enter]
It is not a nice solution, but it might help you to move on.
@rebekka.haendel You can check this, This will only work for the Excel File present in it. If it works when you execute, you should change it to adapt to your Excel File. I donāt recommenrd this as a Solution though
FilterDataUsingUI.zip (8.5 KB)
Thank you!! I appreciate your help and time a lot.
Can you specify what you mean by āgo to the cell with the header of the tableā ?
Go to the cell, in which you has to apply the filter. So you need to be in the cell with āMonatā