UI Path StudioX Filter Problem while Adding Multiple Filters

Help StudioX
, ,
1

Hi There!
I was trying to apply multiple filters, on my excel sheet via StudioX. I used 2 steps for this. Use the excel sheet and add filter 1. Use the excel sheet add filter 2. But it only considered filter 2 and removed filter 1. I did not tick on the box stating: “Clear any existing filter”. Please help me!
Regards,
Aaryaman Gupta

2

Hello @Aaryaman_Gupta

The Filter activity should be cumulative if you provide the exact same source range. If the sources are different: ie first time you provide Sheet, then you provide a dedicated range, Excel doesn’t know those ranges are the same so it clears the previous filter.

Let me know if this helps.