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?
Thank you!! This solves a really annoying problem!
Hi @frixel2,
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
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?
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
WarrenBelz
146,745
Most Valuable Professional
RandyHayes
76,287
Super User 2024 Season 1
Pstork1
66,091
Most Valuable Professional