Announcements
Hi All,Is it possible for delete an filter in online Excel sheet.
My files have that filter and now i cant create a table with power automate.
How can i resolve that?
Hi @frixel2,
It would be possible by using Office Scripts and the Run scripts action:
https://docs.microsoft.com/en-us/office/dev/scripts/overview/excel
Below is an example.
1. Create an Office Script in the Excel Online File. This should be possible via the Automate tab.
In this example I am clearing the filter from Column B in my Table1
function main(workbook: ExcelScript.Workbook) { let table1 = workbook.getTable("Table1"); // Clear filter on table table1 column B table1.getColumnByName("B") .getFilter() .clear(); }
2. Add Run script action to your flow and run this script for your Excel file
@Expiscornovus
Thanks for your answer, that keeps me opportunnities.
I have try it with the script so you tells above.
But this script is not remove the filter option from al fiels, This is a script for clear filter(s).
is it also possible for deleting the filter?
My script was just an example. You should be able to record your specific office script with the action recorder. So, I believe that would be possible.
Have a look at this:
https://docs.microsoft.com/en-us/office/dev/scripts/overview/excel#action-recorder
Thank you!! This solves a really annoying problem!
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
Congratulations to our 2026 Super Users!
Congratulations to our 2025 community superstars!
These are the community rock stars!
Stay up to date on forum activity by subscribing.
Haque 557
Valantis 328
David_MA 264 Super User 2026 Season 1
