Need help with clearing filters on populated excel tables

(0) Share

Report

Posted on by ashraf999

Dear all,

I have managed to populate some data into created excel tables by power automate. However, I need to clear the filters that are automatically generated after the tables are created as the image below. I used the following script (after the image) from office scripts to clear those filters with no luck. Can you help me fix this problem?. Thank you

function main(workbook: ExcelScript.Workbook) {
    // Get the active worksheet
    const sheet = workbook.getActiveWorksheet();

    // Get all tables in the worksheet
    const tables = sheet.getTables();

    // Clear filters for all tables in the worksheet
    tables.forEach((table) => {
        const filter = table.getAutoFilter();
        if (filter) {
            filter.clearCriteria();
        }
    });

    // Clear filters applied directly to the worksheet
    const autofilter = sheet.getAutoFilter();
    if (autofilter) {
        autofilter.clearCriteria();
    }

    console.log("All filters cleared.");
}

Categories:

General topics

I have the same question (0)