Set excel filter and disable all filters

Help Studio
1

Hello.

I have some excel file in which I have to set filter on one column and then to disable all filters (including that one).
I’m trying to prevent users from changing other filters and to see other data except the row I should filter dinamicly.
What is the most propriate way to manage it?

The image depicts a section of a spreadsheet related to operational and IT risk management, highlighting an identified corrective measure (ID 71) concerning system development for AML with a status marked as open and adjusted deadlines. (Captioned by AI)
The image depicts a section of a spreadsheet related to operational and IT risk management, highlighting an identified corrective measure (ID 71) concerning system development for AML with a status marked as open and adjusted deadlines. (Captioned by AI)1871×265 12.8 KB

2

Hi @okalinic

Try this way

You can use the modern excel Filter activity in enable the Clear any existing filter

image

Regards,
Gowtham K

3

But, at first I have to set filter on one column and than to disable all filters, not to clear it.
Is it possible?

4

@okalinic

In same Filter activity you can try to Filter

Disable the Clear any existing Filter

Then Mention column name which column you want to filter, then Click the Configure Filter in this window you can mention your scenario

image
image966×380 21.4 KB

After filtering you can use the disable filters activity

5

Hi @okalinic,

Could you please the next steps below:

Step 1:
image

Step 2:
The image shows an Excel automation setup for filtering data, specifically configured to clear any existing filter on "Plan1". (Captioned by AI)

Step 3:

image
image729×499 14.6 KB

Hire is the project:
HowToTakeNextColumn.zip (10.3 KB)